Sheet Settings
| 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. |
| Classic PivotTable Layout | Specifies whether the PivotTable should be created in Classic Layout by default. The Classic Layout enables dragging of fields in the grid. The default setting for the field can be set in the Excel Evaluation Setup. |
| Grand Totals | Specifies whether to display the grand totals next to the last column resp. at the bottom of the PivotTable.
The grand total for rows is displayed next to the last column:
The grand total for columns is displayed at the bottom of the PivotTable:
 |
| PivotTable Style | Specifies a style for the PivotTable. If the field is empty, the default setting from the Excel Evaluation Setup will be used. |
| Row Headers | Specifies whether to display special formatting for the first row of the PivotTable. |
| Column Headers | Specifies whether to display special formatting for the first column of the PivotTable. |
| Banded Rows | Specifies whether to display banded rows, in which even columns are formatted differently from odd rows. |
| Banded Columns | Specifies whether to display banded columns, in which even columns are formatted differently from odd columns. |
| Chart | Specifies whether a chart should be created for the PivotTable. The chart will be created in a separate sheet.
 |
| Chart Sheet Name | Specifies a name for the chart 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. |
| Chart Title | Specifies a title for the chart. A title will only be added to the chart if the field contains a value. |
| Chart Type | Specifies the chart type. |
| 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. |
 | Finmatics Autonomous Accounting Interface for AI-driven document processing tool by Finmatics. More information  |
