Excel Filter Event

Add-in Express™ Support Service
That's what is more important than anything else

Excel Filter Event
 
tttmack




Posts: 12
 Joined: 2015-02-17
Hi Andrei,

I have been trying to figure out how I can get notified of the event when someone auto-filters data on my worksheet.

I have successfully caught similar events like Row/Column Hide/Unhide by adding a ADXRibbonCommand and then setting the idMso for example to 'RowsHide' and then processing in the OnAction event.

I have tried to do similarly with filters, yet the filter event never seems to get triggered. I have tried with various idMsos for filters as listed here: http://blogs.msdn.com/b/vsto/archive/2010/05/03/handling-sort-and-filter-events-in-excel-navneet-gupta.aspx

I also tried to see if I could catch it in ADXExcelWorksheetEvents' ProcessChange() and ProcessCalculate() events, but those didn't get triggered either (my worksheet has all its cells formatted as text and contains no formulas)

Is there a way to catch such an event using this method or another method (perhaps using a different idMso)?

Thanks for your help,
Taylour
Posted 17 Jun, 2015 17:52:57 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello Taylour,

You need to use IDMso's from the list that Microsoft provides for every Office version. Please find the links for downloading the lists in section Referring to built-in Office ribbon controls at https://www.add-in-express.com/docs/net-ribbon-components.php. For instance, if you filter the Control Name column for the word filter, you'll find the IdMso="AutoFilterClassic". I'm not sure if this is what you are looking for; you'll need to test it as well as other IdMso's from the list.


Andrei Smolin
Add-in Express Team Leader
Posted 18 Jun, 2015 02:42:41 Top