Value Format

Format

Cell height can increase/decrease to accommodate contents	If you select this option, the height of the cells is adjusted automatically so that long texts can be shown with line breaks. This option is especially useful if the text field contains an expression.
Horizontal Alignment	Horizontal alignment of the text inside the cells.
Vertical Alignment	Vertical alignment of the text inside the cells.
Padding	Margin between the text and the border of the cells.

The Format options depend on the data type. The type is preselected corresponding to the used value.

For example, you can set the decimal places for numbers, or the format of a date.

Detail Row	If a table has two detail rows with numbers, you can choose the row for which you want to set the format.
Rounding	Define the precision of a number, currency, or percentage. Decimal Places The number is shown with the given amount of decimal places. Significant Digits The number is masked with zeros, only the specified number of significant digits is shown. For example, if you set the significant digits to 2, the numbers are shown as follows: 1234 as 1200 1 as 1.00 0.1234 as 0.12 0.1 as 0.10 0.01234 as 0.012
Show GMT Offset	This check box is enabled if the value is of type date or time. Select the check box to include information on the time zone. Times are always shown as local times. The time offset includes the daylight saving time. For example, an injection acquisition date would look as follows: Injection acquired in June (summer time): in London as 06/30/2015 10:30:00 AM (GMT + 1:00) in Berlin as 06/30/2015 11:30:00 AM (GMT + 2:00) Injection acquired in January (winter time): in London as 01/31/2015 09:30:00 AM (GMT + 0:00) in Berlin as 01/31/2015 10:30:00 AM (GMT + 1:00)
Preview	The Preview area shows the appearance of the currently selected settings.

Column Width options are only shown if the value is a string (text).

Column Width (no. of characters)

Defines the width of the column.