Hi,
I am using Microsoft Office Web Component Grid (OCW11.DLL) in my vb6 application. This excel web component grid does not showing Auto filter dialog box with only filtered values instead of that it showing all unique values present in the selected filter column but in Excel 2010 application auto filter dialog box showing only the filtered values in the selected filter column.
I presume, it may be drawback or limitation of the excel web component grid. so i really appreciate if you provide any solution to display only filtered value in the auto filter dialogue box looks similiar to excel 2010 auto filter dialogue box using vba code or changing any property of the excel web component grid.
Please refer all the screenshots which i attached below to understand my question clearly.
Step 1 : Applied filter to display "RAM" record in Excel 2010.
Step 2 : If i click the "Marks" column filter dropdown, it displaying filter dialog box with filtered value which already displaying in the screen.