Uses of Package
org.apache.poi.ss.formula

Packages that use org.apache.poi.ss.formula

Package	Description
org.apache.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.record	Record package contains class representations for XLS binary strutures.
org.apache.poi.hssf.record.aggregates	record aggregates are not real "records" but collections of records that act as a single record.
org.apache.poi.hssf.record.cf
org.apache.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.hssf.usermodel.helpers
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.formula.eval
org.apache.poi.ss.formula.eval.forked
org.apache.poi.ss.formula.functions
org.apache.poi.ss.formula.ptg	formula package contains binary PTG structures used in Formulas
org.apache.poi.ss.usermodel
org.apache.poi.ss.usermodel.helpers
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel
org.apache.poi.xssf.usermodel.helpers

Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.model

Class and Description
EvaluationWorkbook.ExternalName
EvaluationWorkbook.ExternalSheet
FormulaParseException This exception thrown when a supplied formula has incorrect syntax (or syntax currently not supported by POI).
FormulaShifter Updates Formulas as rows or sheets are shifted
FormulaType Enumeration of various formula types.

Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.record

Class and Description
Formula Encapsulates an encoded formula token array.

Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.record.aggregates

Class and Description
FormulaShifter Updates Formulas as rows or sheets are shifted

Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.record.cf

Class and Description
Formula Encapsulates an encoded formula token array.

Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.usermodel

Class and Description
BaseFormulaEvaluator Common functionality across file formats for evaluating formula cells.
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
EvaluationWorkbook.ExternalName
EvaluationWorkbook.ExternalSheet
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'.
SheetIdentifier
WorkbookEvaluatorProvider Provides access to a WorkbookEvaluator, eg for use with CollaboratingWorkbooksEnvironment

Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.usermodel.helpers

Class and Description
FormulaShifter Updates Formulas as rows or sheets are shifted

Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.formula

Class and Description
BaseFormulaEvaluator Common functionality across file formats for evaluating formula cells.
CollaboratingWorkbooksEnvironment Manages a collection of WorkbookEvaluators, in order to support evaluation of formulas across spreadsheets.
CollaboratingWorkbooksEnvironment.WorkbookNotFoundException
DataValidationEvaluator Evaluates Data Validation constraints.
DataValidationEvaluator.DataValidationContext This class organizes and encapsulates all the pieces of information related to a single data validation configuration for a single cell.
DataValidationEvaluator.OperatorEnum Not calling it OperatorType to avoid confusion for now with DataValidationConstraint.OperatorType.
DataValidationEvaluator.ValidationEnum Not calling it ValidationType to avoid confusion for now with DataValidationConstraint.ValidationType.
EvaluationCell Abstracts a cell for the purpose of formula evaluation.
EvaluationConditionalFormatRule Abstracted and cached version of a Conditional Format rule for use with a ConditionalFormattingEvaluator.
EvaluationConditionalFormatRule.OperatorEnum Not calling it OperatorType to avoid confusion for now with other classes.
EvaluationConditionalFormatRule.ValueAndFormat Note: this class has a natural ordering that is inconsistent with equals.
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
EvaluationWorkbook.ExternalName
EvaluationWorkbook.ExternalSheet
Formula Encapsulates an encoded formula token array.
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
FormulaShifter Updates Formulas as rows or sheets are shifted
FormulaType Enumeration of various formula types.
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'.
NameIdentifier
SheetIdentifier
SheetRange
ThreeDEval Optional Extension to the likes of AreaEval and AreaEvalBase, which allows for looking up 3D (sheet+row+column) evaluations
TwoDEval Common interface of AreaEval and AreaEvalBase, for 2D (row+column) evaluations
WorkbookEvaluator Evaluates formula cells. For performance reasons, this class keeps a cache of all previously calculated intermediate cell values.
WorkbookEvaluatorProvider Provides access to a WorkbookEvaluator, eg for use with CollaboratingWorkbooksEnvironment

Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.formula.eval

Class and Description
EvaluationCell Abstracts a cell for the purpose of formula evaluation.
EvaluationName Abstracts a name record for formula evaluation. For POI internal use only
SheetRange
ThreeDEval Optional Extension to the likes of AreaEval and AreaEvalBase, which allows for looking up 3D (sheet+row+column) evaluations
TwoDEval Common interface of AreaEval and AreaEvalBase, for 2D (row+column) evaluations

Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.formula.eval.forked

Class and Description
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'.

Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.formula.functions

Class and Description
OperationEvaluationContext Contains all the contextual information required to evaluate an operation within a formula For POI internal use only

Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.formula.ptg

Class and Description
ExternSheetReferenceToken Should be implemented by any Ptg subclass that needs has an extern sheet index For POI internal use only
FormulaRenderingWorkbook Abstracts a workbook for the purpose of converting formula to text. For POI internal use only
SheetIdentifier
WorkbookDependentFormula Should be implemented by any Ptg subclass that needs a workbook to render its formula.

Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.usermodel

Class and Description
ConditionalFormattingEvaluator Evaluates Conditional Formatting constraints.
FormulaParseException This exception thrown when a supplied formula has incorrect syntax (or syntax currently not supported by POI).

Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.usermodel.helpers

Class and Description
FormulaShifter Updates Formulas as rows or sheets are shifted

Classes in org.apache.poi.ss.formula used by org.apache.poi.xssf.streaming

Class and Description
BaseFormulaEvaluator Common functionality across file formats for evaluating formula cells.
EvaluationCell Abstracts a cell for the purpose of formula evaluation.
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
FormulaParseException This exception thrown when a supplied formula has incorrect syntax (or syntax currently not supported by POI).
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'.
WorkbookEvaluatorProvider Provides access to a WorkbookEvaluator, eg for use with CollaboratingWorkbooksEnvironment

Classes in org.apache.poi.ss.formula used by org.apache.poi.xssf.usermodel

Class and Description
BaseFormulaEvaluator Common functionality across file formats for evaluating formula cells.
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
EvaluationWorkbook.ExternalName
EvaluationWorkbook.ExternalSheet
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'.
SheetIdentifier
WorkbookEvaluator Evaluates formula cells. For performance reasons, this class keeps a cache of all previously calculated intermediate cell values.
WorkbookEvaluatorProvider Provides access to a WorkbookEvaluator, eg for use with CollaboratingWorkbooksEnvironment

Classes in org.apache.poi.ss.formula used by org.apache.poi.xssf.usermodel.helpers

Class and Description
FormulaShifter Updates Formulas as rows or sheets are shifted