Spread Silverlight Documentation
Type Property (Top10Condition)
Example 


Gets or sets the top 10 condition type.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Type As Top10ConditionType
'Usage
 
Dim instance As Top10Condition
Dim value As Top10ConditionType
 
instance.Type = value
 
value = instance.Type
[System.ComponentModel.DefaultValue()]
public Top10ConditionType Type {get; set;}

Property Value

The top 10 condition type. The default value is Top.
Example
This example filters data.
for (var row = 0; row < 25; row++)
{
     GcSpreadSheet1.Sheets[0].SetValue(row, 0, row);
}
var rowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 25, 1));
GcSpreadSheet1.Sheets[0].RowFilter = rowFilter;
var top10Con = new GrapeCity.Windows.SpreadSheet.Data.Top10Condition();
top10Con.Type = GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top;
top10Con.ExpectedValue = 10;
var filter = GcSpreadSheet1.Sheets[0].RowFilter;
filter.AddFilterItem(0, top10Con);
filter.Filter(0);
For row As Integer = 0 To 25
    GcSpreadSheet1.Sheets(0).SetValue(row, 0, row)
Next

Dim rowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 25, 1))
GcSpreadSheet1.Sheets(0).RowFilter = rowFilter
Dim top10Con As New GrapeCity.Windows.SpreadSheet.Data.Top10Condition()
top10Con.Type = GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top
top10Con.ExpectedValue = 10
Dim filter = GcSpreadSheet1.Sheets(0).RowFilter()
filter.AddFilterItem(0, top10Con)
filter.Filter(0)
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

Top10Condition Class
Top10Condition Members

 

 


Copyright © GrapeCity, inc. All rights reserved.