Changes log (txt file) Compare FastGrid 1.0 & TreeGrid 17.1
Angular Ember Express React Svelte Vue Other frameworks NodeJS server SalesForce LWC
Simple examples of creating FastGrid Create FastGrid Display grid Access grid by API Sheets, more grids switched in one place Layout and configuration Data rows, columns, toolbars, images Changes in data rows, columns, toolbars Saving changes to server Mark changes Loading children on expand parent Short format
Parts - ColParts and RowParts Part size Part scroll position Sets Column sets Row sets
Toolbar Cells Icon Height Width Toolbar position Dragging and manipulating cells Special toolbars
Row / column id Row / column index Row / column name
API to get grid objects Auto added columns & rows on scroll Blocks of rows / columns Adding / copying / moving Deleting Showing and hiding Layout menu Selecting rows and columns Fill cell values by dragging Locking grid against changes Undo & redo
Row and column tree Row tree Column tree Expand & collapse
Read and write any values by API Cell value Cell attributes Cell value & attributes in UTF8 Store
Editing During editing Validation and errors
Row cell side icons Icons definition Mark icons and charts Mark icons list Row cell floating images
Row height Column width Resizing rows and columns Padding Margin Cell span
Grid style and look Cell style permissions Cell style Cell outer border Cell inner border Alternate row & column background
Cell hyperlink Cell tooltip Static cells Other cell attributes Row & column attributes to speed up
Bool type Check side icon Bool type & Check side icon
JavaScript formulas Aggregate functions String aggregate functions Other functions
Formula rules Formula attributes Defined names for editable formulas Conditional functions Lookup functions Cell reference functions Logical functions Informational functions Mathematical functions Trigonometry functions Rounding numbers Number conversions String functions Date functions Summary functions
Dialog Dialog Place Dialog API Menu definition in Script Cell menu List Suggest
Sorting Sorting settings Comparing strings
Grouping Grouping settings Comparing strings Pivot grid
Filtering Filter settings Comparing strings
Search in cells Import files to gridExport files Export and copy to clipboard CSV data
Copy & paste Copy to clipboard Paste from clipboard
Grid size Grid scrollbars Paging and view Media rules - responsive design
Saving settings in storage or cookiesFocus cell and cell ranges Mouse hover cells Highlight cells, rows and columns
Mouse events Key events API events
API for iterating rows and columns Paint and repaint Various API methods
Basic description Main advantages Basic usage License Download Documentation
Bits - small integers or enums Integers or enums with strings Date and time Floating point numbers Special strings
Integer 1 char String 1 char Date 1 char Bits 1 char Integer 2 chars String 2 chars Date 2 chars Float 2 chars Integer 3 chars String 3 chars Date 3 chars Integer and double float 5 chars String 5 chars Date 5 chars Fixed length string Separated strings Adjacent strings Prefix for escaping string Fixed length data Unused custom codes Prefix for stored separator or length Prefix for stored base number Unused basic ucodes
chars signed decimals multiple limits varstrings escape base chars2 signed2 decimals2 multiple2 limits2
Internal coding Profiling times for ucode options Function referenceFeature |
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 | no | |
| 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 | |