aspose.cells
Class CalculationData

function getCalculatedValue() / function setCalculatedValue(value)

Gets or sets the calculated value for this function.

User should set this property in his custom calculation engine for those functions the engine supports, and the set value will be returned when getting this property. Getting this property before setting will make the function be calculated by the default calculation engine of Aspose.Cells and the calculated value will be returned.

function getWorkbook()

Gets the Workbook object where the function is in.

function getWorksheet()

Gets the Worksheet object where the function is in.

function getCellRow()

Gets the row index of the cell where the function is in.

function getCellColumn()

Gets the column index of the cell where the function is in.

function getCell()

Gets the Cell object where the function is in.

function getFunctionName()

Gets the function name to be calculated.

function getParamCount()

Gets the count of parameters

function getParamValue(index)

Gets the represented value object of the parameter at given index.

Parameters:

index: Number - index of the parameter(0 based)

Returns:

If the parameter is plain value, then returns the plain value. If the parameter is reference, then returns ReferredArea object. If the parameter references to multiple datasets, then returns array of objects.

function getParamText(index)

Gets the literal text of the parameter at given index.

Parameters:

index: Number - index of the parameter(0 based)

Returns:

literal text of the parameter