GrapeCity.Xaml.SpreadSheet.Data
FrozenColumnCount Property (Worksheet)
Example 


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

Property Value

The number of nonscrolling columns on the leading edge of this sheet.
Exceptions
ExceptionDescription
Specified value is out of range; must be greater than or equal to zero.
Example
This example uses 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.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
See Also

Reference

Worksheet Class
Worksheet Members