Is it possible to define automatic column filters? #478

Closed
opened 2016-10-13 18:05:00 +00:00 by goldbergyoni · 4 comments
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
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" }; ```
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#478
No description provided.