net.sf.jxls.formula
Class Formula

java.lang.Object
  net.sf.jxls.formula.Formula

public class Formula
extends java.lang.Object

Represents formula cell

Author:

Leonid Vysochyn

Field Summary

protected org.apache.commons.logging.Log

log

Constructor Summary

Formula()

Formula(Formula f)

Formula(java.lang.String formula)

Method Summary

boolean	containsListRanges()
java.util.Set	findRefCells()
java.lang.String	getActualFormula()
java.lang.String	getAppliedFormula(java.util.Map listRanges, java.util.Map namedCells)
java.lang.Integer	getCellNum()
java.util.Set	getCellRefs()
java.lang.String	getFormula()
java.util.List	getFormulaParts()
java.lang.String	getInlineFormula(int n)
java.lang.Integer	getRowNum()
Sheet	getSheet()
boolean	isInline()
void	parseFormula()
void	removeCellRefs(java.util.Set cellRefsToRemove)
void	setCellNum(java.lang.Integer cellNum)
void	setFormula(java.lang.String formula)
void	setRowNum(java.lang.Integer rowNum)
void	setSheet(Sheet sheet)
java.lang.String	toString()
void	updateReplacedRefCellsCollection()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

log

protected final org.apache.commons.logging.Log log

Constructor Detail

Formula

public Formula(java.lang.String formula)

Formula

public Formula()

Formula

public Formula(Formula f)

Method Detail

getSheet

public Sheet getSheet()

setSheet

public void setSheet(Sheet sheet)

getFormula

public java.lang.String getFormula()

setFormula

public void setFormula(java.lang.String formula)

getRowNum

public java.lang.Integer getRowNum()

setRowNum

public void setRowNum(java.lang.Integer rowNum)

getCellNum

public java.lang.Integer getCellNum()

setCellNum

public void setCellNum(java.lang.Integer cellNum)

getCellRefs

public java.util.Set getCellRefs()

getFormulaParts

public java.util.List getFormulaParts()

isInline

public boolean isInline()

getInlineFormula

public java.lang.String getInlineFormula(int n)

getAppliedFormula

public java.lang.String getAppliedFormula(java.util.Map listRanges,
                                          java.util.Map namedCells)

Returns:

Formula string that should be set into Excel cell using POI

getActualFormula

public java.lang.String getActualFormula()

findRefCells

public java.util.Set findRefCells()

parseFormula

public void parseFormula()

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

containsListRanges

public boolean containsListRanges()

removeCellRefs

public void removeCellRefs(java.util.Set cellRefsToRemove)

updateReplacedRefCellsCollection

public void updateReplacedRefCellsCollection()