![]() |
Enterprise
RTView®
User Guide |
Column Format Properties In the Object Properties window, double-click on columnFormat in the Property Name field to bring up the Column Format Properties dialog. In the Column Format Properties dialog you can assign numerical and date formats to columns.
The Column Name list is populated based on the table's data attachment. If you have not yet attached the table to data, this list will be empty. Column Format - Enter or select a format from the drop down menu and press <Enter>. Specify numerical formats using the Java format specification, or with the following shorthand: $ for US dollar money values, $$ for US dollar money values with additional formatting, () for non-money values, formatted similar to money, or # for positive or negative whole values. Specify date formats using the Java date specification. Add Column - Enter the name of the column and click the Add Column button to insert a column into the table. Clear - Click the Clear button to remove all Column Formats listed. NOTE: Text columns containing
data where all the values represent numbers are treated as if they are
numeric columns, so number formats can be applied.
|
|
|