GrapeCity.Windows.SpreadSheet.Data Namespace > Top10Condition Class : Type Property |
'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;}
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)
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