Positions, static and dynamic spanning, types and formats

Examples list

Live examples

FastGrid

Spanned cells Column sets Pivot grid With TreeGrid Gantt chart

FastSheet

Complex MS Excel sheet Excel sheet with 100k rows Excel sheet with million rows Empty JSON sheet

GanttChart

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

TreeGrid

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

SpreadSheet

Microsoft Excel sheet TreeGrid sheet TreeGrid sheet - RTL mode

FastGrid live tutorials

Basic (rows and columns)

1. Basic grid 2. Rows 3. Columns 4. Column sets 5. Row sets 6. Default rows, columns 7. Rows manipulation

Cells (types, formats, edit)

1. Values 2. Attributes 3. Cell types, formats, wrap 4. Cell popups list, suggest 5. Cell images and charts 6. Cell style and border 7. Cell sizes, margins, span 8. Toolbar size & position 9. Permissions & validation 10. Conditional formatting

Tree (rows, columns, groups)

1. Row tree 2. Column tree 3. Grouping rows to tree 4. Grouping columns to tree 5. Loading rows on demand

Sorting

1. Sorting rows 2. Sorting columns

Filter and search

1. Filtering rows 2. Filtering columns 3. Filtering in tree 4. Searching in cells

Dragging

1. Dragging & pasting rows 2. Dragging & pasting cols 3. Dragging from / to outside

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

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

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

Demonstration of various layout positions, column and row spanning, cell types and formats.
On top there is one row for both grouping and searching. Individual filter row is at bottom. Toolbar is moved between head and body.
There are three headers, two on top, one at bottom. Some header show spanned captions. It is still possible to move and resize columns, sort by columns.
The rows 4 and 18 show (vertical) row spanning, also with combination of column spanning. The rows 8 and 12 show html in whole section instead of cells, the row Liberec shows merging spanned cell.
There various setting of cell types and formats, for whole column or for individual cell. Also show right button in cell.

You can dynamically span and split selected cells.
Select cells by mouse left button and click to Span icon on toolbar to span the cells or to Split button to split spanned cells, if any.
Select the cells by right mouse button to span them automatically. Click to spanned cell by middle mouse button to split cells.