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

Extension Methods