Uses of Interface
org.apache.poi.ss.formula.eval.ValueEval
Packages that use ValueEval
Package
Description
This package contains common internal POI code for manipulating formulas.
-
Uses of ValueEval in org.apache.poi.ss.formula
Subinterfaces of ValueEval in org.apache.poi.ss.formulaModifier and TypeInterfaceDescriptioninterface
Optional Extension to the likes ofAreaEval
andAreaEvalBase
, which allows for looking up 3D (sheet+row+column) evaluationsinterface
Common interface ofAreaEval
andAreaEvalBase
, for 2D (row+column) evaluationsClasses in org.apache.poi.ss.formula that implement ValueEvalModifier and TypeClassDescriptionfinal class
final class
Provides Lazy Evaluation to a 3D ReferenceMethods in org.apache.poi.ss.formula that return ValueEvalModifier and TypeMethodDescriptionstatic ValueEval
WorkbookEvaluator.dereferenceResult
(ValueEval evaluationResult, int srcRowNum, int srcColNum) Dereferences a single value from any AreaEval or RefEval evaluation result.WorkbookEvaluator.evaluate
(String formula, CellReference ref) Evaluate a formula outside a cell value, e.g.WorkbookEvaluator.evaluate
(String formula, CellReference target, CellRangeAddressBase region) Some expressions need to be evaluated in terms of an offset from the top left corner of a region, such as some data validation and conditional format expressions, when those constraints apply to contiguous cells.WorkbookEvaluator.evaluate
(EvaluationCell srcCell) WorkbookEvaluator.evaluateList
(String formula, CellReference target, CellRangeAddressBase region) Some expressions need to be evaluated in terms of an offset from the top left corner of a region, such as some data validation and conditional format expressions, when those constraints apply to contiguous cells.OperationEvaluationContext.getArea3DEval
(Area3DPtg aptg) OperationEvaluationContext.getArea3DEval
(Area3DPxg aptg) OperationEvaluationContext.getAreaEval
(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex) OperationEvaluationContext.getAreaValueEval
(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, Object[][] tokens) OperationEvaluationContext.getDynamicReference
(String workbookName, String sheetName, String refStrPart1, String refStrPart2, boolean isA1Style) Resolves a cell or area reference dynamically.LazyRefEval.getInnerValueEval
(int sheetIndex) OperationEvaluationContext.getNameXEval
(NameXPtg nameXPtg) OperationEvaluationContext.getNameXEval
(NameXPxg nameXPxg) OperationEvaluationContext.getRef3DEval
(Ref3DPtg rptg) OperationEvaluationContext.getRef3DEval
(Ref3DPxg rptg) OperationEvaluationContext.getRefEval
(int rowIndex, int columnIndex) CacheAreaEval.getRelativeValue
(int relativeRowIndex, int relativeColumnIndex) CacheAreaEval.getRelativeValue
(int sheetIndex, int relativeRowIndex, int relativeColumnIndex) ThreeDEval.getValue
(int sheetIndex, int rowIndex, int columnIndex) TwoDEval.getValue
(int rowIndex, int columnIndex) Methods in org.apache.poi.ss.formula that return types with arguments of type ValueEvalModifier and TypeMethodDescriptionDataValidationEvaluator.getValidationValuesForCell
(CellReference cell) IfDataValidationEvaluator.getValidationForCell(CellReference)
returns an instance, and theDataValidationConstraint.ValidationType
isDataValidationConstraint.ValidationType.LIST
, return the valid values, whether they are from a static list or cell range.DataValidationEvaluator.getValidationValuesForConstraint
(DataValidationEvaluator.DataValidationContext context) static so enums can reference it without creating a whole instanceMethods in org.apache.poi.ss.formula with parameters of type ValueEvalModifier and TypeMethodDescriptionstatic ValueEval
WorkbookEvaluator.dereferenceResult
(ValueEval evaluationResult, int srcRowNum, int srcColNum) Dereferences a single value from any AreaEval or RefEval evaluation result.Constructors in org.apache.poi.ss.formula with parameters of type ValueEvalModifierConstructorDescriptionCacheAreaEval
(int firstRow, int firstColumn, int lastRow, int lastColumn, ValueEval[] values) CacheAreaEval
(AreaI ptg, ValueEval[] values) -
Uses of ValueEval in org.apache.poi.ss.formula.eval
Subinterfaces of ValueEval in org.apache.poi.ss.formula.evalModifier and TypeInterfaceDescriptioninterface
Evaluation of 2D (Row+Column) and 3D (Sheet+Row+Column) areasinterface
interface
RefEval is the super interface for Ref2D and Ref3DEval.interface
Classes in org.apache.poi.ss.formula.eval that implement ValueEvalModifier and TypeClassDescriptionclass
final class
final class
final class
Evaluations for formula errorsfinal class
Evaluation of a Name defined in a Sheet or Workbook scopefinal class
final class
Represents the (intermediate) evaluated result of a missing function argument.final class
class
Common base class for implementors ofRefEval
class
Handling of a list of values, e.g.final class
Methods in org.apache.poi.ss.formula.eval that return ValueEvalModifier and TypeMethodDescriptionstatic ValueEval
OperandResolver.chooseSingleElementFromArea
(AreaEval ae, int srcCellRow, int srcCellCol) Implements (some perhaps not well known) Excel functionality to select a single cell from an area depending on the coordinates of the calling cell.RelationalOperationEval.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) This is a description of how the relational operators apply in MS Excel.TwoOperandNumericOperation.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) RelationalOperationEval.evaluateArray
(ValueEval[] args, int srcRowIndex, int srcColumnIndex) TwoOperandNumericOperation.evaluateArray
(ValueEval[] args, int srcRowIndex, int srcColumnIndex) AreaEval.getAbsoluteValue
(int row, int col) final ValueEval
AreaEvalBase.getAbsoluteValue
(int row, int col) static ValueEval
OperandResolver.getElementFromArray
(AreaEval ae, EvaluationCell cell) Retrieves a single value from an area evaluation utilizing the 2D indices of the cell within its own area reference to index the value in the area evaluation.RefEval.getInnerValueEval
(int sheetIndex) AreaEval.getRelativeValue
(int relativeRowIndex, int relativeColumnIndex) abstract ValueEval
AreaEvalBase.getRelativeValue
(int relativeRowIndex, int relativeColumnIndex) abstract ValueEval
AreaEvalBase.getRelativeValue
(int sheetIndex, int relativeRowIndex, int relativeColumnIndex) static ValueEval
OperandResolver.getSingleValue
(ValueEval arg, int srcCellRow, int srcCellCol) Retrieves a single value from a variety of different argument types according to standard Excel rules.final ValueEval
AreaEvalBase.getValue
(int row, int col) final ValueEval
AreaEvalBase.getValue
(int sheetIndex, int row, int col) Methods in org.apache.poi.ss.formula.eval that return types with arguments of type ValueEvalMethods in org.apache.poi.ss.formula.eval with parameters of type ValueEvalModifier and TypeMethodDescriptionstatic Boolean
OperandResolver.coerceValueToBoolean
(ValueEval ve, boolean stringsAreBlanks) static double
OperandResolver.coerceValueToDouble
(ValueEval ev) Applies some conversion rules if the supplied value is not already a number.static int
OperandResolver.coerceValueToInt
(ValueEval ev) Applies some conversion rules if the supplied value is not already an integer.
Value is first coerced to a double ( See coerceValueToDouble() ).static String
OperandResolver.coerceValueToString
(ValueEval ve) RelationalOperationEval.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) This is a description of how the relational operators apply in MS Excel.TwoOperandNumericOperation.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) RelationalOperationEval.evaluateArray
(ValueEval[] args, int srcRowIndex, int srcColumnIndex) TwoOperandNumericOperation.evaluateArray
(ValueEval[] args, int srcRowIndex, int srcColumnIndex) static ValueEval
OperandResolver.getSingleValue
(ValueEval arg, int srcCellRow, int srcCellCol) Retrieves a single value from a variety of different argument types according to standard Excel rules.protected final double
TwoOperandNumericOperation.singleOperandEvaluate
(ValueEval arg, int srcCellRow, int srcCellCol) Constructors in org.apache.poi.ss.formula.eval with parameters of type ValueEval -
Uses of ValueEval in org.apache.poi.ss.formula.eval.forked
Methods in org.apache.poi.ss.formula.eval.forked that return ValueEvalModifier and TypeMethodDescriptionIf cell contains a formula, the formula is evaluated and returned, else the CellValue simply copies the appropriate cell value from the cell and also its cell type.Methods in org.apache.poi.ss.formula.eval.forked with parameters of type ValueEvalModifier and TypeMethodDescriptionvoid
ForkedEvaluator.updateCell
(String sheetName, int rowIndex, int columnIndex, ValueEval value) Sets the specified cell to the supplied value -
Uses of ValueEval in org.apache.poi.ss.formula.functions
Methods in org.apache.poi.ss.formula.functions that return ValueEvalModifier and TypeMethodDescriptionBin2Dec.evaluate
(ValueEval[] args, OperationEvaluationContext ec) final ValueEval
final ValueEval
Column.evaluate
(int srcRowIndex, int srcColumnIndex) Complex.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix) Complex.evaluate
(ValueEval[] args, OperationEvaluationContext ec) DateFunc.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Days360.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Dec2Bin.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Dec2Hex.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Delta.evaluate
(ValueEval[] args, OperationEvaluationContext ec) DStarRunner.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval database, ValueEval filterColumn, ValueEval conditionDatabase) final ValueEval
EDate.evaluate
(ValueEval[] args, OperationEvaluationContext ec) EOMonth.evaluate
(ValueEval[] args, OperationEvaluationContext ec) FactDouble.evaluate
(ValueEval[] args, OperationEvaluationContext ec) FinanceFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) FinanceFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) FinanceFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4) final ValueEval
final ValueEval
final ValueEval
final ValueEval
final ValueEval
FreeRefFunction.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Function0Arg.evaluate
(int srcRowIndex, int srcColumnIndex) Function3Arg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Function4Arg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Hex2Dec.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Hlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Hlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) IfFunc.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Imaginary.evaluate
(ValueEval[] args, OperationEvaluationContext ec) ImReal.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Index.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Indirect.evaluate
(ValueEval[] args, OperationEvaluationContext ec) LinearRegressionFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) Lookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) MatrixFunction.TwoArrayArg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) final ValueEval
Na.evaluate
(int srcCellRow, int srcCellCol) Now.evaluate
(int srcRowIndex, int srcColumnIndex) final ValueEval
NumericFunction.TwoArg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) Oct2Dec.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Quotient.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval venumerator, ValueEval vedenominator) Quotient.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Replace.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) RowFunc.evaluate
(int srcRowIndex, int srcColumnIndex) Substitute.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Substitute.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) final ValueEval
TimeFunc.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Today.evaluate
(int srcRowIndex, int srcColumnIndex) Vlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Vlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval lookup_value, ValueEval table_array, ValueEval col_index, ValueEval range_lookup) Perform WEEKDAY(date, returnOption) function.WeekNum.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE) WeekNum.evaluate
(ValueEval[] args, OperationEvaluationContext ec) ArrayFunction.evaluateArray
(ValueEval[] args, int srcRowIndex, int srcColumnIndex) protected abstract ValueEval
TextFunction.evaluateFunc
(ValueEval[] args, int srcCellRow, int srcCellCol) DGet.getResult()
DMax.getResult()
DMin.getResult()
DSum.getResult()
IDStarAlgorithm.getResult()
Return a result ValueEval that will be the result of the calculation.Methods in org.apache.poi.ss.formula.functions with parameters of type ValueEvalModifier and TypeMethodDescriptiondouble[]
MatrixFunction.MutableValueCollector.collectValues
(ValueEval... operands) protected abstract double[]
MatrixFunction.OneArrayArg.collectValues
(ValueEval arg) protected abstract double[]
MatrixFunction.TwoArrayArg.collectValues
(ValueEval arg) double
protected abstract double
protected final double
double
Bin2Dec.evaluate
(ValueEval[] args, OperationEvaluationContext ec) final ValueEval
final ValueEval
Complex.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix) Complex.evaluate
(ValueEval[] args, OperationEvaluationContext ec) DateFunc.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Days360.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Dec2Bin.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Dec2Hex.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Delta.evaluate
(ValueEval[] args, OperationEvaluationContext ec) DStarRunner.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval database, ValueEval filterColumn, ValueEval conditionDatabase) final ValueEval
EDate.evaluate
(ValueEval[] args, OperationEvaluationContext ec) EOMonth.evaluate
(ValueEval[] args, OperationEvaluationContext ec) FactDouble.evaluate
(ValueEval[] args, OperationEvaluationContext ec) FinanceFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) FinanceFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) FinanceFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4) final ValueEval
final ValueEval
final ValueEval
final ValueEval
final ValueEval
FreeRefFunction.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Function3Arg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Function4Arg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Hex2Dec.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Hlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Hlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) IfFunc.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Imaginary.evaluate
(ValueEval[] args, OperationEvaluationContext ec) ImReal.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Index.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Indirect.evaluate
(ValueEval[] args, OperationEvaluationContext ec) LinearRegressionFunction.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) protected abstract boolean
Lookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) MatrixFunction.TwoArrayArg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) final ValueEval
final ValueEval
NumericFunction.TwoArg.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) Oct2Dec.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Quotient.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval venumerator, ValueEval vedenominator) Quotient.evaluate
(ValueEval[] args, OperationEvaluationContext ec) Replace.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Substitute.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Substitute.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) final ValueEval
TimeFunc.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Vlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Vlookup.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval lookup_value, ValueEval table_array, ValueEval col_index, ValueEval range_lookup) Perform WEEKDAY(date, returnOption) function.WeekNum.evaluate
(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE) WeekNum.evaluate
(ValueEval[] args, OperationEvaluationContext ec) ArrayFunction.evaluateArray
(ValueEval[] args, int srcRowIndex, int srcColumnIndex) protected static double
TextFunction.evaluateDoubleArg
(ValueEval arg, int srcCellRow, int srcCellCol) static int
Choose.evaluateFirstArg
(ValueEval arg0, int srcRowIndex, int srcColumnIndex) static boolean
IfFunc.evaluateFirstArg
(ValueEval arg, int srcCellRow, int srcCellCol) protected abstract ValueEval
TextFunction.evaluateFunc
(ValueEval[] args, int srcCellRow, int srcCellCol) protected static int
TextFunction.evaluateIntArg
(ValueEval arg, int srcCellRow, int srcCellCol) protected static String
TextFunction.evaluateStringArg
(ValueEval eval, int srcRow, int srcCol) protected final double[]
MultiOperandNumericFunction.getNumberArray
(ValueEval[] operands) Returns a double array that contains values for the numeric cells from among the list of operands.boolean
boolean
boolean
DGet.processMatch
(ValueEval eval) boolean
DMax.processMatch
(ValueEval eval) boolean
DMin.processMatch
(ValueEval eval) boolean
DSum.processMatch
(ValueEval eval) boolean
IDStarAlgorithm.processMatch
(ValueEval eval) Process a match that is found during a run through a database.protected final double
MatrixFunction.singleOperandEvaluate
(ValueEval arg, int srcCellRow, int srcCellCol) protected static double
NumericFunction.singleOperandEvaluate
(ValueEval arg, int srcRowIndex, int srcColumnIndex)