Uses of Package
org.apache.poi.ss.formula
-
Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.model Class 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 shiftedFormulaType Enumeration of various formula types. -
Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.record Class Description Formula Encapsulates an encoded formula token array. -
Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.record.aggregates Class 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 Description Formula Encapsulates an encoded formula token array. -
Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.usermodel Class 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 onlyEvaluationSheet Abstracts a sheet for the purpose of formula evaluation.
For POI internal use onlyEvaluationWorkbook Abstracts a workbook for the purpose of formula evaluation.
For POI internal use onlyEvaluationWorkbook.ExternalName EvaluationWorkbook.ExternalSheet FormulaParsingWorkbook Abstracts a workbook for the purpose of formula parsing.
For POI internal use onlyFormulaRenderingWorkbook Abstracts a workbook for the purpose of converting formula to text.
For POI internal use onlyIStabilityClassifier 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 aWorkbookEvaluator
, eg for use withCollaboratingWorkbooksEnvironment
-
Classes in org.apache.poi.ss.formula used by org.apache.poi.hssf.usermodel.helpers Class 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 Description BaseFormulaEvaluator Common functionality across file formats for evaluating formula cells.CollaboratingWorkbooksEnvironment Manages a collection ofWorkbookEvaluator
s, 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 aConditionalFormattingEvaluator
.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 onlyEvaluationSheet Abstracts a sheet for the purpose of formula evaluation.
For POI internal use onlyEvaluationWorkbook Abstracts a workbook for the purpose of formula evaluation.
For POI internal use onlyEvaluationWorkbook.ExternalName EvaluationWorkbook.ExternalSheet Formula Encapsulates an encoded formula token array.FormulaParsingWorkbook Abstracts a workbook for the purpose of formula parsing.
For POI internal use onlyFormulaRenderingWorkbook Abstracts a workbook for the purpose of converting formula to text.
For POI internal use onlyFormulaShifter Updates Formulas as rows or sheets are shiftedFormulaType 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 ofAreaEval
andAreaEvalBase
, which allows for looking up 3D (sheet+row+column) evaluationsTwoDEval Common interface ofAreaEval
andAreaEvalBase
, for 2D (row+column) evaluationsWorkbookEvaluator Evaluates formula cells.WorkbookEvaluatorProvider Provides access to aWorkbookEvaluator
, eg for use withCollaboratingWorkbooksEnvironment
-
Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.formula.eval Class Description EvaluationCell Abstracts a cell for the purpose of formula evaluation.EvaluationName Abstracts a name record for formula evaluation.
For POI internal use onlySheetRange ThreeDEval Optional Extension to the likes ofAreaEval
andAreaEvalBase
, which allows for looking up 3D (sheet+row+column) evaluationsTwoDEval Common interface ofAreaEval
andAreaEvalBase
, for 2D (row+column) evaluations -
Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.formula.eval.forked Class 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 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 Description ExternSheetReferenceToken Should be implemented by anyPtg
subclass that needs has an extern sheet index
For POI internal use onlyFormulaRenderingWorkbook Abstracts a workbook for the purpose of converting formula to text.
For POI internal use onlySheetIdentifier WorkbookDependentFormula Should be implemented by anyPtg
subclass that needs a workbook to render its formula. -
Classes in org.apache.poi.ss.formula used by org.apache.poi.ss.usermodel Class 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 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 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 onlyEvaluationWorkbook Abstracts a workbook for the purpose of formula evaluation.
For POI internal use onlyFormulaParseException 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 onlyFormulaRenderingWorkbook Abstracts a workbook for the purpose of converting formula to text.
For POI internal use onlyIStabilityClassifier 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 aWorkbookEvaluator
, eg for use withCollaboratingWorkbooksEnvironment
-
Classes in org.apache.poi.ss.formula used by org.apache.poi.xssf.usermodel Class 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 onlyEvaluationSheet Abstracts a sheet for the purpose of formula evaluation.
For POI internal use onlyEvaluationWorkbook Abstracts a workbook for the purpose of formula evaluation.
For POI internal use onlyEvaluationWorkbook.ExternalName EvaluationWorkbook.ExternalSheet FormulaParsingWorkbook Abstracts a workbook for the purpose of formula parsing.
For POI internal use onlyFormulaRenderingWorkbook Abstracts a workbook for the purpose of converting formula to text.
For POI internal use onlyIStabilityClassifier 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.WorkbookEvaluatorProvider Provides access to aWorkbookEvaluator
, eg for use withCollaboratingWorkbooksEnvironment
-
Classes in org.apache.poi.ss.formula used by org.apache.poi.xssf.usermodel.helpers Class Description FormulaShifter Updates Formulas as rows or sheets are shifted