Spanned cells Column sets Pivot grid With TreeGrid Gantt chart
Microsoft Excel sheet Empty JSON sheet
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
| 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 | ||||