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.WPF.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