Number columns
These options tell Repeat Signage that your data is a number, which allows you then to choose how a number is displayed.
Decimal places - This is the amount of digits displayed after the decimal point. For example, a number of 23 is displayed differently depending on the number of decimal places specified:
| 23 | 0 decimal places |
| 23.0 | 1 decimal place |
| 23.00 | 2 decimal places |
Leading zeros - This is the minimum number of digits you want to display as number as. For example, bank account numbers are often 8 digits long such as 97327734. A bank account number of 633000 (6 digits) would be displayed as 00633000 for consistency. So when you format a number like this you need to specify 8 leading zeros which will make sure the final number gets padded with extra zeros at the front of the number if required. Leading zeros are only added if needed. Another example with 23:
| 23 | 0 leading zeros |
| 23 | 1 leading zero |
| 23 | 2 leading zeros |
| 023 | 3 leading zeros |
| 0023 | 4 leading zeros |
Currency symbol - Either select an entry from the list such as $, £, €, or ￥, or type you own one. So selecting the dollar symbol with 1234.00, for example would be displayed as $1234.00. If you wanted to display 1234 like '1234USD' then use the suffix box on the Additional tab on this page instead and specify a suffix as 'USD'.
Thousands separator - Displays longer numbers such as 1234567, with separators to give 1,234,67 instead, which makes reading them easier.
Manually type a format code - This tick box is for advanced users so that you can enter a custom format code. See http://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.90).aspx. Please feel free to contact us if you need any help
Percent - If you select 'Percent' then numbers are converted to percentages. For example, 0.25 would be displayed as 25%. You have all the other number options available as well.
Conditional formatting of numbers
You can make numbers between certain values different colours. You have to use the Replacement tab to do this. See the Formatting replacement tab help page for more details.
Standard column options on this screen
In addition to the above options, then these standard options are available:
Column title - The text to display in the column header.
Visible - Whether the column is visible. You can set this to false to completely hide a column that is no longer needed. A better option if dealing with a lot of database records is to remove this from the field list in the SQL statement used to collect your database information.
Column header align - Choose if your column header is left, centre or right aligned.
Column data align - Choose the alignment of the cells in this column.
Column width - The column's width in pixels. If you have chosen 'Auto column width' on the data grid settings tab, then you cannot change this.
Display text as - The choices are TEXT or BASIC HTML. Text is just straight plain text. With the TEXT option the font, font size, colour, etc, are set on the data grid options tabs. The BASIC HTML option allows you to use formatted text so you can mix text formatting. For example: "This is a big dog" where the word "big" is italic and the word "dog" is in bold. See Repeat Signage Basic HTML for more info.