GridCalculationData

GridCalculationData class

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

public class GridCalculationData

Properties

Name Description
CalculatedValue { get; set; } Gets or sets the calculated value for this function.
Column { get; } Gets the Cell Column index where the function is in.
Formula { get; } Gets the Cell formula where the function is in.
FunctionName { get; } Gets the function name to be calculated.
ParamCount { get; } Gets the count of parameters
Row { get; } Gets the Cell Row index where the function is in.
SheetName { get; } Gets the worksheet name where the function is in.
StringValue { get; } Gets the Cell DisplayStringValue where the function is in.
Value { get; } Gets the Cell value where the function is in.

Methods

Name Description
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.

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