TdxSpreadSheetTableViewOptions Class

Stores general worksheet settings.

Declaration

TdxSpreadSheetTableViewOptions = class(
    TdxSpreadSheetCustomViewOptions
)

Remarks

Spreadsheet controls allow you to customize appearance and behavior settings at the control level and at the level of individual worksheets. Individual worksheet settings have higher priority than corresponding control settings.

Main API Members

The list below outlines key members of the TdxSpreadSheetTableViewOptions class. These members allow you to configure spreadsheet appearance and behavior at the level of individual worksheets.

Layout and Behavior Settings

DefaultColumnWidth | DefaultRowHeight: Specify initial cell dimensions in the worksheet.
RightToLeftLayout: Allows you to switch between left-to-right and right-to-left layouts at the level of an individual worksheet.
ZoomFactor: Allows you to zoom the worksheet in or out.

Visual Element Visibility

GridLines: Specifies if grid lines are visible.
Headers: Allows you to hide or display cell headers.
HorizontalScrollBar | VerticalScrollBar: Allows you to hide or display scroll bars.
ShowFormulas | ZeroValues: Allow you to display formula expressions and zero values.

General-Purpose API Members

Assign: Copies settings between worksheets.
BeginUpdate | EndUpdate | CancelUpdate: Allow you to avoid excessive redraw operations during batch worksheet setting changes.