Versions Compared

Old Version 9

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)

Saved on

compared with

New Version 10

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Navigate to Column settings > Formatting > Column type in the respective macro to select from the list of available column types.

Table plus


TypeDescriptionSorting

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(tick)
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(tick)
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(tick)
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(tick)
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(tick)
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(tick)
Date (M)

Date format in many popular formats. See Advanced Date Sorting for more information. This is the preferred date sorting type.

Date
(tick)
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.


...