Retrieve the Sort and Filter that the User selected

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

Retrieve the Sort and Filter that the User selected
 
Henry Man




Posts: 4
Joined: 2015-01-26
Hi I am wondering if there is a way using c# to retrieve what the user has selected within the filter drop down and also the sort that the user have already applied to the Excel Sheet.

Thanks,
Henry
Posted 26 Mar, 2015 11:07:08 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hello Henry,

You need to get Worksheet.AutoFilter (or ListObject.AutoFilter) and retrieve AutoFilter.Sort and AutoFilter.Filters.


Andrei Smolin
Add-in Express Team Leader
Posted 27 Mar, 2015 09:51:52 Top
Henry Man




Posts: 4
Joined: 2015-01-26
Hi Andrei, do you have a code sample where you can retrieve the values that the user selected within AutoFilter and also the sort or sort order that user has applied to a excel range?
Posted 27 Mar, 2015 13:32:48 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hello Henry,

No, we don't have such an example. Please check http://stackoverflow.com/questions/7764655/get-autofilter-sort-criteria-and-apply-on-second-sheet. Does it help?


Andrei Smolin
Add-in Express Team Leader
Posted 30 Mar, 2015 02:45:54 Top