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 TypeInterfaceDescriptioninterfaceOptional Extension to the likes ofAreaEvalandAreaEvalBase, which allows for looking up 3D (sheet+row+column) evaluationsinterfaceCommon interface ofAreaEvalandAreaEvalBase, for 2D (row+column) evaluationsClasses in org.apache.poi.ss.formula that implement ValueEvalModifier and TypeClassDescriptionfinal classfinal classProvides Lazy Evaluation to a 3D ReferenceMethods in org.apache.poi.ss.formula that return ValueEvalModifier and TypeMethodDescriptionstatic ValueEvalWorkbookEvaluator.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.ValidationTypeisDataValidationConstraint.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 ValueEvalWorkbookEvaluator.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 TypeInterfaceDescriptioninterfaceEvaluation of 2D (Row+Column) and 3D (Sheet+Row+Column) areasinterfaceinterfaceRefEval is the super interface for Ref2D and Ref3DEval.interfaceClasses in org.apache.poi.ss.formula.eval that implement ValueEvalModifier and TypeClassDescriptionclassfinal classfinal classfinal classEvaluations for formula errorsfinal classEvaluation of a Name defined in a Sheet or Workbook scopefinal classfinal classRepresents the (intermediate) evaluated result of a missing function argument.final classclassCommon base class for implementors ofRefEvalclassHandling of a list of values, e.g.final classMethods in org.apache.poi.ss.formula.eval that return ValueEvalModifier and TypeMethodDescriptionstatic ValueEvalOperandResolver.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 ValueEvalAreaEvalBase.getAbsoluteValue(int row, int col) static ValueEvalOperandResolver.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 ValueEvalAreaEvalBase.getRelativeValue(int relativeRowIndex, int relativeColumnIndex) abstract ValueEvalAreaEvalBase.getRelativeValue(int sheetIndex, int relativeRowIndex, int relativeColumnIndex) static ValueEvalOperandResolver.getSingleValue(ValueEval arg, int srcCellRow, int srcCellCol) Retrieves a single value from a variety of different argument types according to standard Excel rules.final ValueEvalAreaEvalBase.getValue(int row, int col) final ValueEvalAreaEvalBase.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 BooleanOperandResolver.coerceValueToBoolean(ValueEval ve, boolean stringsAreBlanks) static doubleOperandResolver.coerceValueToDouble(ValueEval ev) Applies some conversion rules if the supplied value is not already a number.static intOperandResolver.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 StringOperandResolver.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 ValueEvalOperandResolver.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 doubleTwoOperandNumericOperation.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 TypeMethodDescriptionvoidForkedEvaluator.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 ValueEvalfinal ValueEvalColumn.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 ValueEvalEDate.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 ValueEvalfinal ValueEvalfinal ValueEvalfinal ValueEvalfinal ValueEvalFreeRefFunction.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 ValueEvalNa.evaluate(int srcCellRow, int srcCellCol) Now.evaluate(int srcRowIndex, int srcColumnIndex) final ValueEvalNumericFunction.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 ValueEvalTimeFunc.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 ValueEvalTextFunction.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) doubleprotected abstract doubleprotected final doubledoubleBin2Dec.evaluate(ValueEval[] args, OperationEvaluationContext ec) final ValueEvalfinal ValueEvalComplex.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 ValueEvalEDate.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 ValueEvalfinal ValueEvalfinal ValueEvalfinal ValueEvalfinal ValueEvalFreeRefFunction.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 booleanLookup.evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) MatrixFunction.TwoArrayArg.evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) final ValueEvalfinal ValueEvalNumericFunction.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 ValueEvalTimeFunc.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 doubleTextFunction.evaluateDoubleArg(ValueEval arg, int srcCellRow, int srcCellCol) static intChoose.evaluateFirstArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex) static booleanIfFunc.evaluateFirstArg(ValueEval arg, int srcCellRow, int srcCellCol) protected abstract ValueEvalTextFunction.evaluateFunc(ValueEval[] args, int srcCellRow, int srcCellCol) protected static intTextFunction.evaluateIntArg(ValueEval arg, int srcCellRow, int srcCellCol) protected static StringTextFunction.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.booleanbooleanbooleanDGet.processMatch(ValueEval eval) booleanDMax.processMatch(ValueEval eval) booleanDMin.processMatch(ValueEval eval) booleanDSum.processMatch(ValueEval eval) booleanIDStarAlgorithm.processMatch(ValueEval eval) Process a match that is found during a run through a database.protected final doubleMatrixFunction.singleOperandEvaluate(ValueEval arg, int srcCellRow, int srcCellCol) protected static doubleNumericFunction.singleOperandEvaluate(ValueEval arg, int srcRowIndex, int srcColumnIndex)