Set whether the specified sheet should show formula, show zeros, show gridline, show row column header, and whether its column is right to left.
Syntax
'Declaration
Sub SetDisplayElements( _
ByVal As Short, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal showRowColumnHeader As Boolean, _
ByVal rightToLeftColumns As Boolean _
)
'Usage
Dim instance As IExcelReader
Dim sheet As Short
Dim showFormula As Boolean
Dim showZeros As Boolean
Dim showGridLine As Boolean
Dim showRowColumnHeader As Boolean
Dim rightToLeftColumns As Boolean
instance.SetDisplayElements(sheet, showFormula, showZeros, showGridLine, showRowColumnHeader, rightToLeftColumns)
Parameters
- sheet
- The zero based sheet index used to locate the IExcelWorksheet instance
- showFormula
- A flag indicate whether the specified sheet should show formula
- showZeros
- A flag indicate whether the specified sheet should show zero
- showGridLine
- A flag indicate whether the specified sheet should show gridline
- showRowColumnHeader
- A flag indicate whether the specified sheet should show row column header
- rightToLeftColumns
- A flag indicate whether the column of the specified sheet is right to left
See Also