1. Basic grid

Basic grid with rows and columns

• FastGrid JSON

  • Every grid JSON is defined as

    FGrid.Data = { ... }

    object. It is the only possible root object in FastGrid JSON. See FastGrid Layout and configuration
  • The simplest empty grid can be created as FGrid.Data = { } - no columns and no rows.
  • FastGrid base configuration is defined in

    Cfg

    tag.

• Rows

  • FastGrid is usually row based grid. Data are usually defined in rows.
  • Although FastGrid can be also column based grid with data defined in columns and features like sorting, filter or group for columns instead of rows.
  • The variable (body) rows are defined as objects inside

    Body: [ ... ]

    array.
  • The fixed rows are defined as objects inside

    Head : [ ... ]

    and

    Foot: [ ... ]

    arrays.
  • It is possible to define different rows structure, more (unlimited) or other sections than Body / Head / Foot in RowParts array. All the sections can be vertically scrollable.
  • Row can be moved (dragged) inside its section and also to another section. Special rows can be shown / hidden by users in layout menu (icon on toolbar).
  • For more information see Row types tutorial.

• Columns

  • The column defines id, position and width of all the cells in the column. The column optionally defines also cell attributes like Type, Format, NoEdit, etc. for all the cells in the column.
  • The variable (middle) columns are defined by objects inside

    Cols: [ ... ]

    array.
  • The fixed columns are defined by objects inside

    LeftCols: [ ... ]

    and

    RightCols: [ ... ]

    arrays.
  • It is possible to define different columns structure, more (unlimited) or other sections than Cols / LeftCols / RightCols in ColParts array. All the sections can be horizontally scrollable.
  • Column can be moved (dragged) inside its section and also to another section. Columns can be shown / hidden by users in layout menu (icon on toolbar).
  • For more information see Columns and sections tutorial.

• Cells

  • FastGrid data in cells are usually defined in rows, not in columns, although the V and A attributes can be set also to columns.
  • The cell values are defined in row attribute

    V

    as array according to column VIndex (e.g. V: [1,2,3] ) or as id:value, according to column id (e.g V: { C1:1, C2:2, C3:3 } ).
  • All cell attributes (except for column size and position like Width) can be defined for the whole column (in column object), for whole row (except for row size and position like Height) in the row object or for individual cell (in row attribute

    A

    ).
  • The

    A

    can be defined as array according to column AIndex (e.g. A: ["Cell1",{Color:'red'},{TextColor:'blue',Align:1}] ) or as id:value, according to column id (e.g A: { C1: "Cell1", C2: {Color:'red'}, C3: {TextColor:'blue',Align:1} } ).
  • For more information see Cells tutorials.

• Predefined items

  
  There are no predefined items in FastGrid, empty grid contains no item.
  But there are various default items that can be referred by D attribute to place them to grid with the defined features and settings.

  • Header

    - row or column in different color and background displaying column or row ids.

  • Index

    - row or column in different color and background displaying column or row indexes.

  • Panel

    - row or column prepared to display row / column icons. The icons must be defined explicitly, e.g. in LeftIcons.

  • Filter

    - row or column displaying filter operators and permits filtering rows / columns by its values.

  • Data1

    ,

    Data2

    ,

    Data3

    - base toolbars with buttons to control grid data.

  • Text1

    ,

    Text2

    ,

    Text3

    - base toolbars with buttons to control cell content.

  • Group

    - toolbar with group settings.

  • Hide

    - toolbar with hide items settings.

  • Search

    - toolbar with button and edit box to search in grid.

  • Sheets

    - toolbar with list of all sheets in Book.

  • Edit

    - toolbar with external edit box and external focus list.

  • Cookies

    - toolbar with buttons to control saved configuration.

  • Layout

    - toolbar with buttons for choosing visible items in grid.

  • PivotRows

    ,

    PivotCols

    ,

    PivotData

    ,

    PivotSource

    - toolbars to create pivot.