CalculationCell

CalculationCell class

Represents the calculation relevant data about one cell which is being calculated.

Properties

NameTypeDescription
WorkbookWorkbookGets the Workbook object.
WorksheetWorksheetGets the Worksheet object where the cell is in.
CellRowintGets the row index of the cell.
CellColumnintGets the column index of the cell.
CellCellGets the Cell object which is being calculated.

Methods

NameDescription
setCalculatedValueSets the calculated value for the cell.

User can set the calculated result by this method to ignore the automatic calcu |

CalculationCell.Workbook property

Gets the Workbook object.

Type: Workbook

CalculationCell.Worksheet property

Gets the Worksheet object where the cell is in.

Type: Worksheet

CalculationCell.CellRow property

Gets the row index of the cell.

Type: int

CalculationCell.CellColumn property

Gets the column index of the cell.

Type: int

CalculationCell.Cell property

Gets the Cell object which is being calculated.

Type: Cell

setCalculatedValue(v)

Sets the calculated value for the cell.

User can set the calculated result by this method to ignore the automatic calculation for the cell.