LoadFilter does not consider all sheets

Aspose.Cells Product Family
1

Hello,

we are using Aspose Cells for Java (Version 19.10) and it seems that there is a problem with using LoadFilter while loading an excel file.

In our case we want to reduce memory usage while loading excel files. Therefore we are using LoadFilter within LoadOptions to read a single worksheet from an excel file.
Normally this works fine! Using LoadFilter with given excel file does not work properly. Here we want to read all data from sheet with name CONFIG but LoadFilter does not receive this sheet. It seems that in this case the last sheet is never offered to method startSheet(Worksheet sheet)

I have added a file to reproduce the problem.
LoadFilter.zip (12.3 KB)

Thanks a lot.

Best regards
Matthias

2

@curmas,
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-43040 – LoadFilter does not consider the required sheet

3

@curmas,

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

4

Perfect. Thanks a lot.

5

@curmas,

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

Your issue should be fixed in it.

Let us know your feedback.
Aspose_Cells_Java_v19.10.3.zip (6.6 MB)

6

It works fine. Thanks a lot.

7

@curmas,

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.

8

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