GetColumnVisible Method

In This Topic

Gets whether a column is displayed.

Syntax

Visual Basic
C#

'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.

C#
Visual Basic

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))

Reference

SheetView Class
SheetView Members
SetColumnVisible Method
SetRowVisible Method

User-Task Documentation

Showing or Hiding Rows or Columns