Spanned cells Column sets Pivot grid With TreeGrid Gantt chart
Complex MS Excel sheet Excel sheet with 100k rows Excel sheet with million rows Empty JSON sheet
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
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
Microsoft Excel sheet TreeGrid sheet TreeGrid sheet - RTL mode
1. Basic grid 2. Rows 3. Columns 4. Column sets 5. Row sets 6. Default rows, columns 7. Rows manipulation
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
1. Row tree 2. Column tree 3. Grouping rows to tree 4. Grouping columns to tree 5. Loading rows on demand
1. Sorting rows 2. Sorting columns
1. Filtering rows 2. Filtering columns 3. Filtering in tree 4. Searching in cells
1. Dragging & pasting rows 2. Dragging & pasting cols 3. Dragging from / to outside
1. Basic grid 2. Rows 3. Columns 4. Default rows, columns 5. Rows manipulation 6. Rows identification
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
1. Row tree 2. Column tree 3. Grouping rows to tree
1. Filtering rows 2. Filtering in tree 3. Search & advanced filters
1. Dragging rows 2. Dragging between grids 3. Dragging external tag
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
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
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
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
1. Main bar 2. Discrete main bar 3. Main bar plans 4. Summary tasks
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
1. Header & background 2. Zoom 3. Paging 4. Synchronizing more Gantts
1. Constraints 2. Dependencies 3. Schedule tasks 4. Critical path
| Feature | Cfg attribute | Row / column / cell attribute | Lock name | Remarks | |
|---|---|---|---|---|---|
| Edit cell value | Editing | cell / tool NoEdit | Edit, Write, EditAll, NoEdit, Controls | ||
| Edit cell formula | FormulaEditing | cell / tool FormulaNoEdit | Formula, EditAll, NoEdit | ||
| Edit cell style | EditingStyle | cell / tool NoEditStyle | Style, StyleAll, NoEdit | ||
| Edit cell link | EditingLink | cell / tool NoEditLink | EditLink, WriteLink, EditAll, NoEdit | ||
| Edit cell tip | EditTip | ||||
| Focus cell(s) | Focus | cell / tool NoFocus | Focus | ||
| Mouse hover cell | Hover | cell / tool NoHover | Hover | ||
| Navigate to cell link | Link | ||||
| Show tip for cell under mouse | Tip | ||||
| Change mouse cursor for cell | Cursor | ||||
| Resizing row height | ResizingRows | row NoResize | ResizeRow | The resizing by dragging edge is permitted by column attribute UseResize | |
| Resizing column width | ResizingCols | colNoResize | ResizeCol | The resizing by dragging edge is permitted by row attribute UseResize | |
| Resizing part height | ResizingRowParts | part NoResize | ResizeRowPart | ||
| Resizing part width | ResizingColParts | part NoResize | ResizeColPart | ||
| Adding / copying rows | AddingRows | row NoDuplicate | AddRow | ||
| Adding / copying columns | AddingCols | col NoDuplicate | AddCol | ||
| Moving / copying rows | DraggingRows | row NoMove,NoDuplicate | MoveRow, IndentRow, FixRow | The moving by dragging the cell is permitted by cell attribute UseMove | |
| Moving / copying columns | DraggingCols | col NoMove,NoDuplicate | MoveCol, IndentCol, FixCol | The moving by dragging the cell is permitted by cell attribute UseMove | |
| Deleting rows | DeletingRows | row NoDelete | DeleteRow | ||
| Deleting columns | DeletingCols | col NoDelete | DeleteCol | ||
| Hiding / showing rows | HidingRows | row NoHide | HideRow | ||
| Hiding / showing columns | HidingCols | col NoHide | HideCol | ||
| Selecting rows | SelectingRows | row NoSelect | SelectRow | ||
| Selecting columns | SelectingCols | col NoSelect | SelectCol | ||
| Expanding / collapsing rows | RowTree | row NoCollapse | CollapseRow | Row tree must be defined by row / part Treeattribute. | |
| Expanding / collapsing columns | ColTree | col NoCollapse | CollapseCol | ||
| Spanning / splitting cells | Span | ||||
| Copy to clipboard | Copying | row / col NoCopy | Copy | ||
| Pasting from clipboard | Pasting | row / col NoPaste | Paste | ||
| Exporting to xlsx/csv/html | Exporting | row / col NoExport | Export | If exporting more grids, the one grid export can be restricted by Cfg NoExport | |
| Printing | Printing | row / col NoPrint | Print, Pdf | If printing more grids, the one grid print can be restricted by Cfg NoPrint | |
| Undo / redo changes | Undo | row / col NoUndo | Undo | ||
| Sorting rows / columns | Sorting | row / col NoSort(children) | Sort | To restricts sorting rows by values in the column set the column attribute NoSortBy | |
| Filtering rows / columns | FilterAction | row / col NoFilter | Filter | To restricts filtering row / column by the cell value, set cell attribute NoFilterRow/NoFilterCol | |
| Grouping rows / columns | Grouped | row / col NoGroup | Group | To restricts grouping by the column / row set the row / column attribute NoGroupBy | |
| Pivot | PivotDisabled | row / col NoPivot | Pivot | ||
| Searching in cell values | SearchAction | row / col / cell NoSearch | Search | ||
| Import files | ImportAction | Import | Drop file to grid must be permitted by DropFiles | ||
| Sending changes to server | Save | If saving more grids, the one grid save can be restricted by Cfg NoSave | |||
| Reload data from server | Reload | ||||
| Changing grid settings | Settings | ||||
| Restrict managing saved settings | Cookie, AddCokie, DeleteCookie | ||||
| Moving toolbar cells | DraggingTools | tool NoMove,NoDuplicate,NoDelete | Toolbar | ||
| Moving toolbars | DraggingToolbars | Toolbar | Dragging individual toolbar is not possible to restrict, only setting its Pos>=3 will drag it with its predecessor. | ||
| Hiding / showing toolbars | HidingToolbars | toolbar NoHide | Toolbar | ||
| Hiding / showing toolbar cells | HidingTools | tool NoHide | Toolbar | ||
| Resizing toolbar height | ResizeToolbar | The resizing by dragging edge is permitted by toolbar cell attribute UseResize | |||
| Resizing toolbar cell width | ResizeTool | The resizing by dragging edge is permitted by toolbar cell attribute UseResize | |||
| Adding / copying images | AddingImages | image NoDuplicate | AddImage | Drop image to grid must be permitted by DropFiles | |
| Deleting images | DeletingImages | image NoDelete | DeleteImage | ||
| Dragging images | DraggingImages | image NoMove | MoveImage | ||
| Changing images | ChangingImages | image NoChange | ChangeImage | ||
| Sheets manipulation | ChangingSheets | AddSheet, DeleteSheet, HideSheet, RenameSheet, MoveSheet | |||
| Defining and editing names | Name | ||||