In Aspose.cells: excel formulas are skipped/changed after saving file

Aspose.Cells Product Family
1

After reading an excel file with the Aspose.cells library and saving it back the formulas are skipped or changed.

Following opearations are performed
lAsposeDocument = new com.aspose.cells.Workbook(pInputStream);
lAsposeDocument.save(lOutputStream, com.aspose.cells.SaveFormat.XLSX);

In attached pdf you can see the effect

Formula issue.pdf (279.0 KB)

We have this issue with version 19.12 and with the latest version in 21.2.

2

@mrjverhoef,
Please share your sample file with us for our testing. We will reproduce the problem and provide our feedback after analysis.

3

Sample file.zip (58.6 KB)

The zip file contains the original file and the processed file by Aspose.

The formula in sheet Sample, Cell Q4, Q4 and Q6 is set to zero

4

@mrjverhoef,
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-43407 - Excel formulas are skipped/changed after saving file
5

Good that you were able to observe the issue. I will wait on outcome/fix.

6

@mrjverhoef,

Sure, once we fix the issue or we have other updates, we will share it with you.

7

Hi,

Do you already have an update on this issue?

8

@mrjverhoef,

Your issue is “In Progress”. We are working over your issue and hopefully it will be fixed soon. If it takes more time, we will share an ETA on it,

9

@mrjverhoef,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version (within 2/3 days) after performing QA and incorporating other enhancements and fixes.

10

@mrjverhoef,

Please try our latest version/fix Aspose.Cells for Java v21.3.3:

aspose-cells-21.3.3-java.zip (7.2 MB)

Your issue should be fixed in it.

Let us know your feedback.

11

Thank you very much.
I will test the fix

Richard

12

@mrjverhoef,

Please take your time to evaluate the new fix/version. Hopefully, it will fix your issue.

13

The issues you have found earlier (filed as CELLSJAVA-43407) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi