Excel Office Web Component Grid Auto Filter dialog box issue

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 1

Step 2 : If i click the "Marks" column filter dropdown, it displaying filter dialog box with filtered value which already displaying in the screen.

Step 2

February 17th, 2015 10:24am

Step 3 : Applied filter to display "RAM" record in Microsoft Office Web Component grid.

Step 4 : If i click the "Marks" column filter dropdown in Office web component grid, it displaying filter dialog box with all unique values which belongs to the Marks column. But Excel 2010 displaying filter dialog box with only filtered value which already displaying in the excel 2010 application. Refer the highlighted area in both screenshots.

I want to customize the Office web component grid 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.

Step 3


  • Edited by Balaramji 20 hours 25 minutes ago
Free Windows Admin Tool Kit Click here and download it now
February 17th, 2015 10:25am

Hi,

This is the forum to discuss questions and feedback for Microsoft Office, your issue is related to Office DEV, I recommend you post the question to the MSDN forum

https://social.msdn.microsoft.com/Forums/en-US/home?forum=officegeneral&filter=alltypes%2Calllanguages&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


George Zhao
TechNet Community Support

February 18th, 2015 1:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics