Via Text Sheets, sheets with text can be added to the Excel workbook.
Text sheets can also be used to specify shared parameters, which can then be used for calculations in different sheets of the workbook. In this case, the text sheets or their parameter values must be accessed from the other sheets via sheet references.
The Text Sheet page is used to set up the sheet.
Fields
Text
Specifies the text.
Offset Type
Specifies whether the text should start a new row or a new column.
Offset
Specifies a value to be added in addition to the row/column offset.
Bold
Specifies whether the text should be bold.
Italic
Specifies whether the text should be italicized.
Horizontal Alignment
Specifies the horizontal alignment for the text.
Width (Characters)
Specifies the column width in Number of characters, based on the Calibri font in size 11.
If there are several specifications for a column, the largest value is used.
Wrap Text
Specifies whether extra-long text should be wrapped into multiple lines.
Actions
Up / Down
The position or the order of the text lines can be changed with Up and Down.
The Sheet Settings page is used to set up the general settings of the Text Sheet.
Fields
Sheet Name
Specifies a name for the sheet.
If no name is specified, the type of the sheet is used.
It is additionally possible to specify the placeholder %1 in the text, which is replaced by the type of the sheet.
Print, Fields
Orientation
Specifies the default print format for the worksheet.
Fit width to pages
Specifies whether the size of the worksheet should be adjusted to fit on the specified number of pages.
Rows to repeat at top
Specifies a range to be printed on each page. For example, you can specify '$1:$1' for the first row of the worksheet.
Columns to repeat at left
Specifies a range to be printed on each page. For example, you can specify '$A:$B' for the first two columns of the worksheet.
Page Order
Specifies the sequence in which the worksheet data is numbered and printed if it does not fit on one page.
Text Sheet
