Table of Contents

TSheetOptions Enumeration

General options for a sheet. In Excel, this settings are located in Tools->Options->View in the "Window options" box. Most of this options can be set with dedicated methods in TExcelFile, but this type allows to set them all at once, or copy them from other file. This options apply only to the active sheet. For options that apply to all the sheets see TSheetWindowOptions

Syntax

Unit: FlexCel.Core

Members

Name Value Description
None 0 No option is selected.
ShowFormulaText 1 If 1, Excel will show formula text instead of formula results. This is the same as calling TExcelFile.ShowFormulaText
ShowGridLines 2 If 0 Excel will hide the gridlines, if 1 it will show them. This is the same as calling TExcelFile.ShowGridLines
ShowRowAndColumnHeaders 4 if 0 Excel will hide the "A", "B"... column headers and "1", "2" ... row Headers. This is the same as calling TExcelFile.ShowGridHeadings
ZeroValues 16 If 1 Excel will show formulas with result in 0 as 0. If not, Excel will show formulas that result in 0 as empty. This is the same as calling TExcelFile.HideZeroValues
AutomaticGridLineColors 32 If 1, the color of gridlines will be gray. If 0 it will be the color specified at TExcelFile.GridLinesColor.
Note that calling TExcelFile.GridLinesColor will automatically set this property to 0.
RightToLeft 64 If 1, the sheet is Right to left. This is the same as calling TExcelFile.SheetIsRightToLeft
OutlineSymbols 128 If 1, Excel will show the outline symbols (+/-) when there are grouped rows or columns.
PageBreakView 2048 If 1 Excel will show the page breaks.