net.sf.jxls.formula
Class BaseFormulaResolver

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

All Implemented Interfaces:

FormulaResolver

Direct Known Subclasses:

CommonFormulaResolver

public abstract class BaseFormulaResolver
extends java.lang.Object
implements FormulaResolver

Base class for FormulaResolver interface implementations

Author:

Leonid Vysochyn

Field Summary

protected java.lang.String	cellRangeSeparator
protected static java.lang.String	formulaListRangeToken
protected org.apache.commons.logging.Log	log
protected static java.lang.String	regexCellCharPart
protected static java.lang.String	regexCellDigitPart
protected static java.lang.String	regexCellRef
protected static java.util.regex.Pattern	regexCellRefPattern

Constructor Summary

BaseFormulaResolver()

Method Summary

(package private) java.lang.String	buildCommaSeparatedListOfCells(java.lang.String refSheetName, java.util.List cells)
(package private) java.lang.String	detectCellRange(java.lang.String refSheetName, java.util.List cells)
(package private) java.util.Set	findRefCells(java.lang.String formulaString)
static java.lang.String	getFormulaListRangeToken()
(package private) java.lang.String	getRefCellName(java.lang.String refSheetName, java.lang.String cellName)
(package private) boolean	isColumnRange(java.util.List cells)
(package private) boolean	isRowRange(java.util.List cells)
(package private) java.lang.String	replaceListRanges(Formula formula) Method to replace coded list ranges (like @department.staff.payment@) with excel range string like B10:B20
static void	setFormulaListRangeToken(java.lang.String formulaListRangeToken)

Methods inherited from class java.lang.Object

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

Methods inherited from interface net.sf.jxls.formula.FormulaResolver

resolve

Field Detail

regexCellRef

protected static final java.lang.String regexCellRef

See Also:

Constant Field Values

regexCellRefPattern

protected static final java.util.regex.Pattern regexCellRefPattern

regexCellCharPart

protected static final java.lang.String regexCellCharPart

See Also:

Constant Field Values

regexCellDigitPart

protected static final java.lang.String regexCellDigitPart

See Also:

Constant Field Values

cellRangeSeparator

protected java.lang.String cellRangeSeparator

formulaListRangeToken

protected static java.lang.String formulaListRangeToken

log

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

Constructor Detail

BaseFormulaResolver

public BaseFormulaResolver()

Method Detail

findRefCells

java.util.Set findRefCells(java.lang.String formulaString)

buildCommaSeparatedListOfCells

java.lang.String buildCommaSeparatedListOfCells(java.lang.String refSheetName,
                                                java.util.List cells)

detectCellRange

java.lang.String detectCellRange(java.lang.String refSheetName,
                                 java.util.List cells)

getRefCellName

java.lang.String getRefCellName(java.lang.String refSheetName,
                                java.lang.String cellName)

isColumnRange

boolean isColumnRange(java.util.List cells)

isRowRange

boolean isRowRange(java.util.List cells)

replaceListRanges

java.lang.String replaceListRanges(Formula formula)

Method to replace coded list ranges (like @department.staff.payment@) with excel range string like B10:B20

Parameters:

formula - - Formula object to replace list ranges in

Returns:

Formula string that should be set into Excel cell using POI

getFormulaListRangeToken

public static java.lang.String getFormulaListRangeToken()

setFormulaListRangeToken

public static void setFormulaListRangeToken(java.lang.String formulaListRangeToken)