_ColumnTypesXLCld
Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. When the default behavior is less than optimal for your situation, the Column types parameter can be set specifically. This page describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry.
The following column types are not supported in the current release:
Numeric with data formatting (FF)
Float with comma as decimal point (FC)
Currency with comma as decimal points (CC)
These column types are expected to be featured in the upcoming release.
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. |
Total formatting - option to format the total row in a user defined way. See Format the Auto Total Row for Numeric Columns.
Numeric data formatting - option to format the data rows in a user defined way for numeric columns. See Formatting Options for Numeric Columns.
Date data formatting - option to format the data rows in a user defined way for date columns. See Formatting Options for Date Columns.