TExportWindowSettings

Description

TExportWindowSettings defines window settings of the worksheet.

Properties

NameTypeDescription
AutofilterTExportRangeDefine autofilter on the table.
SelectionTExportRangeActive selection.
TopLeftCellTExportCellAddressThe top-left cell in the current view (window scroll position).
SplitTExportWindowSplitWindow split settings (also known as fixed cell).
TabColorTColorDefine the color of the worksheet tab.
ViewTExportWorksheetViewThe sheet view style.
Possible values:
  • ewvNormal
  • ewvPageBreakPreview
  • ewvPageLayout
ODS does not support ewvPageLayout (in this case ewvPageBreakPreview is used instead).
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.
ShowFormulasBooleanShow formulas instead of their values.
ShowZerosBooleanTrue: show zero values. False: hide zero values.
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.
Categories