Free Support Forum - aspose.com

Filter lost after Workbook.save()


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