Spread Windows Forms 7.0 Product Documentation
AutoSortFrozenRows Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : AutoSortFrozenRows Property


Glossary Item Box

Gets or sets a value that indicates whether frozen rows are sorted.

Syntax

Visual Basic (Declaration) 
Public Property AutoSortFrozenRows As Boolean
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As Boolean
 
instance.AutoSortFrozenRows = value
 
value = instance.AutoSortFrozenRows
C# 
public bool AutoSortFrozenRows {get; set;}

Example

This example sets the AutoSortFrozenRows property.
C#Copy Code
FpSpread1.Sheets[0].AutoSortFrozenRows = true;
FpSpread1.Sheets[0].AutoSortFrozenTrailingRows = true;
FpSpread1.Sheets[0].SetColumnAllowAutoSort(0,true);
FpSpread1.Sheets[0].FrozenTrailingRowCount = 1;
FpSpread1.Sheets[0].FrozenRowCount = 1;
FpSpread1.Sheets[0].Rows.Count = 5;
Visual BasicCopy Code
FpSpread1.Sheets(0).AutoSortFrozenTrailingRows = True
FpSpread1.Sheets(0).AutoSortFrozenRows = True
FpSpread1.Sheets(0).SetColumnAllowAutoSort(0, True)
FpSpread1.Sheets(0).FrozenTrailingRowCount = 1
FpSpread1.Sheets(0).FrozenRowCount = 1
FpSpread1.Sheets(0).Rows.Count = 5

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.