CalculationData

CalculationData class

Represents the required data when calculating one function, such as function name, parameters, …etc.

Properties

Name	Type	Description
CalculatedValue	Object	Gets or sets the calculated value for this function. User should set this property in his custom calculation engine for
Workbook	Workbook	Gets the Workbook object where the function is in.
Worksheet	Worksheet	Gets the Worksheet object where the function is in.
CellRow	int	Gets the row index of the cell where the function is in.
CellColumn	int	Gets the column index of the cell where the function is in.
Cell	Cell	Gets the Cell object where the function is in. When calculating a formula without setting it to a cell, such as by Works
FunctionName	String	Gets the function name to be calculated.
ParamCount	int	Gets the count of parameters

Methods

Name	Description
getParamValue	Gets the represented value object of the parameter at given index.

For one parameter: If it is plain value, then return | | getParamValueInArrayMode | Gets the value(s) of the parameter at given index. If the parameter is some kind of expression that needs to be calculat | | getParamText | Gets the literal text of the parameter at given index. |

CalculationData.CalculatedValue property

Gets or sets the calculated value for this function. User should set this property in his custom calculation engine for those functions the engine supports, and the set value will be returned when getting this property later. The set value may be of possible types of Cell.Value , or array of such kind of values, or a Range, Name, ReferredArea. Getting this property before setting value to it will make the function be calculated by the default calculation engine of Aspose.Cells and then the calculated value will be returned(generally it should be #NAME? for user-defined functions).

Type: Object

CalculationData.Workbook property

Gets the Workbook object where the function is in.

Type: Workbook

CalculationData.Worksheet property

Gets the Worksheet object where the function is in.

Type: Worksheet

CalculationData.CellRow property

Gets the row index of the cell where the function is in.

Type: int

CalculationData.CellColumn property

Gets the column index of the cell where the function is in.

Type: int

CalculationData.Cell property

Gets the Cell object where the function is in. When calculating a formula without setting it to a cell, such as by Worksheet.calculateFormula(java.lang.String, com.aspose.cells.CalculationOptions) , the formula will be calculated just like it has been set to cell A1, so both CellRow and CellColumn are 0. However, cell A1 in the worksheet may has not been instantiated. So for such kind of situation this property will be null.

Type: Cell

CalculationData.FunctionName property

Gets the function name to be calculated.

Type: String

CalculationData.ParamCount property

Gets the count of parameters

Type: int

getParamValue(index)

Gets the represented value object of the parameter at given index.

For one parameter: If it is plain value, then returns the plain value itself; If it is reference, then returns ReferredArea object; If it references to dataset(s) with multiple values, then returns array of objects; If it is some kind of expression that needs to be calculated, then it will be calculated in value mode and generally a single value will be returned according to current cell base. For example, if one parameter of D2’s formula is A:A+B:B, then A2+B2 will be calculated and returned. However, if this parameter has been specified as array mode (by Workbook.updateCustomFunctionDefinition(com.aspose.cells.CustomFunctionDefinition) or FormulaParseOptions.CustomFunctionDefinition ), then an array(object[][]) will be returned whose items are A1+B1,A2+B2,….

Parameter	Type	Description
index	int	The index of the parameter(0 based)

Returns: The calculated value of the parameter.

getParamValueInArrayMode(index, maxRowCount, maxColumnCount)

Gets the value(s) of the parameter at given index. If the parameter is some kind of expression that needs to be calculated, then it will be calculated in array mode.

For an expression that needs to be calculated, taking A:A+B:B as an example: In value mode it will be calculated to a single value according to current cell base. But in array mode, all values of A1+B1,A2+B2,A3+B3,… will be calculated and used to construct the returned array. And for such kind of situation, it is better to specify the limit for the row/column count (such as according to Cells.MaxDataRow and Cells.MaxDataColumn ), otherwise the returned large array may increase memory cost with large amount of useless data.

Parameter	Type	Description
index	int	The index of the parameter(0 based)
maxRowCount	int	The row count limit for the returned array. If it is non-positive or greater than the actual row count, then actual row count will be used.
maxColumnCount	int	The column count limit for the returned array. If it is non-positive or greater than the actual row count, then actual column count will be used.

Returns: An array which contains all items represented by the specified parameter.

getParamText(index)

Gets the literal text of the parameter at given index.

Parameter	Type	Description
index	int	index of the parameter(0 based)

Returns: literal text of the parameter