| 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 |
| Modifier and Type | Interface and Description |
|---|---|
interface |
ThreeDEval
Optional Extension to the likes of
AreaEval and
AreaEvalBase,
which allows for looking up 3D (sheet+row+column) evaluations |
interface |
TwoDEval
Common interface of
AreaEval and AreaEvalBase,
for 2D (row+column) evaluations |
| Modifier and Type | Class and Description |
|---|---|
class |
CacheAreaEval |
class |
LazyRefEval
Provides Lazy Evaluation to a 3D Reference
|
| Modifier and Type | Method and 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(EvaluationCell srcCell) |
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.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 |
TwoDEval.getValue(int rowIndex,
int columnIndex) |
ValueEval |
ThreeDEval.getValue(int sheetIndex,
int rowIndex,
int columnIndex) |
| Modifier and Type | Method and Description |
|---|---|
java.util.List<ValueEval> |
DataValidationEvaluator.getValidationValuesForCell(CellReference cell)
If
DataValidationEvaluator.getValidationForCell(CellReference) returns an instance, and the
DataValidationConstraint.ValidationType is DataValidationConstraint.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 instance
|
| Modifier and Type | Method and Description |
|---|---|
static ValueEval |
WorkbookEvaluator.dereferenceResult(ValueEval evaluationResult,
int srcRowNum,
int srcColNum)
Dereferences a single value from any AreaEval or RefEval evaluation
result.
|
| Constructor and Description |
|---|
CacheAreaEval(AreaI ptg,
ValueEval[] values) |
CacheAreaEval(int firstRow,
int firstColumn,
int lastRow,
int lastColumn,
ValueEval[] values) |
| Modifier and Type | Interface and Description |
|---|---|
interface |
AreaEval
Evaluation of 2D (Row+Column) and 3D (Sheet+Row+Column) areas
|
interface |
NumericValueEval |
interface |
RefEval
RefEval is the super interface for Ref2D and Ref3DEval.
|
interface |
StringValueEval |
| Modifier and Type | Class and Description |
|---|---|
class |
AreaEvalBase |
class |
BlankEval |
class |
BoolEval |
class |
ErrorEval
Evaluations for formula errors
|
class |
ExternalNameEval
Evaluation of a Name defined in a Sheet or Workbook scope
|
class |
FunctionNameEval |
class |
MissingArgEval
Represents the (intermediate) evaluated result of a missing function argument.
|
class |
NumberEval |
class |
RefEvalBase
Common base class for implementors of
RefEval |
class |
RefListEval
Handling of a list of values, e.g.
|
class |
StringEval |
| Modifier and Type | Method and 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 |
UnaryPlusEval.evaluate(int srcCellRow,
int srcCellCol,
ValueEval arg0) |
ValueEval |
UnaryMinusEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
PercentEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
RangeEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
ConcatEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
IntersectionEval.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 |
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) |
| Modifier and Type | Method and Description |
|---|---|
java.util.List<ValueEval> |
RefListEval.getList() |
| Modifier and Type | Method and 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 |
UnaryPlusEval.evaluate(int srcCellRow,
int srcCellCol,
ValueEval arg0) |
ValueEval |
UnaryMinusEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
PercentEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
RangeEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
ConcatEval.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
IntersectionEval.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 |
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) |
| Constructor and Description |
|---|
RefListEval(ValueEval v1,
ValueEval v2) |
| Modifier and Type | Method and 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.
|
| Modifier and Type | Method and Description |
|---|---|
void |
ForkedEvaluator.updateCell(java.lang.String sheetName,
int rowIndex,
int columnIndex,
ValueEval value)
Sets the specified cell to the supplied value
|
| Modifier and Type | Method and Description |
|---|---|
ValueEval |
Now.evaluate(int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Function0Arg.evaluate(int srcRowIndex,
int srcColumnIndex)
|
ValueEval |
Today.evaluate(int srcRowIndex,
int srcColumnIndex) |
ValueEval |
RowFunc.evaluate(int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Column.evaluate(int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Na.evaluate(int srcCellRow,
int srcCellCol) |
ValueEval |
T.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Dec2Bin.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
Columns.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
FactDouble.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
NumericFunction.OneArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Fixed.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
RowFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
LogicalFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Hex2Dec.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
Value.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Imaginary.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval inumberVE) |
ValueEval |
Code.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval textArg) |
ValueEval |
Bin2Dec.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
CalendarFieldFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Errortype.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
ImReal.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval inumberVE) |
ValueEval |
Dec2Hex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
MatrixFunction.OneArrayArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Column.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Rows.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Oct2Dec.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
Function1Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0)
|
ValueEval |
Countblank.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Hyperlink.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Rank.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Days360.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Function2Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1)
|
ValueEval |
XYNumericFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
IfFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Rept.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval text,
ValueEval number_times) |
ValueEval |
Dec2Bin.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE,
ValueEval placesVE) |
ValueEval |
NumericFunction.TwoArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
WeekNum.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval serialNumVE,
ValueEval returnTypeVE) |
ValueEval |
Complex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval real_num,
ValueEval i_num) |
ValueEval |
Roman.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE,
ValueEval formVE) |
ValueEval |
Quotient.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval venumerator,
ValueEval vedenominator) |
ValueEval |
Slope.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Fixed.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Match.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Index.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Delta.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Countif.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Sumif.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Lookup.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
LinearRegressionFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Frequency.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Dec2Hex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval number,
ValueEval places) |
ValueEval |
MatrixFunction.TwoArrayArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Hyperlink.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Intercept.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Rank.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Days360.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
IfFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
TimeFunc.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 |
Complex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval real_num,
ValueEval i_num,
ValueEval suffix) |
ValueEval |
Fixed.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Match.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
DStarRunner.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval database,
ValueEval filterColumn,
ValueEval conditionDatabase) |
ValueEval |
Index.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
DateFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Function3Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2)
|
ValueEval |
Vlookup.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Sumif.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 |
FinanceFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Lookup.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 |
Function4Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2,
ValueEval arg3)
|
ValueEval |
Index.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2,
ValueEval arg3) |
ValueEval |
Vlookup.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval lookup_value,
ValueEval table_array,
ValueEval col_index,
ValueEval range_lookup) |
ValueEval |
Substitute.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 |
Replace.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 |
Address.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
MultiOperandNumericFunction.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Fixed2ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed3ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Npv.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Offset.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
TextFunction.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Rate.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Trend.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
NotImplementedFunction.evaluate(ValueEval[] operands,
int srcRow,
int srcCol) |
ValueEval |
NumericFunction.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Choose.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Counta.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Irr.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed1ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
DStarRunner.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
RowFunc.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Index.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Subtotal.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
BooleanFunction.evaluate(ValueEval[] args,
int srcRow,
int srcCol) |
ValueEval |
Areas.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
FinanceFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
WeekdayFunc.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex)
Perform WEEKDAY(date, returnOption) function.
|
ValueEval |
Column.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Count.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Function.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Sumproduct.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Fixed4ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed0ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Mode.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
EOMonth.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
EDate.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
FreeRefFunction.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Dec2Bin.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
FactDouble.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
WeekNum.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Complex.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Quotient.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Hex2Dec.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Imaginary.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Delta.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Bin2Dec.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
ImReal.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Dec2Hex.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Oct2Dec.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Indirect.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
ArrayFunction.evaluateArray(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
protected abstract ValueEval |
TextFunction.evaluateFunc(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
IDStarAlgorithm.getResult()
Return a result ValueEval that will be the result of the calculation.
|
ValueEval |
DMax.getResult() |
ValueEval |
DMin.getResult() |
ValueEval |
DGet.getResult() |
ValueEval |
DSum.getResult() |
| Modifier and Type | Method and Description |
|---|---|
double[] |
MatrixFunction.MutableValueCollector.collectValues(ValueEval... operands) |
protected abstract double[] |
MatrixFunction.OneArrayArg.collectValues(ValueEval arg) |
protected abstract double[] |
MatrixFunction.TwoArrayArg.collectValues(ValueEval arg) |
protected abstract double |
NumericFunction.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
protected double |
NumericFunction.OneArg.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
double |
IPMT.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
double |
PPMT.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
T.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Dec2Bin.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
Columns.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
FactDouble.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
NumericFunction.OneArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Fixed.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
RowFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
LogicalFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Hex2Dec.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
Value.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Imaginary.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval inumberVE) |
ValueEval |
Code.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval textArg) |
ValueEval |
Bin2Dec.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
CalendarFieldFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Errortype.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
ImReal.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval inumberVE) |
ValueEval |
Dec2Hex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
MatrixFunction.OneArrayArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Column.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Rows.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Oct2Dec.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE) |
ValueEval |
Function1Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0)
|
ValueEval |
Countblank.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Hyperlink.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0) |
ValueEval |
Rank.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Days360.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Function2Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1)
|
ValueEval |
XYNumericFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
IfFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Rept.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval text,
ValueEval number_times) |
ValueEval |
Dec2Bin.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE,
ValueEval placesVE) |
ValueEval |
NumericFunction.TwoArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
WeekNum.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval serialNumVE,
ValueEval returnTypeVE) |
ValueEval |
Complex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval real_num,
ValueEval i_num) |
ValueEval |
Roman.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval numberVE,
ValueEval formVE) |
ValueEval |
Quotient.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval venumerator,
ValueEval vedenominator) |
ValueEval |
Slope.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Fixed.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Match.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Index.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Delta.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Countif.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Sumif.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Lookup.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
LinearRegressionFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Frequency.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Dec2Hex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval number,
ValueEval places) |
ValueEval |
MatrixFunction.TwoArrayArg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Hyperlink.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Intercept.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1) |
ValueEval |
Rank.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Days360.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
IfFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
TimeFunc.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 |
Complex.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval real_num,
ValueEval i_num,
ValueEval suffix) |
ValueEval |
Fixed.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Match.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
DStarRunner.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval database,
ValueEval filterColumn,
ValueEval conditionDatabase) |
ValueEval |
Index.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
DateFunc.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Function3Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2)
|
ValueEval |
Vlookup.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Sumif.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 |
FinanceFunction.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2) |
ValueEval |
Lookup.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 |
Function4Arg.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2,
ValueEval arg3)
|
ValueEval |
Index.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2,
ValueEval arg3) |
ValueEval |
Vlookup.evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval lookup_value,
ValueEval table_array,
ValueEval col_index,
ValueEval range_lookup) |
ValueEval |
Substitute.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 |
Replace.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) |
protected abstract boolean |
LogicalFunction.evaluate(ValueEval arg) |
ValueEval |
Address.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
MultiOperandNumericFunction.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Fixed2ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed3ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Npv.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Offset.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
TextFunction.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Rate.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Trend.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
NotImplementedFunction.evaluate(ValueEval[] operands,
int srcRow,
int srcCol) |
ValueEval |
NumericFunction.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Choose.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Counta.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Irr.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed1ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
DStarRunner.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
RowFunc.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Index.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Subtotal.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
BooleanFunction.evaluate(ValueEval[] args,
int srcRow,
int srcCol) |
ValueEval |
Areas.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
FinanceFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
WeekdayFunc.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex)
Perform WEEKDAY(date, returnOption) function.
|
ValueEval |
Column.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Count.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Function.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Sumproduct.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
Fixed4ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Fixed0ArgFunction.evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
ValueEval |
Mode.evaluate(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
ValueEval |
EOMonth.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
EDate.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
FreeRefFunction.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Dec2Bin.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
FactDouble.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
WeekNum.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Complex.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Quotient.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Hex2Dec.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Imaginary.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Delta.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Bin2Dec.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
ImReal.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Dec2Hex.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Oct2Dec.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
Indirect.evaluate(ValueEval[] args,
OperationEvaluationContext ec) |
ValueEval |
ArrayFunction.evaluateArray(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
protected static double |
TextFunction.evaluateDoubleArg(ValueEval arg,
int srcCellRow,
int srcCellCol) |
static boolean |
IfFunc.evaluateFirstArg(ValueEval arg,
int srcCellRow,
int srcCellCol) |
static int |
Choose.evaluateFirstArg(ValueEval arg0,
int srcRowIndex,
int srcColumnIndex) |
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 |
IDStarAlgorithm.processMatch(ValueEval eval)
Process a match that is found during a run through a database.
|
boolean |
DMax.processMatch(ValueEval eval) |
boolean |
DMin.processMatch(ValueEval eval) |
boolean |
DGet.processMatch(ValueEval eval) |
boolean |
DSum.processMatch(ValueEval eval) |
protected static double |
NumericFunction.singleOperandEvaluate(ValueEval arg,
int srcRowIndex,
int srcColumnIndex) |
protected double |
MatrixFunction.singleOperandEvaluate(ValueEval arg,
int srcCellRow,
int srcCellCol) |
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.