Class CalculationData

CalculationData class

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

public class CalculationData

Properties

NameDescription
CalculatedValue { get; set; }Gets or sets the calculated value for this function.
Cell { get; }Gets the Cell object where the function is in.
CellColumn { get; }Gets the column index of the cell where the function is in.
CellRow { get; }Gets the row index of the cell where the function is in.
FunctionName { get; }Gets the function name to be calculated.
ParamCount { get; }Gets the count of parameters
Workbook { get; }Gets the Workbook object where the function is in.
Worksheet { get; }Gets the Worksheet object where the function is in.

Methods

NameDescription
GetParamText(int)Gets the literal text of the parameter at given index.
GetParamValue(int)Gets the represented value object of the parameter at given index.
GetParamValueInArrayMode(int, int, int)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.

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