Page Comparison

Column types determine how column data is can be sorted and displayed. By default, column data is treated as a text string sorted alphabetically. Some Bob Swift Atlassian macros, like the SQL and CSV macros, , and thus, can be sorted automatically when a column heading is clicked. CSV macros may automatically generate more precise column types. When the default behavior is less than optimal for your situation, the Column types parameter can be set specifically.

This table describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry. 

Table plus

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 Numeric with data formatting (FF) Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. Forced formatting of data columns. Numeric Float with comma as decimal point (FC) Numeric or float value and may contain numeric separators including a comma for decimal separator and a period 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 Currency with comma as decimal points (CC) Similar to FC 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.