Filter lost after Workbook.save()

Aspose.Cells Product Family
1

Hi,

I met filter lost issue after Workbook.save() while the filter will not be lost after save by Excel.

Workbook wb = new Workbook(“CF14460.xls”);
wb.save(“CF14460_savedByAspose.xls”);

Also, below name.getRefersTo() throws NullPointerException,
Workbook wb= new Workbook(“CF14460.xls”);
NameCollection nameCollection = wb.getWorksheets().getNames();
for (int i = 0; null != nameCollection && i < nameCollection.getCount(); i++) {
Name name = nameCollection.get(i);
if (null == name || null == name.getRefersTo()) continue;
}

Could you please advise?

Thanks,
Hui

CF14460.zip (34.3 KB)

2

@huichen,
We were able to observe the issues but we need to look into them more. We have logged the issues 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 issues have been logged as

CELLSJAVA-42907 - Filter lost after saving workbook
CELLSJAVA-42908 - Exception while calling Name.getRefersTo()
3

@huichen,

This is to inform you that your issues (logged earlier as “CELLSJAVA-42907” and “CELLSJAVA-42908”) have now been resolved. We will soon share the download link to the latest version which sorts out your issues.

4

@huichen,

Please try our latest version/fix: Aspose.Cells for Java v19.5.2 (attached)

Your issues should be fixed in it.

Let us know your feedback.
Aspose_Cells_Java_v19.5.2.zip (6.5 MB)

5

Hi,

These two issues have been fixed in v19.5.2. Thanks for your kind help!

Regards,
Hui

6

@huichen,

Good to know that your issues are 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.

7

The issues you have found earlier (filed as CELLSJAVA-42907,CELLSJAVA-42908) have been fixed in Aspose.Cells for Java 19.6. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi