FrozenColumnCount Property

Gets or sets the number of frozen (non-scrollable) columns for this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property FrozenColumnCount As Integer

'Usage
 
Dim instance As SheetView
Dim value As Integer
 
instance.FrozenColumnCount = value
 
value = instance.FrozenColumnCount

public int FrozenColumnCount {get; set;}

Property Value

Integer number of columns to freeze

Remarks

This property (as well as any of the scroll bar related properties) does not have an effect on the Mozilla Firefox browser. Firefox does not support the CSS properties to handle this customization of the scrolling (or in this case non-scrolling).

Example

This example freezes columns and rows.

FpSpread1.Sheets[0].FrozenColumnCount = 1;
FpSpread1.Sheets[0].FrozenRowCount = 1;

Visual Basic

FpSpread1.Sheets(0).FrozenColumnCount = 1 
FpSpread1.Sheets(0).FrozenRowCount = 1

Requirements

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 Class
SheetView Members

User-Task Documentation

Freezing Rows and Columns
Understanding Browser Support