Uses of Interface
org.apache.poi.ss.formula.eval.ValueEval
-
Packages that use ValueEval Package Description 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 -
-
Uses of ValueEval in org.apache.poi.ss.formula
Subinterfaces of ValueEval in org.apache.poi.ss.formula Modifier and Type Interface Description interface
ThreeDEval
Optional Extension to the likes ofAreaEval
andAreaEvalBase
, which allows for looking up 3D (sheet+row+column) evaluationsinterface
TwoDEval
Common interface ofAreaEval
andAreaEvalBase
, for 2D (row+column) evaluationsClasses in org.apache.poi.ss.formula that implement ValueEval Modifier and Type Class Description class
CacheAreaEval
class
LazyRefEval
Provides Lazy Evaluation to a 3D ReferenceMethods in org.apache.poi.ss.formula that return ValueEval Modifier and Type Method Description static ValueEval
WorkbookEvaluator. dereferenceResult(ValueEval evaluationResult, int srcRowNum, int srcColNum)
Dereferences a single value from any AreaEval or RefEval evaluation result.ValueEval
WorkbookEvaluator. evaluate(java.lang.String formula, CellReference ref)
Evaluate a formula outside a cell value, e.g.ValueEval
WorkbookEvaluator. evaluate(java.lang.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.ValueEval
WorkbookEvaluator. evaluate(EvaluationCell srcCell)
ValueEval
WorkbookEvaluator. evaluateList(java.lang.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.ValueEval
OperationEvaluationContext. getArea3DEval(Area3DPtg aptg)
ValueEval
OperationEvaluationContext. getArea3DEval(Area3DPxg aptg)
ValueEval
OperationEvaluationContext. getAreaEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex)
ValueEval
OperationEvaluationContext. getAreaValueEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, java.lang.Object[][] tokens)
ValueEval
OperationEvaluationContext. getDynamicReference(java.lang.String workbookName, java.lang.String sheetName, java.lang.String refStrPart1, java.lang.String refStrPart2, boolean isA1Style)
Resolves a cell or area reference dynamically.ValueEval
LazyRefEval. getInnerValueEval(int sheetIndex)
ValueEval
OperationEvaluationContext. getNameXEval(NameXPtg nameXPtg)
ValueEval
OperationEvaluationContext. getNameXEval(NameXPxg nameXPxg)
ValueEval
OperationEvaluationContext. getRef3DEval(Ref3DPtg rptg)
ValueEval
OperationEvaluationContext. getRef3DEval(Ref3DPxg rptg)
ValueEval
OperationEvaluationContext. getRefEval(int rowIndex, int columnIndex)
ValueEval
CacheAreaEval. getRelativeValue(int relativeRowIndex, int relativeColumnIndex)
ValueEval
CacheAreaEval. getRelativeValue(int sheetIndex, int relativeRowIndex, int relativeColumnIndex)
ValueEval
ThreeDEval. getValue(int sheetIndex, int rowIndex, int columnIndex)
ValueEval
TwoDEval. getValue(int rowIndex, int columnIndex)
Methods in org.apache.poi.ss.formula that return types with arguments of type ValueEval Modifier and Type Method Description java.util.List<ValueEval>
DataValidationEvaluator. 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.protected static java.util.List<ValueEval>
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 ValueEval Modifier and Type Method Description static 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 ValueEval Constructor Description CacheAreaEval(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.eval Modifier and Type Interface Description interface
AreaEval
Evaluation of 2D (Row+Column) and 3D (Sheet+Row+Column) areasinterface
NumericValueEval
interface
RefEval
RefEval is the super interface for Ref2D and Ref3DEval.interface
StringValueEval
Classes in org.apache.poi.ss.formula.eval that implement ValueEval Modifier and Type Class Description class
AreaEvalBase
class
BlankEval
class
BoolEval
class
ErrorEval
Evaluations for formula errorsclass
ExternalNameEval
Evaluation of a Name defined in a Sheet or Workbook scopeclass
FunctionNameEval
class
MissingArgEval
Represents the (intermediate) evaluated result of a missing function argument.class
NumberEval
class
RefEvalBase
Common base class for implementors ofRefEval
class
RefListEval
Handling of a list of values, e.g.class
StringEval
Methods in org.apache.poi.ss.formula.eval that return ValueEval Modifier and Type Method Description static 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.ValueEval
ConcatEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
IntersectionEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
PercentEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
RangeEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
RelationalOperationEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
This is a description of how the relational operators apply in MS Excel.ValueEval
TwoOperandNumericOperation. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
UnaryMinusEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
UnaryPlusEval. evaluate(int srcCellRow, int srcCellCol, ValueEval arg0)
ValueEval
RelationalOperationEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
TwoOperandNumericOperation. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
AreaEval. getAbsoluteValue(int row, int col)
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.ValueEval
RefEval. getInnerValueEval(int sheetIndex)
ValueEval
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.ValueEval
AreaEvalBase. getValue(int row, int col)
ValueEval
AreaEvalBase. getValue(int sheetIndex, int row, int col)
Methods in org.apache.poi.ss.formula.eval that return types with arguments of type ValueEval Modifier and Type Method Description java.util.List<ValueEval>
RefListEval. getList()
Methods in org.apache.poi.ss.formula.eval with parameters of type ValueEval Modifier and Type Method Description static java.lang.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 java.lang.String
OperandResolver. coerceValueToString(ValueEval ve)
ValueEval
ConcatEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
IntersectionEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
PercentEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
RangeEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
RelationalOperationEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
This is a description of how the relational operators apply in MS Excel.ValueEval
TwoOperandNumericOperation. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
UnaryMinusEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
UnaryPlusEval. evaluate(int srcCellRow, int srcCellCol, ValueEval arg0)
ValueEval
RelationalOperationEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
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 double
TwoOperandNumericOperation. singleOperandEvaluate(ValueEval arg, int srcCellRow, int srcCellCol)
Constructors in org.apache.poi.ss.formula.eval with parameters of type ValueEval Constructor Description RefListEval(ValueEval v1, ValueEval v2)
-
Uses of ValueEval in org.apache.poi.ss.formula.eval.forked
Methods in org.apache.poi.ss.formula.eval.forked that return ValueEval Modifier and Type Method Description ValueEval
ForkedEvaluator. evaluate(java.lang.String sheetName, int rowIndex, int columnIndex)
If 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 ValueEval Modifier and Type Method Description void
ForkedEvaluator. updateCell(java.lang.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 ValueEval Modifier and Type Method Description ValueEval
Address. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Areas. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Bin2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Bin2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
BooleanFunction. evaluate(ValueEval[] args, int srcRow, int srcCol)
ValueEval
CalendarFieldFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Choose. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Code. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval textArg)
ValueEval
Column. evaluate(int srcRowIndex, int srcColumnIndex)
ValueEval
Column. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Column. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Columns. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Complex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num)
ValueEval
Complex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix)
ValueEval
Complex. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Count. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Counta. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Countblank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Countif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
DateFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Days360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Days360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Dec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Dec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval placesVE)
ValueEval
Dec2Bin. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Dec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Dec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval number, ValueEval places)
ValueEval
Dec2Hex. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Delta. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)
ValueEval
Delta. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
DStarRunner. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval database, ValueEval filterColumn, ValueEval conditionDatabase)
ValueEval
DStarRunner. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
EDate. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
EOMonth. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Errortype. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
FactDouble. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
FactDouble. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
FinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
FinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
FinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4)
ValueEval
FinanceFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Fixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Fixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Fixed. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed0ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed1ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed2ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed3ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed4ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
FreeRefFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Frequency. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Function. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Function0Arg. evaluate(int srcRowIndex, int srcColumnIndex)
ValueEval
Function1Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Function2Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Function3Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Function4Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Hex2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Hex2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Hlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Hlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Hyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Hyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
IfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
IfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Imaginary. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)
ValueEval
Imaginary. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
ImReal. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)
ValueEval
ImReal. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Index. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Index. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Index. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Index. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Indirect. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Intercept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Irr. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
LinearRegressionFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
LogicalFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Lookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Lookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Match. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Match. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
MatrixFunction.OneArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
MatrixFunction.TwoArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Mode. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
MultiOperandNumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Na. evaluate(int srcCellRow, int srcCellCol)
ValueEval
NotImplementedFunction. evaluate(ValueEval[] operands, int srcRow, int srcCol)
ValueEval
Now. evaluate(int srcRowIndex, int srcColumnIndex)
ValueEval
Npv. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
NumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
NumericFunction.OneArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
NumericFunction.TwoArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Oct2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Oct2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Offset. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Quotient. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval venumerator, ValueEval vedenominator)
ValueEval
Quotient. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Rank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Rank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Rate. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Replace. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Rept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval text, ValueEval number_times)
ValueEval
Roman. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval formVE)
ValueEval
RowFunc. evaluate(int srcRowIndex, int srcColumnIndex)
ValueEval
RowFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
RowFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Rows. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Slope. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Substitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Substitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Subtotal. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Sumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Sumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Sumproduct. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
T. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
TextFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
TimeFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Today. evaluate(int srcRowIndex, int srcColumnIndex)
ValueEval
Trend. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Value. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Vlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Vlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval lookup_value, ValueEval table_array, ValueEval col_index, ValueEval range_lookup)
ValueEval
WeekdayFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
Perform WEEKDAY(date, returnOption) function.ValueEval
WeekNum. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE)
ValueEval
WeekNum. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
XYNumericFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
ArrayFunction. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
protected abstract ValueEval
TextFunction. evaluateFunc(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
DGet. getResult()
ValueEval
DMax. getResult()
ValueEval
DMin. getResult()
ValueEval
DSum. getResult()
ValueEval
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 ValueEval Modifier and Type Method Description double[]
MatrixFunction.MutableValueCollector. collectValues(ValueEval... operands)
protected abstract double[]
MatrixFunction.OneArrayArg. collectValues(ValueEval arg)
protected abstract double[]
MatrixFunction.TwoArrayArg. collectValues(ValueEval arg)
double
IPMT. eval(ValueEval[] args, int srcCellRow, int srcCellCol)
protected abstract double
NumericFunction. eval(ValueEval[] args, int srcCellRow, int srcCellCol)
protected double
NumericFunction.OneArg. eval(ValueEval[] args, int srcCellRow, int srcCellCol)
double
PPMT. eval(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Address. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Areas. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Bin2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Bin2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
BooleanFunction. evaluate(ValueEval[] args, int srcRow, int srcCol)
ValueEval
CalendarFieldFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Choose. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Code. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval textArg)
ValueEval
Column. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Column. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Columns. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Complex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num)
ValueEval
Complex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix)
ValueEval
Complex. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Count. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Counta. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Countblank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Countif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
DateFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Days360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Days360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Dec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Dec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval placesVE)
ValueEval
Dec2Bin. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Dec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Dec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval number, ValueEval places)
ValueEval
Dec2Hex. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Delta. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)
ValueEval
Delta. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
DStarRunner. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval database, ValueEval filterColumn, ValueEval conditionDatabase)
ValueEval
DStarRunner. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
EDate. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
EOMonth. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Errortype. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
FactDouble. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
FactDouble. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
FinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
FinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
FinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4)
ValueEval
FinanceFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Fixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Fixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Fixed. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed0ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed1ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed2ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed3ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Fixed4ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
FreeRefFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Frequency. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Function. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Function1Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Function2Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Function3Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Function4Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Hex2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Hex2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Hlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Hlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Hyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Hyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
IfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
IfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Imaginary. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)
ValueEval
Imaginary. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
ImReal. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)
ValueEval
ImReal. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Index. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Index. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Index. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Index. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Indirect. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Intercept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Irr. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
LinearRegressionFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
LogicalFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
protected abstract boolean
LogicalFunction. evaluate(ValueEval arg)
ValueEval
Lookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Lookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Match. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Match. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
MatrixFunction.OneArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
MatrixFunction.TwoArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Mode. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
MultiOperandNumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
NotImplementedFunction. evaluate(ValueEval[] operands, int srcRow, int srcCol)
ValueEval
Npv. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
NumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
NumericFunction.OneArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
NumericFunction.TwoArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Oct2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
ValueEval
Oct2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Offset. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
Quotient. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval venumerator, ValueEval vedenominator)
ValueEval
Quotient. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
Rank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Rank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Rate. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Replace. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Rept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval text, ValueEval number_times)
ValueEval
Roman. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval formVE)
ValueEval
RowFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
RowFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Rows. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Slope. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Substitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Substitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
ValueEval
Subtotal. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Sumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
Sumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Sumproduct. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
T. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
TextFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
ValueEval
TimeFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Trend. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
ValueEval
Value. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)
ValueEval
Vlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
ValueEval
Vlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval lookup_value, ValueEval table_array, ValueEval col_index, ValueEval range_lookup)
ValueEval
WeekdayFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
Perform WEEKDAY(date, returnOption) function.ValueEval
WeekNum. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE)
ValueEval
WeekNum. evaluate(ValueEval[] args, OperationEvaluationContext ec)
ValueEval
XYNumericFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
ValueEval
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 java.lang.String
TextFunction. evaluateStringArg(ValueEval eval, int srcRow, int srcCol)
protected double[]
MultiOperandNumericFunction. getNumberArray(ValueEval[] operands)
Returns a double array that contains values for the numeric cells from among the list of operands.boolean
Countif.ErrorMatcher. matches(ValueEval x)
boolean
Countif.StringMatcher. matches(ValueEval x)
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 double
MatrixFunction. singleOperandEvaluate(ValueEval arg, int srcCellRow, int srcCellCol)
protected static double
NumericFunction. singleOperandEvaluate(ValueEval arg, int srcRowIndex, int srcColumnIndex)
-