Spire.XLS 9.11.14 supports retaining filtered data when converting Excel to CSV

We're pleased to announce the release of Spire.XLS 9.11.14. This version supports retaining the filtered data when converting Excel to CSV and also fixes these issues that occurred when setting row height, converting Excel to PDF, calculating formula and loading excel file. See the content below for more details.

New Features:

• Supports retaining the filtered data when converting Excel to CSV.

workbook.SaveToFile(string fileName,FileFormat fileFormat , bool retainHiddenData);
worksheet.SaveToFile(string fileName, string separator , bool retainHiddenData);

Bug Fixes:

• Fixes the issue that setting the row height using the values that are stored in a dynamic list didn't take effect in Excel file.
• Fixes the issue that the formula "=COUNTIF(Q2:Q1839,\"New South Wales\") " could not be calculated successfully.
• Fixes the issue that the application threw the exception "An item with the same key has been added" when loading an Excel.
• Fixes the issue that getting the AlternativeTextTitle of picture returned null.
• Fixes the issue that incorrect chart format was caused after converting Excel to PDF.
• Fixes the issue that the application threw the exception "ArgumentOutOfRangeException" when getting the ChartSheet.
• Fixes the issue that messy content was caused after converting Excel to PDF.
• Fixes the issue that using the method pivotTable.DataFields.Clear() to clear the data fields of pivot table didn't take effect.