GridCalculationData class

GridCalculationData class

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

The GridCalculationData type exposes the following members:

Properties

PropertyDescription
calculated_valueGets/sets the calculated value for this function.
rowGets the Cell Row index where the function is in.
columnGets the Cell Column index where the function is in.
string_valueGets the Cell DisplayStringValue where the function is in.
valueGets the Cell value where the function is in.
formulaGets the Cell formula where the function is in.
sheet_nameGets the worksheet name 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_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