GrapeCity.Xaml.SpreadSheet.Data
Type Property (Top10Condition)
Example 


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

Property Value

The top 10 condition type. The default value is Top.
Example
This example filters values.
for (var row = 0; row < 25; row++)
{
     GcSpreadSheet1.Sheets[0].SetValue(row, 0, row);
}
var rowFilter = new GrapeCity.Xaml.SpreadSheet.Data.HideRowFilter(new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 25, 1));
GcSpreadSheet1.Sheets[0].RowFilter = rowFilter;
var top10Con = new GrapeCity.Xaml.SpreadSheet.Data.Top10Condition();
top10Con.Type = GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.HideRowFilter(New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 25, 1))
GcSpreadSheet1.Sheets(0).RowFilter = rowFilter
Dim top10Con As New GrapeCity.Xaml.SpreadSheet.Data.Top10Condition()
top10Con.Type = GrapeCity.Xaml.SpreadSheet.Data.Top10ConditionType.Top
top10Con.ExpectedValue = 10
Dim filter = GcSpreadSheet1.Sheets(0).RowFilter()
filter.AddFilterItem(0, top10Con)
filter.Filter(0)
See Also

Reference

Top10Condition Class
Top10Condition Members