2. Rows

FastGrid rows and row parts

• RowParts

  
  The row parts and their order are defined in RowParts array. Default RowParts definition is in Defaults.js:
  RowParts: [
  { id:"Top", Type:"Toolbars" }, //. Top toolbars
  { id:"TopScroll", Type:"Scroll", Item:"$ItemTopScroll", Hidden:1 }, //. Top horizontal scrollbar, hidden by default
  { id:"Tree", Type:"Tree", Add:1, Item:"$ItemColTree" }, //. Column tree
  { id:"Head", Type:"Rows", ExportFixed:1, Highlight:0, Rel:100000, MinHeight:70, MinHeightResize:0 }, //. Head rows
  { id:"Body", Type:"Rows", Rel:2, MinHeight:70, MinHeightResize:0, Sealed:0, Group:"", NoData:"$NoData", MaxAuto:3000000, AcceptImages:1 }, //. Body rows
  { id:"Foot", Type:"Rows", Rel:100000, MinHeight:70, MinHeightResize:0 }, //. Foot rows
  { id:"BottomScroll", Type:"Scroll", Item:"$ItemBottomScroll" }, //. Bottom horizontal scrollbar
  { id:"Bottom", Type:"Toolbars" } //. Bottom toolbars
  ],
  It is possible to move, add or delete only some row parts in other RowParts definition, e.g. RowParts: [ { id:"TopScroll", Next:"Top", Hidden:0 } ]
  Or it is possible to redefine all row parts by adding first item in RowParts as { Clear:1 }
  

• Table rows

  with cells in columns
  • The table rows contain cells in columns. Cells can be spanned in both directions, similarly to HTML <TABLE> tag.
  • The table rows can be scrolled in both directions, vertically and horizontally. Although in some sections like Head or Foot the rows are usually fixed, not scrolled vertically.
  • The table rows can be nested in tree, sorted, filtered, grouped, added, deleted, moved (dragged).
  • The table rows are defined in in RowPart Type = "Rows", by default in Head, Foot and Body parts.
  • The table rows define their cell values in V or U array and similarly cell attributes in A or B arrays.
  • The table rows can contain data without special meaning and there are also predefined some feature rows:

    • Header

      row defined by D: "Header". Shows column captions. Provides column resizing and moving. Controls sorting settings.
      Header row has cells like any data row, it is possible to define Type, Format and other cell attributes.
      The Header cells are not editable, but can be changed from popup list like List. The default cell Type for Header row is Text, new line can be added by '&#x0a;' or can be retyped to Html and used <br>.

    • Index

      row defined by D: "Index". The same as Header, but shows column indexes instead of captions.
      

    • Filter

      row defined by D: "Filter". Controls filter settings.

    • Panel

      row defined by D: "Panel". It usually shows control icons in LeftIcons to manipulate columns.

• Toolbar rows

  with cells in rows
  • The toolbars define their own cells (in Cells array) not related to FastGrid columns. Every toolbar row can have different cells (their ids, widths and other attributes like Type and Format).
  • The toolbar cells cannot be spanned in any direction. The toolbar cell can show only one icon / button.
  • The toolbars are defined in RowPart Type = "Toolbar", by default in Top and Bottom parts.
  • To place some cells to right edge or to fill the rest of the row by cell(s), set the cell Rel attribute.
  • The toolbar rows can be placed more on one line or can be wrapped to more lines.
  • The toolbars can be shown / hidden / moved from Layout menu or when grid is switched to DraggingToolbars
  • See Toolbar rows documentation.
  • The toolbars can contain data cells without special meaning, but there are various predefined feature toolbars:
    • 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.