News in versions: FastGrid 1.0, TreeGrid 17.0
FastGrid FastSheet ExamplesSamples DocumentationDoc Download Licensing Prices Buy Development
services
References References Contacts
TreeGrid Gantt chart SpreadSheet ExamplesSamples DocumentationDoc Download Licensing Prices Buy Contacts

4. Column sets

Table rows with different columns

  • Column sets


    It is possible to define more column sets in grid. These column sets are not defined explicitly, there are only defined by columns in the new column sets.
    The columns in the second and next column sets are defined in the column part name + $ + column set name. For example Cols$Set2: [ { id:"Col1" }, { id:"Col2" } ]
    This example contains three sets, the first set without name, "Set2" and "Set3".
  • If the second and next column sets contain columns only in some column parts, the other column parts share columns with the first column set.
    In this example there are shared L_1 and L_2 columns with all three sets and R1_1 and R1_2 columns with the first two sets.
  • Every table row can have assigned its column set by

    S

    attribute. Every row has always one column set, without S attribute has the first column set.
  • The rows with different column sets are often in different tree level, but it is not required. In this example the Set2 on the second level and Set3 on the third level.
  • The column sets are often used for master / detail relationship or for visually nesting grids - FastGrid does not support real nesting of FastGrids or FastGrid inside another FastGrid cell.
  • Margin


    With the column sets there is usually defined also row and column margin to visually separate the sets or visually display another grid inside FastGrid.
  • Every row can have defined

    MarginTop

    and

    MarginBottom

    .
    It is possible to set different or only margin for the first / last row in part

    TopMarginTop

    and

    TopMarginBottom

    , for for the first and last row in tree (children on the same level L) by

    FirstMarginTop

    and

    LastMarginTop

    and for the first and last row in Block by

    BlockMarginTop

    and

    BlockMarginBottom

    .
    The color of the margin can be set by

    MarginTopColor

    and

    MarginBottomColor

    , they can be also different per column part.
  • Every column can have defined

    MarginLeft

    and

    MarginRight

    .
    It is possible to set different or only margin for the first / last column in part

    LeftMarginLeft

    and

    RightMarginRight

    , for for the first and last column in tree (children on the same level L) by

    FirstMarginLeft

    and

    LastMarginRight

    and for the first and last column in Block by

    BlockMarginLeft

    and

    BlockMarginRight

    .
    The color of the margin can be set by

    MarginLeftColor

    and

    MarginRightColor

    , they can be also different per row part.
  • The space after the last column in the column set, when the column sets have different widths is controlled by Cfg attribute

    FillRest

    and cell attribute

    MarginRestColor

    .