Spread WPF 17
GrapeCity.Excel Namespace / IExcelReader Interface / SetDisplayElements Method
The zero based sheet index used to locate the IExcelWorksheet instance
A flag indicate whether the specified sheet should show formula
A flag indicate whether the specified sheet should show zero
A flag indicate whether the specified sheet should show gridline
A flag indicate whether the specified sheet should show row column header
A flag indicate whether the column of the specified sheet is right to left


In This Topic
    SetDisplayElements Method
    In This Topic
    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 sheet As Short, _
       ByVal showFormula As Boolean, _
       ByVal showZeros As Boolean, _
       ByVal showGridLine 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)
    void SetDisplayElements( 
       short sheet,
       bool showFormula,
       bool showZeros,
       bool showGridLine,
       bool showRowColumnHeader,
       bool 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