ASP.NET Core MVC Controls | ComponentOne
In This Topic
    FlexSheetPanel Class
    In This Topic
    File
    wijmo.grid.sheet.js
    Module
    wijmo.grid.sheet
    Base Class
    GridPanel

    Defines the extension of the GridPanel class, which is used by FlexSheet where the base FlexGrid class uses GridPanel. For example, the cells property returns an instance of this class.

    Constructor

    Properties

    Methods

    Constructor

    constructor

    constructor(grid: FlexGrid, cellType: CellType, rows: RowCollection, cols: ColumnCollection, element: HTMLElement): FlexSheetPanel
    

    Initializes a new instance of the FlexSheetPanel class.

    Parameters
    Returns
    FlexSheetPanel

    Properties

    cellType

    Gets the type of cell contained in the panel.

    Inherited From
    GridPanel
    Type
    CellType

    columns

    Gets the panel's column collection.

    Inherited From
    GridPanel
    Type
    ColumnCollection

    grid

    Gets the grid that owns the panel.

    Inherited From
    GridPanel
    Type
    FlexGrid

    height

    Gets the total height of the content in this panel.

    Inherited From
    GridPanel
    Type
    number

    hostElement

    Gets the host element for the panel.

    Inherited From
    GridPanel
    Type
    HTMLElement

    rows

    Gets the panel's row collection.

    Inherited From
    GridPanel
    Type
    RowCollection

    viewRange

    Gets a CellRange that indicates the range of cells currently visible on the panel.

    Inherited From
    GridPanel
    Type
    CellRange

    width

    Gets the total width of the content in the panel.

    Inherited From
    GridPanel
    Type
    number

    Methods

    getCellBoundingRect

    getCellBoundingRect(r: number, c: number | string, raw?: boolean): Rect
    

    Gets a cell's bounds in viewport coordinates.

    The returned value is a Rect object which contains the position and dimensions of the cell in viewport coordinates. The viewport coordinates are the same as those used by the getBoundingClientRect method.

    Parameters
    • r: number

      The index of the row that contains the cell.

    • c: number | string

      The index, name, or binding of the column that contains the cell.

    • raw: boolean
    Optional

    Whether to return the rectangle in raw panel coordinates as opposed to viewport coordinates.

    Inherited From
    GridPanel
    Returns
    Rect

    getCellData

    getCellData(r: number, c: any, formatted: boolean): any
    

    Gets the value stored in a cell in the panel.

    Parameters
    • r: number

      The row index of the cell.

    • c: any

      The index, name, or binding of the column that contains the cell.

    • formatted: boolean

      Whether to format the value for display.

    Returns
    any

    getCellElement

    getCellElement(r: number, c: number | string): HTMLElement
    

    Gets the element that represents a cell within this GridPanel.

    If the cell is not currently in view, this method returns null.

    Parameters
    • r: number

      The index of the row that contains the cell.

    • c: number | string

      The index, name, or binding of the column that contains the cell.

    Inherited From
    GridPanel
    Returns
    HTMLElement

    getSelectedState

    getSelectedState(r: number, c: number, rng: CellRange): SelectedState
    

    Gets a SelectedState value that indicates the selected state of a cell.

    Overrides this method to support multiple selection showSelectedHeaders for FlexSheet

    Parameters
    • r: number

      Row index of the cell to inspect.

    • c: number

      Column index of the cell to inspect.

    • rng: CellRange

      CellRange that contains the cell to inspect.

    Returns
    SelectedState

    setCellData

    setCellData(r: number, c: any, value: any, coerce?: boolean, invalidate?: boolean): boolean
    

    Sets the content of a cell in the panel.

    Parameters
    • r: number

      The index of the row that contains the cell.

    • c: any

      The index, name, or binding of the column that contains the cell.

    • value: any

      The value to store in the cell.

    • coerce: boolean
    Optional

    A value indicating whether to change the value automatically to match the column's data type.

    Whether to invalidate the FlexSheet to show the change.

    Returns
    boolean