Spread for ASP.NET 9.0 Product Documentation
GetColumnVisible Method
Example 


Column index
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))
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetView Class
SheetView Members
SetColumnVisible Method
SetRowVisible Method

User-Task Documentation

Showing or Hiding Rows or Columns

 

 


Copyright © GrapeCity, inc. All rights reserved.