Spire.XLS 8.8.0 supports to clear a particular filter that is not in a pivot table

We're pleased to announce that Spire.XLS hotfix version 8.8.0 is released today. This version adds a new feature to support to clear a particular filter that is not in a pivot table, and also fixes some issues occurring when converting, loading and manipulating Excel files. View the details below.

New features:

• Adds a new method ClearFilter to clear a filter which is not in a pivot table.

AutoFiltersCollection filter = workbook.Worksheets["Sheet2"].AutoFilters;
filter.ClearFilter(int);//filter.ClearFilter(columnName);
//refresh data 
filter.Filter();Sample code:

Bug Fixes:

• Fixes the issue that the option "Autofit column widths on update" for pivot table changed to be checked after saving.
• Fixes the issue that the text color couldn’t be set for an existing file.
• Fixes the issue that the chart type "Line" changed to "Line Marker" when creating a chart in .xls file.
• Fixes the issue that caused an ArgumentOutOfRangeException when loading a file.
• Fixes the issue that text and lines got overlapped when converting Excel to XPS.
• Fixes the issue that caused a NullReferenceException when saving Excel to PDF.
• Fixes the issue that the format was wrong when converting Excel to PDF.
• Fixes the issue that caused an ArgumentOutOfRangeException when loading a file.