Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetColumnVisible Method
Column index
Example


In This Topic
    GetColumnVisible Method
    In This Topic
    Gets whether a column is displayed.
    Syntax
    'Declaration
     
    Public Function GetColumnVisible( _
       ByVal column As Integer _
    ) As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim column As Integer
    Dim value As Boolean
     
    value = instance.GetColumnVisible(column)
    public bool GetColumnVisible( 
       int column
    )

    Parameters

    column
    Column index

    Return Value

    true if the column is displayed; otherwise false
    Remarks

    To specify whether a column is displayed, use the SetColumnVisible method.

    To specify whether a row is displayed, use the SetRowVisible method.

    Example
    This example creates a SheetView object and a Column object. Values are inserted into the second column and the column is then hidden. Whether the column is visible is returned to a list box using the SheetView object.
    FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
    FarPoint.Web.Spread.Column mycol;
    mycol=sv.Columns[1];
    sv.SetValue(0,1,"Alignment");
    sv.SetValue(1,1,"CarbAdjust");
    sv.SetValue(2,1,"Brakes");
    sv.SetColumnVisible(1,false);
    ListBox1.Items.Add(Convert.ToString(sv.GetColumnVisible(1)));
    Dim sv As FarPoint.Web.Spread.SheetView
    sv=FpSpread1.ActiveSheetView
    Dim mycol As FarPoint.Web.Spread.Column
    mycol=sv.Columns(1)
    sv.SetValue(0,1,"Alignment")
    sv.SetValue(1,1,"CarbAdjust")
    sv.SetValue(2,1,"Brakes")
    sv.SetColumnVisible(1,False)
    ListBox1.Items.Add(sv.GetColumnVisible(1))
    See Also