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 Animations in grid
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 reference2.1.2
B: Search text toolbar cell did not show text after change due animation
B: PaddingLeft / PaddingRight was added to edited text in toolbar cell
C: Updated List and Edit toolbar cells look in styles
2.1
+: Added animations to row, column and cell changes in grid
+: Added animations to hover and focus cursor movement and resize
+: Added InvertColors bit 2 to invert also border colors in inverse styles like Dark and Black
B: Beige style gradient background could be incorrectly position on IconZoom change
C: Removed preloading fonts defined by data:font
C: Increased waiting time for default fonts LucidaSans and OpenSans from 3s to 60s
B: GetResult and SetResult for toolbar and filter cells did not work correctly
+: Added new style "Plain" and updated grid for styles without borders
B: Hidden toolbar cell could be focused by keys
B: Progress dialog was not displayed for first time
2.0
+: Added new styles "Beige", "Green", "Blue" and "Black".
C: "Black" style renamed to "Dark" and updated.
+: "Standard" style renamed to "Gray". "Gray" style has only default Base settings. "Standard" style name preserved only for compatibility.
C: Default style changed to "Gray" with the same settings as Base (Standard) style
+: Added various text sizes and styles to TextStyles for styling headers
+: Added various color names to Colors for styling
+: Added and updated various radius attribute to Borders for rounded borders
+: Added attributes HtmlWidth and HtmlHeight for row and column
C: Updated White style to show slightly rounded borders
+: Added attribute PaddingTextBorder to reduce CellBorder with outside icon
+: Added attributes GroupRel and GroupMinWidth to use in group tree column instead of Rel and MinWidth
+: CellBorder round attribute can contain four values to set the corners differently
+: Added attribute ApplyAll to all defaults and CellBorders to use when loading it to initialized grid to apply its attributes also to all inherited defaults
B: OverflowTop==-1 blocked automatic resizing row when it have set bigger font
B: CellBorder Round attribute was ignored in Highlight
B: changedtool color was not applied
B: noteditabletool / readonlytool color was incorrectly applied to CellBorder
B: Default scrollbar thumb width was cut off by one pixel
B: GroupList and Group icons on toolbar could be dragged
B: Message on reloading ignored actual Style
+: Added attribute Round to MessageStyle for rounded borders
B: Resize width mouse cursor could be incorrectly hidden for toolbar cell
B: Message did not show shadow by default
+: Added toolbar "Styles" to show FastGrid styles, text sizes, row heights, toolbar icons scale and grid scale
+: Added SvgDefs defined as string or array to support gradients in styles
+: Added Cfg attribute InvertColors to automatically invert custom colors in inverted dark styles
B: During export showed messages in ExportStyle
+: Added Light (font-weight:300 / 600) and Condensed (font-stretch:condensed) options to TextStyle
+: Added new optional base font "Open Sans" in Grid/Fonts/OpenSansUnicode12s.woff2.js. It supports also Light and Condensed versions for TextStyle &4 and &8
+: Added CSS object to input JSON to add custom CSS to grid
+: Added attribute Font to Media to apply media on particular base font
+: Base Font object can be loaded also to initialized grid to change base font on style or other change
+: Added Cfg NarrowValues to specify the constants set by Narrow
B: Switching DraggingToolbars could throw JS error when Sheets were present without NewSheet
B: Exporting incorrect HTML like "<span>A & B</span>" without normalizing (~FE&4) produced invalid xlsx file
B: When exporting html entities as "&#xXX", these entities could be escaped when contained letters
B: Horizontal scrollbar could be unexpectedly hidden in Chrome on some DOM changes
1.0.4
+: Error message "$PdfUrlFile" is shown when PdfUrl is on file:// protocol and cannot be run
B: Editing Html type cell could produce XSS bug and permitted running JS code.
1.0.3
B: onafterprint handler was not removed after printing
1.0.2
B: Printing to PDF more column sets could throw JS error and produce blank PDF
1.0
! First released version