Visual Basic (Declaration) | |
---|---|
Public Function GetColumnVisible( _ ByVal column As Integer _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim column As Integer Dim value As Boolean value = instance.GetColumnVisible(column) |
Parameters
- column
- Column index
Return Value
true if the column is displayed; otherwise falseTo specify whether a column is displayed, use the SetColumnVisible method.
To specify whether a row is displayed, use the SetRowVisible method.
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.
C# | Copy Code |
---|---|
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))); |
Visual Basic | Copy Code |
---|---|
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)) |
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
Reference
SheetView ClassSheetView Members
SetColumnVisible Method
SetRowVisible Method