Join
Sign in
Search Options
Search Everything
Search Formats
Home
Blog
Resources
Forums
About Open XML
More ...
Home
»
Forums
»
Formats
»
SpreadsheetML
»
Clear Filters from spreadsheet
Re: Clear Filters from spreadsheet
Formats
Discussions about working with different Open XML Formats
Get this RSS feed
Details
4
Replies
1
Subscriber
Posted
over 2 years ago
Options
Subscribe via RSS
Share this
SpreadsheetML
Clear Filters from spreadsheet
rated by 0 users
This post has
4 Replies |
1
Follower
Bibek
75
Posted by
Bibek
on
Fri, Jun 4 2010 11:53 AM
rated by 0 users
Post Points: 50
Clear Filters from spreadsheet
Hi Friends,
Can we clear the filters from xls document?
I tried deleting the autoFilter node and setting FilterMode to false in the particular sheet.xml file but its not helping me.
Thanks in advance.
Bibek Dawadi
Intergen
2610
Posted by
Intergen
on
Tue, Jul 13 2010 11:16 PM
rated by 0 users
Post Points: 5
Re: Clear Filters from spreadsheet
Hi Bibek
Removing the autoFilter elements from a SpreadsheetML's worksheet will only remove the detail about the filter - this does not change the visibility of the cells that may have been hidden by Excel as a result of the filter used.
Intergen
2610
Posted by
Intergen
on
Mon, Jul 19 2010 11:11 PM
rated by 0 users
Post Points: 20
Re: Clear Filters from spreadsheet
To add to my comment - the easiest way to understand the changes necessary is to take the document with filters and save it as a different file
without
any filters. Then use the Open XML SDK 2.0 Productivity Tool to
Compare
the files - you will then see each component that needs to change (i.e. The AutoFilter, SheetProperty's FilterMode, and hidden attribute against cells).
Bibek
75
Posted by
Bibek
on
Mon, Aug 2 2010 3:52 PM
rated by 0 users
Post Points: 5
Re: Clear Filters from spreadsheet
hi Intergen,
Thanks for letting me know about Productivity Tool. Its really very cool.
Regards,
Bibek Dawadi
Honeysery
5
Posted by
Honeysery
on
Mon, Sep 27 2010 10:51 PM
rated by 0 users
Post Points: 5
Re: Clear Filters from spreadsheet
I think this is great~
Page 1 of 1 (5 items)