Type Auto - automatic type

TreeGrid documentation

Included only in Sheet component.

Auto type is automatic type, the resulted type is chosen according to the cell value and Format.
It chooses from text (Lines), number (Float) and date (Date).
If the Format is not set, the value is shown as is, if the value can be converted to number, it is right aligned, otherwise it is left aligned.
If the Format is set and the value is a string, it is formatted according to date or number format text part - if the text format part is not defined, the text is displayed as is. It is always left aligned.
If the Format contains date format, the number value is formatted as date.
If the Format is set and does not contain date format, the number value is formatted as number.

Entered value and value in input data is converted to number or date, if it is possible.
If converted to date, the appropriate standard format is chosen according to the entered date/time (chooses from m, d, h, H, j, J, y, t, T, i, I).
To define Auto type, set column or cell attribute Type to "Auto".
The Auto type supports number format, date format and '@' as plain text.
It does not support TreeGrid Text format.
The Format specifies the value type, see the Type attribute. It is set to 1 if the cell has Format and the format was chosen or entered by a user or loaded from data.
Starting cell value by this character forces its auto type to text.
This first character is not displayed in the cell. It is ignored in editable formulas. Default is apostrophe.
In Auto type it forces to always display the value as string.
0 - all dates in grid are integer numbers as count of milliseconds since 1/1/1970.
1 - all dates in grid are floating numbers as count of days since 1/1/1900. Cannot be used with Gantt chart
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.
Setting to 1 sets also all dates to GMT by <Format GMT='1'/>.
Due internal implementation the setting is shared among all grids on page!