CalculationData

CalculationData class

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

public class CalculationData

Properties

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

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