See: Description
Interface  Description 

DependencyTracker 
Interface for constructing the formula dependency.

EvaluationCell 
Abstracts a cell for the purpose of formula evaluation.

EvaluationName 
Abstracts a name record for formula evaluation.
For POI internal use only 
EvaluationSheet 
Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only 
EvaluationWorkbook 
Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only 
ExternSheetReferenceToken 
Should be implemented by any
org.zkoss.poi.hssf.record.formula.Ptg subclass that needs has an extern sheet index For POI internal use only 
FormulaParsingWorkbook 
Abstracts a workbook for the purpose of formula parsing.
For POI internal use only 
FormulaRenderingWorkbook 
Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only 
IStabilityClassifier 
Used to help optimise cell evaluation result caching by allowing applications to specify which
parts of a workbook are final.
The term final is introduced here to denote immutability or 'having constant definition'. 
TwoDEval 
Common interface of
AreaEval and org.zkoss.poi.hssf.record.formula.eval.AreaEvalBase 
WorkbookDependentFormula 
Should be implemented by any
org.zkoss.poi.hssf.record.formula.Ptg subclass that needs a workbook to render its formula. 
WorkbookEvaluator.CacheManager 
Class  Description 

AreaEvalHelper 
Formula Area evaluation helper class.

CollaboratingWorkbooksEnvironment 
Manages a collection of
WorkbookEvaluator s, in order to support evaluation of formulas
across spreadsheets.For POI internal use only 
ColumnCache 
Performance optimization for
Vlookup . 
EvaluationWorkbook.ExternalName  
EvaluationWorkbook.ExternalSheet  
Formula 
Encapsulates an encoded formula token array.

FormulaParser  Deprecated
since 5.4.0 replaced by
FormulaTokenParser 
FormulaRenderer 
Common logic for rendering formulas.
For POI internal use only 
FormulaShifter  
FormulaTokenParser  
FormulaType 
Enumeration of various formula types.
For POI internal use only 
LazyAreaEval  
LazyRefEval  
NameRangeEval  
OperationEvaluationContext 
Contains all the contextual information required to evaluate an operation
within a formula
For POI internal use only

PtgShifter 
Shift a cell address in a
Ptg according to cell operations including cut, copy/paste, insertion, and deletion. 
SharedFormula 
Encapsulates logic to convert shared formulaa into non shared equivalent

SheetNameFormatter 
Formats sheet names for use in formula expressions.

SheetRefEvaluator  
SortedValues  
UserDefinedFunction 
Common entry point for all userdefined (nonbuiltin) functions (where
AbstractFunctionPtg.field_2_fnc_index == 255)

WorkbookEvaluator 
Evaluates formula cells.
For performance reasons, this class keeps a cache of all previously calculated intermediate cell values. 
Exception  Description 

CollaboratingWorkbooksEnvironment.WorkbookNotFoundException  
FormulaParseException 
This exception thrown when a supplied formula has incorrect syntax (or syntax currently not
supported by POI).

Copyright © 2021. All rights reserved.