News in version
TreeGrid Gantt chart SpreadSheet Examples Documentation Download Development Licensing Prices References Contacts Buy Try it free
Live examples
Grids and tree grids

Complex grid - the first one Complex grid - RTL mode Large table with paging Large table without paging Multiline & images - books Positions and spanning Photo album - images PivotTable - 2D grouping Schools - list and ratings File and directory browser Extended JavaScript API Sharing & synchronization 1 000 000 rows, 1 000 cols

Sheets

Microsoft Excel sheet TreeGrid sheet TreeGrid sheet - RTL mode

Gantt and bar charts

Gantt & Network chart Gantt & Network chart - RTL Simple Gantt chart Big Gantt chart - 1000 rows Gantt chart tree by grouping Resources usage chart Run chart - bar chart Grouping bars - run groups Joined boxes and containers Line chart and XY charts

Live grid tutorials
Basic (rows and columns)

1. Basic grid 2. Rows 3. Columns 4. Default rows, columns 5. Rows manipulation 6. Rows identification

Cells (types, formats, edit)

1. Edits - inputs & multiline 2. Combos & checkboxes 3. Html, links, imgs, buttons 4. Space buttons & tabs 5. Permissions & validation 6. Cell CSS style & color 7. Conditional formatting 8. Custom controls & editing 9. Events & custom dialogs 10. Column & row spanning 11. Dynamic cell spanning

Tree (rows, columns, groups)

1. Row tree 2. Column tree 3. Grouping rows to tree

Sorting rows

1. Sorting rows

Filter and search

1. Filtering rows 2. Filtering in tree 3. Search & advanced filters

Dragging

1. Dragging rows 2. Dragging between grids 3. Dragging external tag

Paging (rows, tree, columns)

1. Client root paging 2. Client child paging 3. Client column paging 4. All client paging 5. Adding pages dynamically 6. Server root paging 7. Server child paging 8. All server paging

Master and detail

1. Nested detail simple 2. Nested detail tables 3. Master detail simple 4. Master detail tables 5. Master detail more tables 6. Master detail in tree 7. Master detail trees 8. Nested detail nested deep 9. Nested detail server paging

Calculations (cell formulas)

1. Calculated columns 2. Calculated rows 3. Calculation order 4. Calculated rows in tree 5. Calculation order in tree 6. Calculated attributes 7. Editable calculated cells

Live Sheet tutorials
Sheet features

1. Row and column Index 2. Auto size (auto adding pages) 3. Row&column manipulation 4. Cell manipulation 5. Cell style 6. Editable formulas (ids) 7. Editable formulas (indexes) 8. Cell format 9. Outside edit 10. Auto tree

Live Gantt tutorials
Main bar (Gantt chart)

1. Main bar 2. Discrete main bar 3. Main bar plans 4. Summary tasks

Run bar (Bar chart)

1. Run array definition 2. Run JSON definition 3. Run summary definition 4. Run drag 5. Run groups & API 6. Run bar as task 7. Run box as task 8. Network diagram 9. Run join and drag 10. Run external drag 11. 2 fixed levels containers

Flags and points

1. Flags 2. Points

Display, zoom, paging

1. Header & background 2. Zoom 3. Paging 4. Synchronizing more Gantts

Dependencies & scheduling

1. Constraints 2. Dependencies 3. Schedule tasks 4. Critical path

Calendars

1. Calendars exclude

Resources

1. Resources 2. Availability

5. Cell style

Cell text styles, color, shadow, size, align, background

  • Dynamic style


    Dynamic style is turned on by <Cfg> attribute

    DynamicStyle

    and permits changing style attributes and also undo / redo these actions by users.
    It shows also the style buttons on default Toolbar.
    • Text style attributes


      Text style is set by bit array in

      TextStyle

      and controls bold font, italic font, line below, line through, line above. Lower case characters as small caps.
      Every the text style setting can be set or cleared individually by appropriate action.
    • Text and background colors and shadows


      Text color is set by

      TextColor

      , background color by

      Color

      .
      Text shadow style is set by

      TextShadow

      and / or the text shadow color by

      TextShadowColor

      . The predefined text colors are in <Cfg> TextColors, background colors in DefaultColors, shadows in TextShadows and shadow colors in TextShadowColors.
      All the predefined color lists can be fully customized to contain more, less or different colors. The predefined shadows can be customized in CSS.
    • Font and size


      Font name is set by

      TextFont

      and font size by

      TextSize

      .
      The predefined font names are in <Cfg> TextFonts and predefined font sizes in TextSizes.
      Both the predefined lists can be fully customized to contain more, less or different items.
    • Align, wrap and rotate

      Horizontal alignment is set by

      Align

      , vertical alignment by

      VAlign

      .
      Cell can be rotated by 90 or 270 degrees and is set by

      Rotate

      . Wrapping cell value vertically is set by

      Wrap

      .
  • Dynamic border


    Dynamic border is turned on by <Cfg> attribute

    DynamicBorder

    and permits setting and changing individual cell border width, style and color and also undo / redo these changes.
    It also shows the Border button on default toolbar.
    The border is set by attributes for specific edge

    BorderTop

    ,

    BorderBottom

    ,

    BorderLeft

    and

    BorderRight

    .
    The border can be modified for every edge or for more or all edges at once.
    There are 8 predefined border width and styles in TreeGrid: 0px, 1px solid, 2px solid, 3px solid, 1px dotted, 2px dotted, 1px dashed, 2px dashed. Every border style can have any color.
  • Dynamic span


    Dynamic span is turned on by <Cfg> attribute

    DynamicSpan

    and permits spanning and splitting cells and also undo / redo these changes.
    It also shows the Span and Split buttons on default toolbar.
    The horizontal span is set by

    Span

    attribute, vertical span by

    RowSpan

    attribute.
  • Mass changes


    All the style, border and span can be affected by mass change like clear cells, move cells, copy cells, auto fill cells, copy & paste cells via clipboard.
    To be the attribute affected by the mass change, include in it in

    EditAttrs

    list.