Interface ICalcData

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

Namespace: Syncfusion.XlsIO.Calculate

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

public interface ICalcData

Methods

add_ValueChanged(ValueChangedEventHandler)

Declaration

void add_ValueChanged(ValueChangedEventHandler value)

Parameters

Type	Name	Description
ValueChangedEventHandler	value

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.

remove_ValueChanged(ValueChangedEventHandler)

Declaration

void remove_ValueChanged(ValueChangedEventHandler value)

Parameters

Type	Name	Description
ValueChangedEventHandler	value

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
ValueChangedEventHandler