Interface ICalcData

ICalcData defines the minimal interface that a data object must support in order to use this formula engine.

Namespace: Syncfusion.Windows.Forms.CellGrid

Assembly: Syncfusion.Spreadsheet.Windows.dll

Syntax

public interface ICalcData

Properties

ColumnCount

Gets/Sets Column count of the Grid.

Declaration

int ColumnCount { get; set; }

Property Value

Type	Description
System.Int32

RowCount

Gets/Sets the Row count of the Grid.

Declaration

int RowCount { get; set; }

Property Value

Type	Description
System.Int32

Methods

GetDependentCellValue(Int32, Int32)

Gets the dependent cell value of the specified cell.

Declaration

string GetDependentCellValue(int rowIndex, int colIndex)

Parameters

Type	Name	Description
System.Int32	rowIndex	Row index of the cell
System.Int32	colIndex	Column index of the cell

Returns

Type	Description
System.String	retuns the value of the specified cell

GetValueRowCol(Int32, Int32)

A method that gets the data value from the specified row and column.

Declaration

object GetValueRowCol(int row, int col)

Parameters

Type	Name	Description
System.Int32	row	1-based index specifying the row index of the requested value.
System.Int32	col	1-based index specifying the column index of the requested data.

Returns

Type	Description
System.Object	The data value at the given row and column index.

RecalculateCell(Int32, Int32, Boolean)

Declaration

void RecalculateCell(int row, int col, bool invaladateCell)

Parameters

Type	Name	Description
System.Int32	row
System.Int32	col
System.Boolean	invaladateCell

SetValueRowCol(Object, Int32, Int32)

A method that sets the data value to the specified row and column.

Declaration

void SetValueRowCol(object value, int row, int col)

Parameters

Type	Name	Description
System.Object	value	The value.
System.Int32	row	One-based index specifying the row index of the value.
System.Int32	col	One-based index specifying the column index of the value.

WireParentObject()

A method that wires the ParentObject after the CalcEngine object is created or when a RegisterGridAsSheet call is made.

Declaration

void WireParentObject()

Remarks

This method is a callback to the ParentObject so it can have a chance to subscribe to any change events it may need to implement ValueChanged properly.

Events

ValueChanged

Event for value changed

Declaration

event ValueChangedEventHandler ValueChanged

Event Type

Type	Description
ValueChangedEventHandler