FrozenTrailingColumnCount Property

Gets or sets the number of non-scrolling columns on the trailing edge of this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property FrozenTrailingColumnCount As Integer

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

public int FrozenTrailingColumnCount {get; set;}

Property Value

Integer number of frozen columns

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified value is out of range; must be greater than or equal to zero

Remarks

This property freezes the last n columns between the last scrollable viewport and the scroll bars similar to how the frozen leading property (FrozenColumnCount) freezes the first m columns between the headers and the first scrollable viewport.

Example

This example sets frozen trailing rows and columns.

fpSpread1.Sheets[0].FrozenTrailingColumnCount = 1;
fpSpread1.Sheets[0].FrozenTrailingRowCount = 1;

Visual Basic

FpSpread1.Sheets(0).FrozenTrailingColumnCount = 1
FpSpread1.Sheets(0).FrozenTrailingRowCount = 1

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members

User-Task Documentation

Setting Fixed (Frozen) Rows or Columns