FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > ClearRowFilter Method : ClearRowFilter() Method |
'Declaration Public Overloads Sub ClearRowFilter()
'Usage Dim instance As SheetView instance.ClearRowFilter()
public void ClearRowFilter()
FarPoint.Win.Spread.FilterColumnDefinition fcd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default); FarPoint.Win.Spread.NamedStyle instyle = new FarPoint.Win.Spread.NamedStyle(); FarPoint.Win.Spread.NamedStyle outstyle = new FarPoint.Win.Spread.NamedStyle(); instyle.BackColor = Color.Yellow; outstyle.BackColor = Color.Gray; FarPoint.Win.Spread.StyleRowFilter rf = new FarPoint.Win.Spread.StyleRowFilter(fpSpread1.ActiveSheet, instyle, outstyle); rf.AddColumn(fcd); fpSpread1.ActiveSheet.RowFilter = rf; if (rf != null) { DialogResult dlg; dlg = MessageBox.Show("Reset the filter??"); if (dlg == DialogResult.OK) { fpSpread1.ActiveSheet.ClearRowFilter(); } }
Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default) Dim instyle As New FarPoint.Win.Spread.NamedStyle Dim outstyle As New FarPoint.Win.Spread.NamedStyle instyle.BackColor = Color.Yellow outstyle.BackColor = Color.Gray Dim rf As New FarPoint.Win.Spread.StyleRowFilter(FpSpread1.ActiveSheet, instyle, outstyle) rf.AddColumn(fcd) FpSpread1.ActiveSheet.RowFilter = rf If Not rf Is Nothing Then Dim dlg As DialogResult dlg = MessageBox.Show("Reset the filter??") If dlg = DialogResult.OK Then FpSpread1.ActiveSheet.ClearRowFilter() End If End If
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8