Format
Click here to see this page in full context

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.

Format

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.

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.

For example: 22/12/2016 12:24:33 PM (GMT + 6:30)

Preview

The Preview area shows the appearance of the currently selected settings.

Column Width

For row groups, you can define the width of the static columns shown in the left part of the matrix. You can enter any number of characters.

×