5.20231.904
wijmo.grid.sheet Class FlexSheetPanel Wijmo API Class

FlexSheetPanel Class

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.

Heirarchy

Constructors

constructor

Properties

cellType

cellType: CellType

Gets the type of cell contained in the panel.

columns

Gets the panel's column collection.

grid

grid: FlexGrid

Gets the grid that owns the panel.

height

height: number

Gets the total height of the content in this panel.

hostElement

hostElement: HTMLElement

Gets the host element for the panel.

rows

Gets the panel's row collection.

viewRange

viewRange: CellRange

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

width

width: number

Gets the total width of the content in the panel.

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.

    • Optional raw: boolean

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

    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.

    Returns HTMLElement

getSelectedState

setCellData

  • setCellData(r: number, c: any, value: any, coerce?: boolean, invalidate?: boolean, isMapKeyValue?: 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.

    • Optional coerce: boolean

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

    • Optional invalidate: boolean

      Whether to invalidate the FlexSheet to show the change.

    • Optional isMapKeyValue: boolean

      value passed is already key value of dataMap, don't need re-find.

    Returns boolean

    Returns true if the value is stored successfully, otherwise false (failed cast).