Is it possible to define automatic column filters? #478

New Issue

2016-10-13T18:05:00Z

goldbergyoni commented

2016-10-13 18:05:00 +00:00

(Migrated from github.com)

Hi,

Thanks for the great work.

Question: is it possible to define per-sheet an automatic filter for all/some columns? in other words, when the user will open the sheet, automatically Excel will display filters on the column headers

thanks,
Yoni Goldberg

Hi, Thanks for the great work. Question: is it possible to define per-sheet an automatic filter for all/some columns? in other words, when the user will open the sheet, automatically Excel will display filters on the column headers thanks, Yoni Goldberg

zuk38 commented

2016-10-14 07:23:45 +00:00

(Migrated from github.com)

+1

It is possible to use this method: https://msdn.microsoft.com/en-us/library/office/ff193884.aspx

+1 It is possible to use this method: https://msdn.microsoft.com/en-us/library/office/ff193884.aspx

zuk38 commented

2016-10-14 11:02:34 +00:00

(Migrated from github.com)

I found solution here: https://github.com/SheetJS/js-xlsx/issues/472

goldbergyoni commented

2016-10-18 13:05:46 +00:00

(Migrated from github.com)

@zuk38 thanks a bunch!

Should I edit the source code to allow "writextag" or is part of the API and I can just add the autofilter tag?

@zuk38 thanks a bunch! Should I edit the source code to allow "writextag" or is part of the API and I can just add the autofilter tag?

SheetJSDev commented

2017-04-10 05:20:16 +00:00

(Migrated from github.com)

We're pushing a change to add autofilter metadata in the worksheet !autofilter key. For now it just supports a reference, but later we will add more.

usage:

worksheet['!autofilter'] = { ref: "A1:C20" };

We're pushing a change to add autofilter metadata in the worksheet `!autofilter` key. For now it just supports a reference, but later we will add more. usage: ```js worksheet['!autofilter'] = { ref: "A1:C20" }; ```

👍 1

Sign in to join this conversation.