Finding inconsistency in excel output for the same input using Aspose Cells java

Aspose.Cells Product Family
,
8

@gkamdar,

Thanks for sending an email.
We will evaluate and get back to you soon.

9

@gkamdar
I’m sorry, I can check the email you sent yesterday. But there are no attachments in the email. I have added your email to safe senders. Additionally, if your code and highlighted screenshots are not large, you can directly upload them to the forum. Before uploading, please compress them into zip format. We will check them soon. Please refer to the attachment (157.0 KB).

10

Hi John,

Please find attached the excel files in MANUAL mode calculation.
(If this changes to Automatic mode, you won’t be able to see the difference in Output sheet row number 51, column E, F)

This is one example. There are many other columns in output sheet that do not match. The input sheet for both the excels match completely.

I am using aspose cells version 23.3

Below is the code snippet that I am using to calculate the output for the attached excel

        Workbook workbook = workbookBean.getAsposeWorkbook(); //creating an instance of aspose workbook for an existing excel

        workbook.getSettings().getFormulaSettings().setEnableIterativeCalculation(true); 
        WorksheetCollection worksheets = workbook.getWorksheets();
     
	   
        Worksheet outputSheet = worksheets.get(getOutputSheetName());

        // I am writing the values in the input sheet and then calcualting the workbook            
    workbook.calculateFormula();

After calculating the workbook I get inconsistent output when the input sheet has the same values.
To open the attached excel in manual mode calculation, close all the other excels on the computer.

Please let me know if you need any other info.
excelfile.zip (2.8 MB)

Thanks,
Priyanka

11

@gkamdar,

Thanks for providing the sample Excel files.

I tested your XLSM file(s) and noticed some differences when loading the file into the Aspose.Cells Workbook object model, calculating formulas, and then re-saving the XLSM file. Could you please also share some screenshots highlighting the problematic areas for the cells when comparing the input Excel sheet with the output after being processed and having formulas calculated by Aspose.Cells? This will greatly help us evaluate your issue accurately, so that we can log it into our database correctly and resolve it promptly.

12

Hi @amjad.sahi ,

Attached the screenshot for the output sheet where there are differences for the same input
Please let me know if you need anything more.

Thanks,
Priyanka

screenshot_example1.png (45.7 KB)

screenshot_example2.png (55.4 KB)

13

@gkamdar
By using sample files and code for testing, we can reproduce the issue. Discovered some errors in the file data that was resaved after calling the formula calculation.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45725

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

14

thanks John. I would like to know how much time will it take for the solution in the both (internal issue tracking system and Paid support services )the cases that you mentioned.

15

@gkamdar

Please share us some time to evaluate your issue, then we will share you the ETA in both cases(Free Support and Paid Support).

16

@gkamdar,

Since your issue was logged yesterday (just a few hours ago), please allow us some time to evaluate and analyze it in detail. If it is not complex, we should be able to fix it soon, and the fix may be included in our upcoming release (Aspose.Cells v23.12 - planned for publication in the second week of December next month). If the issue is complex, it may take a few more weeks or even a month to resolve.

Additionally, if you purchase paid support, we will prioritize your issue so that it can be resolved earlier.

17

@peyton.xu : ok, will wait for your response

18

@gkamdar,

We will keep you posted with any new updates once they become available.

19

Hi @amjad.sahi ,

We are subscribed to paid support. Pls let me know what id you need to know.
I have another example for the mismatch. attached the excel and also the screenshot for the mismatch values.

thanks,
Priyanka
example2_excelfile.zip (2.3 MB)

example2_mismatch_screenshot.png (62.5 KB)

20

@gkamdar,

If you have purchased Paid Support, then you may use the Paid Support Account/Subscription and post your issue/ticket in our Paid Support Helpdesk. When creating a new thread/ticket in the paid support helpdesk, you do not need to reiterate the issue from scratch; simply provide the link to this thread and existing issue id (“CELLSJAVA-45725”).

21

@amjad.sahi
I will check the Paid support link given by you. I wanted to know by any chance can you provide us with ETA for the existing issue id (“CELLSJAVA-45725”) as our team is waiting for the resolution.

22

@gkamdar,

We are evaluating/analyzing your issue. Hopefully, we will get back to you soon with the latest updates/ETA on your issue. Once we have an update on it, we will let you know here.

23

@gkamdar
The issue was caused by circular references when refreshing dynamic formulas and calculating formulas. We are working on it and try to solve it in this week. In fact it is a bit complicated and maybe we need more time. We will let you know here when we get any progress.

24

@johnson.shi: thanks for the update

25

@gkamdar

You are welcome and thank you for your patience.

26

@gkamdar,

This is to inform you that your issue has been resolved. The fix will be included in the upcoming release (Aspose.Cells v23.12) that we plan to release in the next week. You will be notified when the next version is published.

27

thank you for the update