menu

WPF

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class SpreadsheetGridModel - WPF API Reference | Syncfusion

    Show / Hide Table of Contents

    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
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved