Format
Click here to see this page in full context

Format

The settings in this page apply only to the detail cells of the table.

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.

Column Width

This option will be displayed for string (text) and numeric data type. It is useful to define a column width (that is the number of characters) applicable to the cell.

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

Select the check box to add information on the time zone to all date fields.

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.

×