Class SpreadsheetGridModel

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

Inheritance
System.Object
SpreadsheetGridModel
Implements
System.IDisposable
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Syncfusion.UI.Xaml.Spreadsheet
Assembly: Syncfusion.SfSpreadsheet.WPF.dll
Syntax
public class SpreadsheetGridModel : 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

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.

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 Description
GridRangeInsertedEventHandler

ColumnsRemoved

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

Declaration
public event GridRangeRemovedEventHandler ColumnsRemoved
Event Type
Type Description
GridRangeRemovedEventHandler

RowsInserted

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

Declaration
public event GridRangeInsertedEventHandler RowsInserted
Event Type
Type Description
GridRangeInsertedEventHandler

RowsRemoved

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

Declaration
public event GridRangeRemovedEventHandler RowsRemoved
Event Type
Type Description
GridRangeRemovedEventHandler

Implements

System.IDisposable

Extension Methods