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.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

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