[Advanced Excel] Set filtering option on in excel

Forge Component
(54)
Published on 27 Aug by Hanno
54 votes
Published on 27 Aug by Hanno

Hi,

I was wondering is it also possible to set the filtering option in excel per column automatic in OutSystems, so that the end-user directly have the possibility to filter columns?

I'll look into it. Nice feature!

Solution

Wendy, please try the Worksheet_AddAutoFilter action in the attached.

Note: you do have to pass a range for the data to filter. I am working on auto-detecting the range to filter as an option.

Solution

Hanno wrote:

Wendy, please try the Worksheet_AddAutoFilter action in the attached.

Note: you do have to pass a range for the data to filter. I am working on auto-detecting the range to filter as an option.

Hi Hanno,
How nice, that is very quick! I tried the new action and it is working perfect. Thank you, this feature is very valuable for our endusers!

Kind regards Wendy


Glad to help.