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 ExcelFile, 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
Namespace: 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 ExcelFile.ShowFormulaText |
| ShowGridLines | 2 | If 0 Excel will hide the gridlines, if 1 it will show them. This is the same as calling ExcelFile.ShowGridLines |
| ShowRowAndColumnHeaders | 4 | if 0 Excel will hide the "A", "B"... column headers and "1", "2" ... row Headers. This is the same as calling ExcelFile.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 ExcelFile.HideZeroValues |
| AutomaticGridLineColors | 32 | If 1, the color of gridlines will be gray. If 0 it will be the color specified at ExcelFile.GridLinesColor. Note that calling ExcelFile.GridLinesColor will automatically set this property to 0. |
| RightToLeft | 64 | If 1, the sheet is Right to left. This is the same as calling ExcelFile.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. |