we are using Aspose Cells for Java (Version 17.6) and it seems that there is sometimes a problem when Autofilter is used in worksheets with numeric digits in its name.
After opening saved file Excel wants to repair the file. Rough Message in Excel: “some entries has been removed from ‘definedNames’ in '/xl/workbook.xml-Part '”
Hint:
Excelfile must be repaired if worksheet is named ‘rC2_SUPDo’
Excelfile must not be repaired if worksheet is named ‘C2Test’
I have added a file to reproduce the problem. TestAutoFilter.zip (7.1 KB)
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.
This issue has been logged as
CELLSJAVA-42705 – Excel raises error while loading file after setting the Autofilter
This is to inform you that we have fixed your issue CELLSJAVA-42705 now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.
The issues you have found earlier (filed as CELLSJAVA-42705) have been fixed in Aspose.Cells for Java 18.9. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: Installation|Documentation
This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi