| Docs Help
  AppSource  
  The topic is not available for the selected language ().
Docs  /  Excel Report Builder  /  Edit Evaluations  /  Data Sheets

 Sheet Settings


2024/10/24 • 3 min. to read
The Sheet Settings page is used to set up the general settings of the Data Sheet.

Fields

Sheet NameSpecifies a name for the sheet. If no name is specified, the type of the sheet or the Use as Sheet Name Setting is used. It is additionally possible to specify the placeholder %1 in the text, which is replaced by the type of the sheet or the Use as Sheet Name Setting.
Use as Sheet NameSpecifies a Data Sheet line to be used as the name for the sheet.
Add FiltersSpecifies whether the filters of the Data Sheet should be added to the worksheet.
Column HeadersSpecifies whether or not to add column headers in the worksheet. If there are several parallel tree structures and thus several specifications for a column in the sheet, the first tree structure or the first occurrence determines the header.
Column FiltersSpecifies whether to turn on filtering for the Column Headers.
Freeze Top RowsSpecifies whether, and if so, how many top rows should remain visible while scrolling through the rest of the worksheet.
Freeze First ColumnsSpecifies whether, and if so, how many first columns should remain visible while scrolling through the rest of the worksheet.
Excel TableSpecifies whether the data should be formatted as an Excel Table.
Table StyleSpecifies a style for the Excel Table. If the field is empty, the default setting from the Excel Evaluation Setup will be used.
Total RowSpecifies whether to turn on or off the total row of the Excel Table. The Total Row Type can be set for each field individually via the Field Settings of the Data Sheet line(s).
Banded RowsSpecifies whether to display banded rows, in which even columns are formatted differently from odd rows.
Banded ColumnsSpecifies whether to display banded columns, in which even columns are formatted differently from odd columns.
First ColumnSpecifies whether to display special formatting for the first column of the Excel Table.
Last ColumnSpecifies whether to display special formatting for the last column of the Excel Table.

Print, Fields

OrientationSpecifies the default print format for the worksheet.
Fit width to pagesSpecifies whether the size of the worksheet should be adjusted to fit on the specified number of pages.
Rows to repeat at topSpecifies 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 leftSpecifies a range to be printed on each page. For example, you can specify '$A:$B' for the first two columns of the worksheet.
Page OrderSpecifies the sequence in which the worksheet data is numbered and printed if it does not fit on one page.


Submit feedback for
DE|EN Imprint