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

Aspose.Cells Product Family
1

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)

2

@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

3

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

4

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