Type Property (Top10Condition)

Visual Basic
C#

'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.

This example filters data.

C#

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);

VB.NET

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)

Reference

Top10Condition Class
Top10Condition Members