Spread Silverlight Documentation
FrozenColumnCount Property (Worksheet)
Example 


Gets or sets the number of nonscrolling columns on the leading edge of this sheet.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property FrozenColumnCount As System.Integer
'Usage
 
Dim instance As Worksheet
Dim value As System.Integer
 
instance.FrozenColumnCount = value
 
value = instance.FrozenColumnCount
[System.ComponentModel.DefaultValue()]
public System.int FrozenColumnCount {get; set;}

Property Value

The number of nonscrolling columns on the leading edge of this sheet.
Exceptions
ExceptionDescription
System.ArgumentOutOfRangeException Specified value is out of range; must be greater than or equal to zero.
Example
This example sets the FrozenColumnCount property.
gcSpreadSheet1.Sheets[0].RowCount = 10;
gcSpreadSheet1.Sheets[0].ColumnCount = 8;
gcSpreadSheet1.Sheets[0].FrozenColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenRowCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingRowCount = 1;
gcSpreadSheet1.Invalidate();
GcSpreadSheet1.Sheets(0).RowCount = 10
GcSpreadSheet1.Sheets(0).ColumnCount = 8
GcSpreadSheet1.Sheets(0).FrozenColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenRowCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingRowCount = 1
GcSpreadSheet1.Invalidate()
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.