We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose Cells for Java: regression in 20.5 for LoadDataFilterOptions.VBA and VbaProject#getModules()

Hi,

Aspose Cells for Java version 20.5 seems to contain a regression, compared to version 20.4.

Sample code:

LoadOptions loadOptions = new LoadOptions();
loadOptions.setKeepUnparsedData(false);
loadOptions.setParsingFormulaOnOpen(false);
LoadFilter loadFilter = new LoadFilter(LoadDataFilterOptions.VBA);
loadOptions.setLoadFilter(loadFilter);

InputStream inputStream = new FileInputStream(args[0]);
Workbook workbook = new Workbook(inputStream, loadOptions);
VbaModuleCollection modules = workbook.getVbaProject().getModules();
System.out.println("total modules: " + modules.getCount());
inputStream.close();

Using Aspose Cells 20.4, the sample code finds 6 modules for the provided sample files.
Using Aspose Cells 20.5, the sample code finds 0 modules for the provided sample files.

Kind regards,
Taras

sample-files.zip (20.2 KB)

@TarasTielkes,
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-43196 – Different number of VBA modules detected using Aspose.Cells for Java 20.4 and 20.5

@TarasTielkes,

This is to inform you that we have fixed your issue. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

The issues you have found earlier (filed as CELLSJAVA-43196) have been fixed in Aspose.Cells for Java v20.6. This message was posted using Bugs notification tool by ahsaniqbalsidiqui