CalculationData class

CalculationData class

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

The CalculationData type exposes the following members:

Properties

PropertyDescription
calculated_valueGets or sets the calculated value for this function.
workbookGets the Workbook object where the function is in.
worksheetGets the Worksheet object where the function is in.
cell_rowGets the row index of the cell where the function is in.
cell_columnGets the column index of the cell where the function is in.
cellGets the Cell object where the function is in.
function_nameGets the function name to be calculated.
param_countGets the count of parameters

Methods

MethodDescription
get_param_valueGets the represented value object of the parameter at given index.
get_param_value_in_array_modeGets 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.
get_param_textGets the literal text of the parameter at given index.

Remarks

All objects provided by this class are for “read” purpose only. User should not change any data in the Workbook during the formula calculation process, Otherwise unexpected result or Exception may be caused.

See Also