The Text Settings page is used to set up a text line of a Data Sheet.
Fields
Name
Specifies a name for the field.
If no name is specified, the formula is written in the first column.
If neither a name nor a formula is specified, a blank line is created.
Formula ID
Specifies an ID that can be used to reference or access the field value in formulas.
A Formula ID must begin with [ followed by a unique ID and end with ]. The brackets are added automatically when the ID is entered.
Formula
Formulas can be composed of Excel Functions, fixed and dynamic references (Formula IDs), constants and operators.
However, it is also possible to simply specify a text, which is then written to the Excel cells when the evaluation is executed.
If a calculation is to be performed in a formula, it begins with an equal sign.
Click on the field to set up the formula.
For more information, see Edit Evaluations, Data Sheets, Formulas.
Font, Fields
Bold
Specifies whether the column should be bold.
Italic
Specifies whether the column should be italicized.
Fill Color
Specifies whether the background of the column should be colored and if so, with which color. If white (RGB 255,255,255 or HEX #FFFFFF) is selected, the background of the column will not be colored.
The selection can be canceled via the escape key.
Font Color
Specifies whether the text of the column should be colored and if so, with which color. If black (RGB 0,0,0 or HEX #000000) is selected, the text of the column will not be colored.
The selection can be canceled via the escape key.
Alignment, Fields
Horizontal Alignment
Specifies the horizontal alignment for the column.
Width (Characters)
Specifies the column width in Number of characters, based on the Calibri font in size 11.
If there are several text lines or parallel tree structures and thus several specifications for a column in the sheet, the largest value is used.
Wrap Text
Specifies whether extra-long text should be wrapped into multiple lines.
Formatting, Fields
Format Formula as
Specifies whether the formula or the result of the formula should be formatted in Excel as a number or as a date.
Decimal Places
Specifies the number of decimal places to display in Excel when the formula is formatted as a number.
Without 1000 Separator
Specifies whether a thousands separator should be used or not.
Text Settings
