Package org.jxls.formula

Class StandardFormulaProcessor

java.lang.Object

org.jxls.formula.AbstractFormulaProcessor

org.jxls.formula.StandardFormulaProcessor

All Implemented Interfaces:

FormulaProcessor

public class StandardFormulaProcessor
extends AbstractFormulaProcessor

This is a standard formula processor implementation which takes into account all the performed cell transformations to properly evaluate all the formulas even for complex templates.

However for simple templates you may consider using the FastFormulaProcessor instead because it is much faster although may not provide the correct results for more complex cases.

Field Summary

Fields inherited from class org.jxls.formula.AbstractFormulaProcessor

regexCellRef, regexExcludePrefixSymbols, regexJointedCellRefPattern, regexJointedLookBehind

Constructor Summary

Constructors

Constructor	Description
StandardFormulaProcessor()

Method Summary

Modifier and Type	Method	Description
void	processAreaFormulas(Transformer transformer, Area area)	The method transforms all the formula cells according to the command transformations happened during the area processing
protected void	processTargetFormulaCell(int i, CellData formulaCellData, org.jxls.formula.AbstractFormulaProcessor.FormulaProcessorContext fpc)

Methods inherited from class org.jxls.formula.AbstractFormulaProcessor

buildJointedCellRefMap, buildTargetCellRefMap, createFormulaProcessorContext, createTargetCellRefListByColumn, getCellRefsFromJointedCellRef, getFormulaCellRefs, getJointedCellRefs, groupByColRange, groupByRanges, groupByRowRange, processTargetFormula, processTargetFormulaCells, sheetNameRegex

Methods inherited from class java.lang.Object

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

Constructor Details

StandardFormulaProcessor

public StandardFormulaProcessor()

Method Details

processAreaFormulas

public void processAreaFormulas(Transformer transformer,
 Area area)

The method transforms all the formula cells according to the command transformations happened during the area processing

Parameters:

transformer - transformer to use for formula processing

area - - xls area for which the formula processing is invoked

processTargetFormulaCell

protected void processTargetFormulaCell(int i,
 CellData formulaCellData,
 org.jxls.formula.AbstractFormulaProcessor.FormulaProcessorContext fpc)

Specified by:

processTargetFormulaCell in class AbstractFormulaProcessor