| Docs Help
  AppSource  
Docs  /  Excel Report Builder  /  Edit Evaluations  /  Data Sheets

 Text Settings


2024/02/02 • 3 min. to read
The Text Settings page is used to set up a text line of a Data Sheet.

Fields

NameSpecifies 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 IDSpecifies 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.
FormulaFormulas 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

BoldSpecifies whether the column should be bold.
ItalicSpecifies whether the column should be italicized.
Fill ColorSpecifies 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 ColorSpecifies 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 AlignmentSpecifies 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 TextSpecifies whether extra-long text should be wrapped into multiple lines.

Formatting, Fields

Format Formula asSpecifies whether the formula or the result of the formula should be formatted in Excel as a number or as a date.
Decimal PlacesSpecifies the number of decimal places to display in Excel when the formula is formatted as a number.
Without 1000 SeparatorSpecifies whether a thousands separator should be used or not.

See also




Submit feedback for
DE|EN Imprint
<>