Posted 8 September 2017, 3:11 pm ESTI 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)
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.