Text Settings
| 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. |
| 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. |
| 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. |
| 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. |
 | Finmatics Autonomous Accounting Interface for AI-driven document processing tool by Finmatics. More information  |
