TdxSpreadSheetOptionsView Class
Stores the global apperance and functionality settings of the Spreadsheet and Report Designer controls.
Declaration
TdxSpreadSheetOptionsView = class(
TdxSpreadSheetPersistentObject
)Remarks
This class provides the following members that allow you to:
Identify what date/time format setting is currently used by the Spreadsheet control (ActualDateTimeSystem);
Set the date/ time format setting required for formula calculations (DateTimeSystem);
Disable or enable the antialiasing effect applied to the container objects (Antialiasing);
Customize the default cell height value (CellAutoHeight);
Hide or display boundaries separating individual cells within worksheets (GridLines);
Change the default color applied to boundaries separating individual cells within worksheets (GridLineColor);
Visualize custom worksheet print areas (PrintAreas and PrintAreaColor);
Hide or display the standard column and row headers in all worksheets (Headers);
Switch between available cell reference styles applied to all worksheets (R1C1Reference);
Determine the color and width of frozen pane separators (FrozenPaneSeparatorColor and FrozenPaneSeparatorWidth);
Display a formula expression instead of its calculated result (ShowFormulas);
Specify whether the empty cell references display zeros within their cells (ZeroValues);
Hide or display the horizontal and/or vertical scrollbars for all worksheets (HorizontalScrollBar and VerticalScrollBar properties).
The Spreadsheet/Report Designer control’s OptionsView property references a TdxSpreadSheetOptionsView object.