I am using spread 7 for win forms and I’m trying to get a custom filter to work with the enhanced row filtering. I am filtering for an image column and have two custom filters for if the row has an image or if it doesn’t. I can get my filters to work correctly with the regular style filters with the following code:
Dim rowFilter As New FarPoint.Win.Spread.HideRowFilter(PictureFormSpread.ActiveSheet) PictureFormSpread.ActiveSheet.RowFilter = rowFilter PictureFormSpread.ActiveSheet.Columns(0, 3).AllowAutoFilter = True Dim fd As New FarPoint.Win.Spread.FilterColumnDefinition(3, FarPoint.Win.Spread.FilterListBehavior.Custom) fd.Filters.Add(New HasImageFilter(PictureFormSpread.ActiveSheet)) fd.Filters.Add(New NoImageFilter(PictureFormSpread.ActiveSheet)) rowFilter.AddColumn(fd)
However, if after that code I add this line to use the enhanced row filtering:
PictureFormSpread.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu
Then my custom filter no longer shows up on the drop down list for column 3 (I just see ‘select all’ and ‘blanks’) and the ShowInDropDown method is not getting called.