Spread WPF Documentation
FrozenTrailingRowCount Property
Example 


Gets or sets the number of nonscrolling rows on the trailing edge of this sheet.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property FrozenTrailingRowCount As System.Integer
'Usage
 
Dim instance As Worksheet
Dim value As System.Integer
 
instance.FrozenTrailingRowCount = value
 
value = instance.FrozenTrailingRowCount
[System.ComponentModel.DefaultValue()]
public System.int FrozenTrailingRowCount {get; set;}
Exceptions
ExceptionDescription
System.ArgumentOutOfRangeException Specified value is out of range; must be greater than or equal to zero.
Example
This example sets the FrozenTrailingRowCount 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 (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.