| Type | Description | Sorting | Total Formatting | Data Formatting |
|---|
| String (S) | Text string. This is a series of one or more alphanumeric characters, possibly including a letter, number, space, punctuation mark or other special characters. | Alphabetic |
|
|
| Integer (I) | Integer. This is a numeric field without a fractional component. | Numeric |  |
|
| Numeric or float values (F) | Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. | Numeric | |
|
| Currency (C) | Similar to F with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored. | Numeric | |
|
| Date (M) | Date format in many popular formats. See Advanced date sorting for more information. This is the preferred date sorting type. | Date |
| |
| Date in the browser date format (D) | Date in the browser date format. See Advanced date sorting for more information. The D type is available for compatibility with older releases - the M type is recommended. | Date |
|
|
| Complex HTML elements like emotions or similar (E) | Emoticons or other HTML elements. | Alphabetic on the inner HTML value |
|
|
| Exclude this column from user selectable sorting (X) | Indicates to exclude this column from user selectable sorting. | Disabled |
|
|
| . | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '.'. | Numeric on each separated value |
|
|
| : | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by ':'. | Numeric on each separated value |
|
|
| - | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '-'. | Numeric on each separated value |
|
|
| / | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '/'. | Numeric on each separated value |
|
|
| Hide the column (H) | Indicates to hide the column. |
|
|
|