Package org.apache.poi.ss.formula
package org.apache.poi.ss.formula
This package contains common internal POI code for manipulating formulas.
Client applications should not refer to these classes directly.
-
ClassDescriptionCommon functionality across file formats for evaluating formula cells.Manages a collection of
WorkbookEvaluator
s, in order to support evaluation of formulas across spreadsheets.Evaluates Conditional Formatting constraints.Evaluates Data Validation constraints.This class organizes and encapsulates all the pieces of information related to a single data validation configuration for a single cell.Not calling it OperatorType to avoid confusion for now with DataValidationConstraint.OperatorType.Not calling it ValidationType to avoid confusion for now with DataValidationConstraint.ValidationType.Abstracts a cell for the purpose of formula evaluation.Abstracted and cached version of a Conditional Format rule for use with aConditionalFormattingEvaluator
.Not calling it OperatorType to avoid confusion for now with other classes.Note: this class has a natural ordering that is inconsistent with equals.instances evaluate the values for a region and return the positive matches for the function type.Abstracts a name record for formula evaluation.
For POI internal use onlyAbstracts a sheet for the purpose of formula evaluation.
For POI internal use onlyAbstracts a workbook for the purpose of formula evaluation.
For POI internal use onlyShould be implemented by anyPtg
subclass that needs has an extern sheet index
For POI internal use onlyEncapsulates an encoded formula token array.This exception thrown when a supplied formula has incorrect syntax (or syntax currently not supported by POI).This class parses a formula string into a List of tokens in RPN order.Abstracts a workbook for the purpose of formula parsing.
For POI internal use onlyCommon logic for rendering formulas.
For POI internal use onlyAbstracts a workbook for the purpose of converting formula to text.
For POI internal use onlyUpdates Formulas as rows or sheets are shiftedEnumeration of various formula types.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'.Provides Lazy Evaluation to a 3D ReferenceContains all the contextual information required to evaluate an operation within a formula For POI internal use onlyEncapsulates logic to convert shared formulaa into non shared equivalentFormats sheet names for use in formula expressions.Optional Extension to the likes ofAreaEval
andAreaEvalBase
, which allows for looking up 3D (sheet+row+column) evaluationsCommon interface ofAreaEval
andAreaEvalBase
, for 2D (row+column) evaluationsShould be implemented by anyPtg
subclass that needs a workbook to render its formula.Evaluates formula cells.Provides access to aWorkbookEvaluator
, eg for use withCollaboratingWorkbooksEnvironment