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 Large table with paging Large table without paging Multiline & images - books Positions and spanning Photo album - images Dynamic Adobe Flash Dynamic MS SilverLight PivotTable - 2D grouping Schools - list and ratings File and directory browser Extended JavaScript API Sharing & synchronisation 1 000 000 rows, 1 000 cols

Sheets

Microsoft Excel sheet TreeGrid sheet

Gantt and bar charts

Gantt & Network chart Simple Gantt chart Big Gantt chart - 1000 rows Gantt chart tree by grouping Resources usage chart Run chart - bar chart Grouping bars - run groups 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

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

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 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

2. Client child paging in tree

Automatic paging of child rows in tree on client side

  • There are three independent ways, how to page children in tree. None of the method affect root rows, they affect only children of some parent rows.
  • Render children on expand

    by Cfg attribute

    ChildPaging

    ='2'.
    The parent rows must be collapsed (must have set Expanded='0') to take the child paging effect. To collapse all rows in grid define <Def><D Name='R' Expanded='0'/></Def>.
    It is default setting, the ChildPaging is set to 2 by default.
    The children are rendered only on first expand. To not slow the grid if there are too many children rendered, set RemoveCollapsed='2' to remove the rendered children on collapse and render them on every expand.
  • Render children on scroll

    by Cfg attribute

    ChildParts

    ='2'.
    It renders children when they become visible by scrolling, similarly to root pages. It can render only subset of children of one parent.
    The count of children rendered at once (the size of the part) is set by Cfg attribute ChildPartLength.
    When the parent is expanded or expanding, it can render immediately few first children to speed the rendering. Their count is set by Cfg attribute ChildPartMin.
    When grid has too many rendered rows, it can be slow. It is possible to remove unused child parts by setting MaxChildParts attribute.
    It is also possible to render all children on start or on expand, but with progress dialog to cancel the rendering and render the rest on demand, for this behavior set ChildParts='1'. See the second icon on toolbar.
  • Group children to sub parents

    by row attribute

    MaxChildren

    .
    When row children count exceeds its MaxChildren value, there are created new sub rows and the children are grouped to these rows, by MaxChildren count.
    To not group children with count only few rows above MaxChildren set MaxChildrenDiff, the rows are grouped after the count is higher than MaxChildren+MaxChildrenDiff.
    Some attributes of the newly created row can be specified in default row named CPage (<D Name='CPage' ... />).