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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members

User-Task Documentation

Freezing Rows and Columns
Understanding Browser Support