The interface to the RowFilter as documented in the Help File (FarPoint.Win.Spread.4.0.chm) is not the same as in the Object Library. As a result, the examples given in the Help File are broken. Also there is a typo on the rf in the example I quoted below. Is there an updated version of the Help File I can download?
Dim fcdc As New FarPoint.Win.Spread.FilterColumnDefinitionCollection
Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default)
fcdc.Add(fcd)
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, fcdc, instyle, outstyle)
FpSpread1.ActiveSheet.RowFilter = sf
If Not rf Is Nothing Then
Dim dlg As DialogResult
dlg = MessageBox.Show("Set the filter??")
If dlg = DialogResult.OK Then
TextBox1.Text = FpSpread1.ActiveSheet.RowFilter().ToString
End If
End If
Joe