OWC11 Autofilter behavior

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top