TdxSpreadSheetOptionsView Properties

Stores the global apperance and functionality settings of the Spreadsheet and Report Designer controls.

Name	Description
ActualDateTimeSystem	Returns the date/time format currently used by the Spreadsheet control.
Antialiasing	Specifies if anitialiasing is applied to floating containers.
CellAutoHeight	Specifies if the cell object‘s height is automatically adjusted to display its entire content.
CommentMarkColor	Specifies the color used to display the comment mark in the upper-right corner of a cell.
DateTimeSystem	Specifies what date/time format is used in calculations of the Date and Time functions.
FrozenPaneSeparatorColor	Specifies the color of both the horizontal and vertical frozen pane separators.
FrozenPaneSeparatorWidth	Specifies the width (in pixels) of both the horizontal and vertical frozen pane separators.
GridLineColor	Specifies a color of gridlines displayed in all Table View worksheets.
GridLines	Specifies if the Spreadsheet or Report Designer control displays gridlines in all worksheets.
Headers	Specifies if the Spreadsheet or Report Designer control displays the default column and row headers in all worksheets.
HorizontalScrollBar	Specifies if the Spreadsheet or Report Designer control displays the horizontal scrollbar.
PrintAreaColor	Specifies the color of the custom print area’s border.
PrintAreas	Specifies if the control outlines the active worksheet‘s custom print area.
R1C1Reference	Specifies if the control uses the “R1C1” cell reference style in all worksheets.
ShowFormulas	Specifies if the Spreadsheet or Report Designer control displays formula expressions instead of their result values.
SpreadSheet	Provides access to the Spreadsheet or Report Designer control to which the persistent object belongs. Inherited from TdxSpreadSheetPersistentObject.
VerticalScrollBar	Specifies if the Spreadsheet or Report Designer control displays the vertical scrollbar.
ZeroValues	Specifies if zero values can be displayed by the cells objects with defined names, references or formula expressions.