Re: 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

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.

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).

hi Intergen,

Thanks for letting me know about Productivity Tool. Its really very cool.

Regards,

Bibek Dawadi

I think this is great~