Contains descriptions for all property pages that setup rendering of numeric and alphanumeric values.

Integer

On this page you can define how integer values get rendered on a worksheet.

Control Elements:
  • 1
    Choose the section of the current component and / or the target data type for the format settings.
  • 2

    Edit the number of decimal places (disabled for integer data type)
  • 3

    Check if a separator should be used every 3 digits
  • 4

    Check to change into scientific format if space gets to small
  • 5

    Check to show the transfer function formula with the value
  • 6

    Check to show simple numbers
  • 7

    Check to use scientific (e.g. 1.0E+10) format
  • 8

    Check to use percentage format (e.g. 10% for value 0.1)
  • 9

    Check to treat negative numbers like positive numbers
  • 10

    Check to apply red color to negative numbers
  • 11

    Check to use red color without minus for negative numbers
  • 12

    Check to show "0" even if cells do not contain any value

Real

This page lets you define how floating point numbers get rendered on the worksheet.

Control Elements:
  • 1
    Choose the section of the current component and / or the target data type for the format settings.
  • 2

    Edit the number of decimal places (disabled for integer data type)
  • 3

    Check if a separator should be used every 3 digits
  • 4

    Check to change into scientific format if space gets to small
  • 5

    Check to show the transfer function formula with the value
  • 6

    Check to show simple numbers
  • 7

    Check to use scientific (e.g. 1.0E+10) format
  • 8

    Check to use percentage format (e.g. 10% for value 0.1)
  • 9

    Check to treat negative numbers like positive numbers
  • 10

    Check to apply red color to negative numbers
  • 11

    Check to use red color without minus for negative numbers
  • 12

    Check to show 0 even if cells do not contain any value

Currency

On this page you can define how currency values get rendered on the worksheet.

Control Elements:
  • 1
    Choose the section of the current component and / or the target data type for the format settings.
  • 2

    Edit the number of decimal places (disabled for integer data type)
  • 3

    Check if a separator should be used every 3 digits
  • 4

    Check to change into scientific format if space gets to small
  • 5

    Check to show the transfer function formula with the value
  • 6

    Choose or edit a currency symbol.
  • 7

    Show currency symbol before value.
  • 8

    Show currency symbol after value.
  • 9

    Check to treat negative numbers like positive numbers
  • 10

    Check to apply red color to negative numbers
  • 11

    Check to use red color without minus for negative numbers
  • 12

    Check to show "0" even if cells do not contain any value

Boolean

This page provides the format settings for boolean types.

Control Elements:
  • 1
    Select the data type for formatting
  • 2

    Choose this option to specify text for true and false values.
  • 3

    Enter or choose a text to be displayed for true boolean values
  • 4

    Enter or choose a text to be displayed for false boolean values
  • 5

    Choose this option if you want to show a checkbox symbol
  • 6

    Turn on to show empty checkboxes for false boolean values
  • 7

    Turn on to show text or an empty checkbox for empty cells

Date, Time, Date with Time

This page provides controls to define how dates and times are rendered by the worksheet.

Control Elements:
  • 1
    Choose the section of the current component and / or the target data type for the format settings.
  • 2

    Edit text and placeholders
    Use the placeholder buttons to insert placeholders for dates and times. Valid Placeholders are:
    %a Abbreviated weekday name
    %A Full weekday name
    %b Abbreviated month name
    %B Full month name
    %c Date and time representation appropriate for locale
    %d Day of month as decimal number (01 – 31)
    %H Hour in 24-hour format (00 – 23)
    %I Hour in 12-hour format (01 – 12)
    %j Day of year as decimal number (001 – 366)
    %m Month as decimal number (01 – 12)
    %M Minute as decimal number (00 – 59)
    %p Current locale's A.M./P.M. indicator for 12-hour clock
    %S Second as decimal number (00 – 59)
    %U Week of year as decimal number, with Sunday as first day of week (00 – 53)
    %w Weekday as decimal number (0 – 6; Sunday is 0)
    %W Week of year as decimal number, with Monday as first day of week (00 – 53)
    %x Date representation for current locale
    %X Time representation for current locale
    %y Year without century, as decimal number (00 – 99)
    %Y Year with century, as decimal number
    %z, %Z Either the time-zone name or time zone abbreviation, depending on registry settings; no characters if time zone is unknown
    %% Percent sign
  • 3

    Click to insert one of the placeholders for dates (day, month, ...)
  • 4

    Click to insert a placeholder for times (hours, seconds, ...)
  • 5

    Shows the current time using the format settings from above
  • 6

    Check to show "0" even if cells do not contain any value

Text

This Page lets you define additional data fields to display in each cell. Use the Format edit line to specify a mask of text and placeholders.

Syntax:

{{name}} renders the attribute "name" use attribute name "value" to render the implicit value of the cell

[.......] renders the text inside the brackets only if at least one placeholder inside can be resolved, e.g. [Comment={{comment}}] will only be effective, if the cell to display actually has a comment.

Control Elements:
  • 1
    Choose the section of the current component and / or the target data type for the format settings.
  • 2

    Edit a text with placeholders
  • 3

    Select an attribute to insert as placeholder
  • 4

    Click to add the selected attribute into the format text

Feedback

Did you find what you needed?

If you have any further questions or suggestions to improve this page, please let us know:

=