Class SpreadsheetGridModel

Represents the class which holds the operations and events associated with rows and columns.

Inheritance
System.Object
SpreadsheetGridModel
Implements
System.IDisposable
Namespace: Syncfusion.UI.Xaml.Spreadsheet
Assembly: Syncfusion.SfSpreadsheet.UWP.dll
Syntax
public class SpreadsheetGridModel : Object, IDisposable
Remarks

The Operations and events such as Insertion/ Deletion of rows and columns in SfSpreadsheet.

Constructors

SpreadsheetGridModel(SpreadsheetGrid)

Initializes a new instance of the SpreadsheetGridModel class.

Declaration
public SpreadsheetGridModel(SpreadsheetGrid grid)
Parameters
Type Name Description
SpreadsheetGrid grid

An instance of SpreadsheetGrid

Properties

FormulaEngine

Gets the value indicating the instance of FormulaEngine which handles all the formula related operations in SfSpreadsheet

Declaration
public FormulaEngine FormulaEngine { get; }
Property Value
Type Description
FormulaEngine

An instance of FormulaEngine.

Grid

Gets the value indicating the instance of SpreadsheetGrid.

Declaration
public SpreadsheetGrid Grid { get; }
Property Value
Type Description
SpreadsheetGrid

An instance of SpreadsheetGrid.

Methods

add_ColumnsInserted(GridRangeInsertedEventHandler)

Declaration
public void add_ColumnsInserted(GridRangeInsertedEventHandler value)
Parameters
Type Name Description
GridRangeInsertedEventHandler value

add_ColumnsRemoved(GridRangeRemovedEventHandler)

Declaration
public void add_ColumnsRemoved(GridRangeRemovedEventHandler value)
Parameters
Type Name Description
GridRangeRemovedEventHandler value

add_RowsInserted(GridRangeInsertedEventHandler)

Declaration
public void add_RowsInserted(GridRangeInsertedEventHandler value)
Parameters
Type Name Description
GridRangeInsertedEventHandler value

add_RowsRemoved(GridRangeRemovedEventHandler)

Declaration
public void add_RowsRemoved(GridRangeRemovedEventHandler value)
Parameters
Type Name Description
GridRangeRemovedEventHandler value

Dispose()

Releases all resources used by the. SpreadsheetGridModel.

Declaration
public void Dispose()

Dispose(Boolean)

Declaration
protected virtual void Dispose(bool disposing)
Parameters
Type Name Description
System.Boolean disposing

InsertColumns(Int32, Int32)

Inserts the given number of columns at the specified column index.

Declaration
public virtual void InsertColumns(int insertAtColumnIndex, int count)
Parameters
Type Name Description
System.Int32 insertAtColumnIndex

The column index to insert.
System.Int32 count

Number of columns to be inserted.

InsertRows(Int32, Int32)

Inserts specified number of rows at the given row index.

Declaration
public virtual void InsertRows(int insertAtRowIndex, int count)
Parameters
Type Name Description
System.Int32 insertAtRowIndex

The row index to insert.
System.Int32 count

Number of rows to be inserted

OnColumnsInserted(GridRangeInsertedEventArgs)

Invoked after a range of columns in SfSpreadsheet is inserted.

Declaration
protected virtual void OnColumnsInserted(GridRangeInsertedEventArgs e)
Parameters
Type Name Description
GridRangeInsertedEventArgs e

An GridRangeInsertedEventArgs that contains the event data.

OnColumnsRemoved(GridRangeRemovedEventArgs)

Invoked after a range of columns in SfSpreadsheet is removed.

Declaration
protected virtual void OnColumnsRemoved(GridRangeRemovedEventArgs e)
Parameters
Type Name Description
GridRangeRemovedEventArgs e

An GridRangeRemovedEventArgs that contains the event data.

OnRowsInserted(GridRangeInsertedEventArgs)

Invoked after a range of rows in SfSpreadsheet is inserted.

Declaration
protected virtual void OnRowsInserted(GridRangeInsertedEventArgs e)
Parameters
Type Name Description
GridRangeInsertedEventArgs e

An GridRangeInsertedEventArgs that contains the event data.

OnRowsRemoved(GridRangeRemovedEventArgs)

Invoked after a range of rows in SfSpreadsheet is removed.

Declaration
protected virtual void OnRowsRemoved(GridRangeRemovedEventArgs e)
Parameters
Type Name Description
GridRangeRemovedEventArgs e

An GridRangeRemovedEventArgs that contains the event data.

remove_ColumnsInserted(GridRangeInsertedEventHandler)

Declaration
public void remove_ColumnsInserted(GridRangeInsertedEventHandler value)
Parameters
Type Name Description
GridRangeInsertedEventHandler value

remove_ColumnsRemoved(GridRangeRemovedEventHandler)

Declaration
public void remove_ColumnsRemoved(GridRangeRemovedEventHandler value)
Parameters
Type Name Description
GridRangeRemovedEventHandler value

remove_RowsInserted(GridRangeInsertedEventHandler)

Declaration
public void remove_RowsInserted(GridRangeInsertedEventHandler value)
Parameters
Type Name Description
GridRangeInsertedEventHandler value

remove_RowsRemoved(GridRangeRemovedEventHandler)

Declaration
public void remove_RowsRemoved(GridRangeRemovedEventHandler value)
Parameters
Type Name Description
GridRangeRemovedEventHandler value

RemoveColumns(Int32, Int32)

Removes given number of columns from the specified index.

Declaration
public void RemoveColumns(int removeAtColumnIndex, int count)
Parameters
Type Name Description
System.Int32 removeAtColumnIndex

The column index.
System.Int32 count

Number of columns to be removed.

RemoveRows(Int32, Int32)

Deletes given number of rows from the specified index.

Declaration
public virtual void RemoveRows(int removeAtRowIndex, int count)
Parameters
Type Name Description
System.Int32 removeAtRowIndex

The row index.
System.Int32 count

Number of rows to be removed.

Events

ColumnsInserted

Occurs after a range of columns has been inserted. GridRangeInsertedEventArgs for more details.

Declaration
public event GridRangeInsertedEventHandler ColumnsInserted
Event Type
Type
GridRangeInsertedEventHandler

ColumnsRemoved

Occurs after a range of columns has been removed. GridRangeRemovedEventArgs for more details.

Declaration
public event GridRangeRemovedEventHandler ColumnsRemoved
Event Type
Type
GridRangeRemovedEventHandler

RowsInserted

Occurs after a range of rows has been inserted. Refer GridRangeInsertedEventArgs for more details.

Declaration
public event GridRangeInsertedEventHandler RowsInserted
Event Type
Type
GridRangeInsertedEventHandler

RowsRemoved

Occurs when a range of rows is removed. GridRangeRemovedEventArgs for more details.

Declaration
public event GridRangeRemovedEventHandler RowsRemoved
Event Type
Type
GridRangeRemovedEventHandler

Implements

System.IDisposable

Extension Methods