TExportWindowSettings

Description

TExportWindowSettings defines window settings of the worksheet.

Properties

NameTypeDescription
SplitTExportWindowSplitWindow split settings (also known as fixed cell).
AutofilterTExportRangeDefine autofilter on the table.
ScaleIntegerZoom factor of the worksheet (100 = no zoom).
ODS supports this feature only for the whole document -> value from the first worksheet is used.
ShowHeadersBooleanShow row and column headers on the screen.
ODS supports this feature only for the whole document -> value from the first worksheet is used.
ShowGridLinesBooleanShow grid lines on the screen.
ODS supports this feature only for the whole document -> value from the first worksheet is used.
ShowGroupButtonsTopRowBoolean True = the buttons for grouped rows are placed above the group.
False = the buttons for grouped rows are placed below the group.
(XLS/XLSX only. ODS does not support this feature but places the buttons inside the selection).
ShowGroupButtonsLeftColBoolean True = the buttons for grouped columns are placed on the left side from the group.
False = the buttons for grouped columns are placed on the right side the group.
(XLS/XLSX only. ODS does not support this feature but places the buttons inside the selection).
Code snippet: Custom table header in big tables.