Feature |
FastGrid |
TreeGrid |
Grid size | ||
| Maximum rows displayed in grid | about 5,000,000 without paging, without any scroll gap or delays |
about 10,000 without paging about 100,000 with client paging about 1,000,000 with server paging |
| Maximum columns displayed in grid | about 1,000,000 without paging, without any scroll gap or delays |
about 200 without paging about 2,000 with client paging |
| Fast changes in grid | no, individual changes affect display | |
Create grid | ||
| Create grid by HTML tag | ||
| Create grid by API | ||
Data formats | ||
| JSON format | ||
| XML format | no | |
| Short format | ||
Data communication | ||
| AJAX IO | ||
| Custom AJAX IO | ||
| JSONP load by &script> | ||
| Form submit | ||
| Direct data | ||
| Download rows on demand | ||
| Download menu items on demand | ||
| Download changes from server and apply | ||
| Get changes by API | ||
| Upload changes to server by AJAX | ||
| Automatic sessions and saving the session | no | |
Tree | ||
| Rows in tree | ||
| Row tree in more columns, per level | no | |
| Columns in tree | ||
| Grouping rows into tree | ||
| Grouping columns into tree | no | |
| Creating pivot grid | ||
| Indent rows / columns | ||
Sort, filter, search | ||
| Sorting rows | ||
| Sorting columns | no | |
| Auto sorting after change in the sorted column | no | |
| Filtering rows by individual columns | ||
| Filtering columns by individual rows | no | |
| Search text or number in cells | ||
| Search in cells by user expression | no | |
Printing | ||
| Print grid | ||
| Split rows and columns for printing to pages | ||
| Export to PDF | ||
Copy & paste via clipboard | ||
| Copy & paste cell values | ||
| Copy & paste cell formats | no | |
| Copy & paste cell styles | no | |
| Copy & paste compatiblity with MS Excel | ||
Spread sheet | ||
| Export to xlsx | ||
| Import xlsx to grid | ||
| More sheets in grid | ||
| Focusing more cells | ||
| Move cells by dragging focus | ||
| Auto fill cell values by mouse dragging | ||
| Editable formulas similar to MS Excel | ||
| Functions for editable formulas | ||
| Custom functions for editable formulas | ||
| Defined names of cells or cell range for formulas | ||
| Choosing cell / cell ranges for formula by mouse dragging | ||
| Choosing cell / cell ranges for formula in other sheets | no | |
| Color cells in formula and in sheet during editing | ||
Cells | ||
| Calculating cell value by JavaScript formula | ||
| Calculating cell attribute values by JavaScript formula | ||
| Summary functions for JavaScript formulas | ||
| Custom functions for JavaScript formulas | ||
| Cell row span | ||
| Cell column span | ||
| Dynamic cell row and column span | ||
| Automatic cell row and column span | no, used overlay | |
| Overlay cell text to next empty cells | ||
| Cell hyperlink, in cell and in cell text | ||
| Cell tooltip | ||
| Cell hint to show the overflowed cell value | no, used tooltip | |
| Static cells not rerended | no, use events to recreate content | |
| Events for external objects in cells | no, used Static cells | |
Cell types and formats | ||
| Automatic cell type according to value | ||
| Editable string - base text type | ||
| Editable html - rich text type | ||
| Editable and formatted number type | ||
| Editable and formatted date type | ||
| Popup calendar to pickup date or date ranges | ||
| Dates dialog to choose date ranges and repeat | no | |
| Bool type as checkbox with 2 - 3 states | ||
| Bool icon with more states than three | no | |
| Radio buttons | no, only more Bool icons | |
| Switch or list button with more states and icons | no, only Bool icon | |
| Panel with action icons for row / column | ||
| Place text on absolute position in cell | no | |
| Special formatted text type | no | |
| Editable link type | no, link edited in dialog | |
| Editable image type, entering image URL | no | |
| Upload file with cell value | no | |
| Cells with more values or date / number ranges | ||
Cell icons & images | ||
| Cell side icon | ||
| More cell side icons | no, can use Panel | |
| Icons adjacent to cell text | no | |
| Cell side buttons | no, replaced by side icons | |
| Custom side icons | ||
| Small cell state icons | no | |
| Mark changed, not editable, etc. cells | ||
| Mark added, deleted, changed, etc. rows & columns | ||
| Floating images like in MS Excel | ||
| Dragging floating images to grid | ||
| Inserting floating images to grid from disk | ||
| Deleting, resizing, moving, rotating, cropping images | ||
Menus & dialogs | ||
| Complex menus | ||
| Popup list to choose one or move values | ||
| Related popup lists | ||
| Popup suggest lists (auto complete) | ||
| Cell popup list | ||
| Popup grid | ||
Editing | ||
| Inplace editing in cells | ||
| Rich texts editing | ||
| Toolbar icons for rich texts editing | ||
| Multi line editing | ||
| External edit in separate toolbar cell | ||
| Edited value validation | ||
| Entering individual tags visually marked and separated | no | |
| Permanent edit mode | no | |
Rows and columns | ||
| Every row can have different columns | no | |
| Every column section can have different rows | no | |
| Auto row and column index, name and id | ||
| Default rows and columns with predefined settings | ||
| Auto adding / removing rows / columns on scroll | ||
| Adding, copying and deleting rows / columns | ||
| Moving and resizing rows / columns by mouse dragging | ||
| Showing / hiding rows / column, also from menu | ||
| Selecting rows / column and manipulate together | ||
| Row / columns blocks to manipulate together | ||
| Fix / freeze rows / columns on all sides | ||
Toolbars | ||
| Toolbars with icons and normal cells | ||
| More toolbars on the same line | no | |
| Auto arranged toolbars for window size | no, can be done by Media | |
| Manually arranged toolbars and icons by users | no | |
Grid | ||
| Nested grids - another grid in cell | no, can be done by row sets | |
| Master & detail grids | no, can be done by API | |
| Update grid content for different screens & sizes | ||
| Lock individual grid features | ||
| Undo & redo queue | ||
| Fully customizable key and mouse actions | ||
| Grid message system | ||
| Global menu with grid settings | ||
| Saving grid settings to cookies / storage | ||
| Multiple saved configurations | no | |
| Animated actions in grid | YES | |
| Animated showing of dialogs / menus | ||
| Debugging and checking settings | ||
| Cell ids for automated testing | no | |
| RTL - right to left display | no | |
Focus and hover | ||
| Focus single cell | ||
| Focus more cells and cell ranges | ||
| Focus whole rows, columns, grid | ||
| Hover cell under mouse | ||
| Hover row under mouse | ||
| Hover column under mouse | no | |
| Highlight chosen cells or cell ranges | no | |
Scroll | ||
| Indepent column sections | ||
| Horizontal scrolling of all column sections | ||
| Indepent row sections | ||
| Vertical scrolling of all row sections | no, only Body section can be scrolled | |
| More scrollbars per section | no | |
| Custom scrollbars - size, style, colors | ||
| Sticky vertically scrolled rows | no | |
Paging | ||
| Display all row pages in grid | ||
| Display one row page in grid | no, FastGrid has no pages | |
| Vertical pager with pages list to navigate | no | |
| Horizontal pager with buttons to navigate | no | |
| Horizontal pager with page numbers navigate | no | |
Styles | ||
| More built-in grid styles and colors | ||
| Customizing styles | only with at least Partial sources | |
| User changing grid size | ||
| User changing grid scale | ||
| (Dynamic) styling individual cells (font, colors, ...) | ||
| (Dynamic) styling cell border | ||
| Styling inner cell border and other content | no | |
| Styling individual cells by CSS class | no, FastGrid uses JSON only | |
| Styling individual cells by HTML prefix / suffix | no, the HTML must be in value | |
| Toolbar icons for styling cells | ||
| Alternate row and column colors | ||
| Mouse cursors for individual cells | no, the cursor can be set globally | |
Languages | ||
| Customizable date and number formats | ||
| Support for languages and translations | ||
| Date and numbers for different languages | ||
| Full texts translated to different languages | no | |
Charts | ||
| Simple bar & line charts in row cells | no | |
| Separated line & XY charts | no | |
Gantt chart | ||
| Interactive Gantt chart | no | |
| Interactive bar chart | no | |