R
RLarabeeJr
I'm using a Spreadsheet object to display large lists of information. When a
user uses Autofilter to filter one column they expect that the choices for
autofiltering other columns will be reduced to what is in the rows that have
not been filtered out. This is what they see in Excel. The OWC object doesn't
reduce the choices in the dropdown filter lists but instead shows all choices
as if none of the columns were filtered. Is this how the control was
designed? If so, is there any way to emulate Excel's Autofilter behavior?
user uses Autofilter to filter one column they expect that the choices for
autofiltering other columns will be reduced to what is in the rows that have
not been filtered out. This is what they see in Excel. The OWC object doesn't
reduce the choices in the dropdown filter lists but instead shows all choices
as if none of the columns were filtered. Is this how the control was
designed? If so, is there any way to emulate Excel's Autofilter behavior?