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.

Column Width

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

Column Width (no. of characters)

Defines the width of the column.

Number Format

The Number Format options are only shown if the value is a number.

You can choose the way in which numbers are shown, for example, as a decimal number, date, or currency. Depending on the category selected in the drop-down list at left, you can choose between different styles in the drop-down list at right.

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.