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 referenceFastGrid documentation
Integer or floating point numbers, the same as JavaScript "number" type.| "g" | General | For numbers under 1e-3 uses "0.###e+00", for numbers above 1e10 uses "0.########e+10", for other numbers uses "0.######", . |
| "f" | Fixed | Uses "0.00" |
| "fs" | Fixed with group separator | Uses ",0.00" |
| "c" | Currency language dependent | For positive numbers uses "$,0.00", for negative numbers "($,0.00)" or "-$,0.00" |
| "cm" | Currency with negative sign | For positive numbers uses "$,0.00", for negative numbers "-$,0.00" |
| "cmr" | Currency with colored negative sign | For positive numbers uses "$,0.00", for negative numbers "[brown]-$,0.00" |
| "cp" | Currency with negative in () | For positive numbers uses "$,0.00", for negative numbers "($,0.00)" |
| "cpr" | Currency with colored negative in () | For positive numbers uses "$,0.00", for negative numbers "[brown]($,0.00)" |
| "p" | Percent multiplied by 100 | Uses "0.00%" |
| "pp" | Percent without multiplication | Uses "0.##\\%" |
| "r" | Rounded | For numbers under 1e10 uses "0.0000", above uses "0.########e+10". |
| "e" | Scientific | Uses "0.000000 E+000" |
| 0 | Place for a digit, displays digit or 0. If there are more digits than count of 0 and # in integer part, all the rest digits are written left to the first 0 or #. |
| # | Place for a digit, displays digit or nothing if there are no more digits. Has sense only for decimal part or exponent definition. |
| ? | Place for a digit, displays digit or empty space if there are no more digits. Has sense only for decimal part. |
| 8 |
Hidden digit, the digit will not be displayed. Digits are always counted from decimal separator position to both sides. It cannot be combined with '#' in the same number part. It can be used only for left and right side of integer part or left side of decimal part. Example: Val = "123456.789", Format = "8000" => Result = "456"; Format = "088" => Result = "1234"; Format = "8.80" => Result = "8"
|
| . |
(dot) Decimal separator. Displays decimal separator defined in file Texts.js, object Format, attribute DecimalSeparator. (dot by default). Can be only used only once. |
| , |
(comma) This character has two meanings: 1) If it is placed between any digits characters ('0' or '#') left to decimal separator, there will be every three digits separated by thousand separator defined in file Texts.js, object Format, attribute GroupSeparator. (comma by default). Example: Val = "123456.789", Format = ",0.00" => Result = "123,456.79"
It is possible to specify different number of separated digits than 3 by Format attributes GroupCount1 (the last group) and GroupCount (other groups).For example for Indian number format set Format: { GroupCount1:3, GroupCount:2 }
2) If it is placed between last digit and decimal separator (or to the end if decimal separator is not used), the value will be divided by 1000. There can be more commas to divide more times. Example: Val = "123456.789", Format = "0,,.00" => Result = "0.12"
|
| % |
Place for '%' character (it is defined in file Texts.js, object Format, attribute Percent). If it is present, the number is also multiplied by 100. To place the exact '%' character without multiplying by 100, write it with backslash "\\%". |
| E, e E-, e- E+, e+ |
Result will use exponential notation. To this location is placed 'E' or 'e' letter followed by digits of exponent. If used exponential notation, the number of digits before decimal separator is given by count of all digit places ('0' or '#') before decimal separator. This letter must be followed by number digit places ('0' or '#') to specify number of exponent digits (max 3). E or e specifies case of E letter, E+ uses sign + for positive exponents, E- and E uses no sign for positive exponents. Example: Val = "123456.789", Format = "000.000 E+00" => Result = "123.456 E+03"
Example: Val = "-0.0123456789", Format = ":0.0000(E000)" => Result = ":-1.2346(E-002)"
|
| ; |
(Semicolon) Separates formats used according to the value size and type. There can be up to five formats without condition and next more conditional formats. The conditional formats should be placed before formats without condition. 1st format is used for positive numbers (and for 0 if the 3rd format missing). 2nd format is used for negative numbers (without minus sign). 3rd format is used for 0 and for all numbers rounded to 0 with given precision. 4th format is used for text. It can contain character @ to place actual text value here. If it does not contain the @, the actual value is not displayed. 5th format is used for NaN. If it is missing, the default NaN and NaNFormat are used. If the 4th format is missing, the Auto type displays the text value as is and Number type shows NaN. If the 2nd or 3rd format contains the character @ it is automatically used for the text value and not for negative or zero values. |
| [color] | Colors the whole part (parts are separated by semicolon) in given CSS color. |
| [condition] |
Uses given part (parts are separated by semicolon) only if the value fulfills the condition. Condition can be: [=value], [<>value], [<value], [<=value], [>value], [>=value]. |
| $ |
Places actual Currency string, default is $. |
| / |
(slash) Fractional number. It is followed by number of ?, their number specifies maximal fraction-1, e.g. "/???" means 1/999. If followed by digits instead of ?, the whole number specifies exact fraction to display, e.g. "/16" will display 1/16 - 15/16. |
| \ |
(backslash) Escape character, the next character is placed to output without any changes. Use to place format characters as 0 # . , E e + - \ " ' %. In JSON all the characters '\' must be doubled. To place the '\' itself, doubled it '\\' (in JSON as '\\\\'). |
| 'xxx' or "xxx" |
Characters in quotes or double quotes are placed to output without any changes. Use to place format characters as 0 # . , E e + - \ " ' %. |