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. |