Type Auto - automatic type

FastGrid documentation

Auto type is automatic type, the resulted type is chosen according to the cell value and Format.
It chooses among Bool (as TRUE / FALSE words, not as checkbox), Number, Date and String types.
The Bool type is chosen if the cell Format is set to "!". Or it is chosen if the Format is not set and the value is JavaScript Boolean true or false.
The Date type is chosen if the cell Format is set to some date format.
The Number type is chosen if the cell Format is set to some number format. Or it is chosen if the Format is not set and the value can be converted to number.
The String type is chosen if the cell Format is "@". Or it is chosen if the Format is not set and the value cannot be converted to number.

The displayed values TRUE and FALSE for Bool type are defined in Text object, attributes $true and $false.
The Auto type is cell default type. It can be set also explicitly by setting Type to "Auto".
If set and the entered value is "true" or "false" (case insensitive), the cell gets the Boolean value true or false.
If not set and the entered value is "true" or "false", it is set to cell value as string.
The true and false keywords are defined in Text object, attributes $true and $false.
If can be set and deleted date Format after editing cell or calling SetString.
1 - If entered value is recognized date string and cell has no Format, the Format is set to AutoDateFormat.
2 - Like 1 and it clears the cell Format if it is set to AutoDateFormat and the entered value is not recognized as valid date.
If accepts month and am/pm names in date.
1. bit &1 - if set, accepts long month names (min 3 characters or CJK character).
2. bit &2 - if set, accepts all month names, including short names.
3. bit &4 - if set, accept long am/pm names (min 2 characters or CJK character).
4. bit &8 - if set, accepts all am/pm names, including on character names like a or p.
Date format assigned to the cell Format when entering valid date to Auto type cell and AutoDate is set.
It can be set to any valid date format string.
There are especially predefined formats "a1", "a2", "a3", "a4" and A1", "A2", "A3", "A4" that omit not set parts in the date / time. The higher ax, the more parts are omitted.
The lowercase 'ax' use localized Standard format parts, the uppercase 'Ax' uses Standard full format.
Number format to display numbers in Auto type cell if the cell Format is not set. By default it is empty to use unformatted numbers.
It can be set to any valid number format string.
It can be set also to comma separated string or array of pairs as [max1,format1,max2,format2,max3,format3,...]. The appropritate format is chosen if the value is less than its max. If max is negative, it is chosen if the value is less or equal the max. The array must be sorted according the max ascending.
Default value for Sheet is "-1e11,0.#####E+00,-0.0001,0.#########,-1e-320,0.#####E+00,1e-320,0.#########,0.0001,0.#####E+00,1e11,0.#########,,0.#####E+00".
If can be set and deleted percentage number Format after editing cell or calling SetString.
1 - If entered value is number ending by '%' and cell has no Format or it is AutoDateFormat, the Format is set to AutoPercentFormat.
2 - Like 1 and it clears the cell Format if it is set to AutoPercentFormat and the entered value is not number endeing by '%'.
Number format assigned to the cell Format when entering percentage number to Auto type cell and AutoPercent is set.
It can be set to any valid number format string containing %.
If set and Type is Auto and value contains valid number or date range, it is formatted and aligned as number / date even if cell has not set Range attribute.
If set to 2 and Type is Auto, it also replaces the value and range separators in strings by their display variants.
If set, the Auto type cell can contain Html code to format the text like in Html Type.
If not set, the Html in Auto type is escaped like in String type.
Using many cells with HTML code remarkably slows down paint!
If set, all zero values in Number and Auto types are displayed empty or as EmptyValue value.
If set to 2, it hides the zero values also in toolbar cells.
0 - all dates in grid are integer numbers as count of milliseconds since 1/1/1970.
1 - all dates in grid are floating point numbers as count of days since 1/1/1900.
It affects everything, input data and output data if dates are numbers and all dates for API.
Setting to 1 is useful especially if importing xlsx file with dates.
Starting cell value by this character forces it to display as String type.
This first character is not displayed in the cell. It is ignored in editable formulas. Default is apostrophe.
If preserves numbers in strings as strings in Auto type, if exact number representation would change if converted to number.
For Number type the conversion is always done like for ExactNumbers = 0.
0 - preserves none, all number strings are converted to numbers, "0123" => 123, "123 " => 123, "12345678901234567890" => 12345678901234567000 and "1e3" => 1000.
1 - preserves only leading zeros. Preserves "0123" => "0123", but converts the others: "123 " => 123, "12345678901234567890" => 12345678901234567000 and "1e3" => 1000
2 - preserves all except leading and trailing spaces. Preserves "0123" => "0123", "12345678901234567890" => "12345678901234567890" and "1e3" => "1e3", but converts "123 " => 123.
3 - preserves complete string including spaces. Preserves "0123" => "0123", "123 " => "123 ", "012345678901234567890" => "12345678901234567890" and "1e3" => "1e3".
If the number contains spaces inside in input data, the value is always string, including calculations, e.g. "12 3" will be "12 3".