Using SUMIFS formulas Wrong results in Java

Aspose.Cells Product Family
1

The workbook: aspose-sumifs-difference.xlsx demonstrates a bug with SUMIFS in Aspose Cells version 16.12.0 (and also the latest version, 17.6.0).

The error occurs in cell Sheet2!B2. When Aspose calculates this cell, it obtains a value of zero whereas Excel gets 3,000. The same error occurs in every even-numbered row on that worksheet.

2

@andyczerwonka

Thanks for using Aspose APIs.

We were able to observe this issue as per your issue description, sample Excel file and sample code. We have logged this issue in our database for product team investigation and for a fix.

This issue has been logged as

  • CELLSJAVA-42338 - Wrong results when using SUMIFS formulas
3

There was no sample code, just the spreadsheet. The sample code in the link was for another issue I logged the day before. CELLSJAVA-42337

4

Hi,

We can use your similar code (for other issue) with a little tweak to reproduce this issue.
e.g
Sample code:

 Workbook workbook = new Workbook("aspose-sumifs-difference.xlsx");

        workbook.calculateFormula();

        Cell b4 = workbook.getWorksheets().get(1).getCells().get("B2");
        System.out.format("B2: expect 3,000, got %s%n", b4.getValue());

Alternatively we can calculate all the formulas in the spreadsheet and then render to PDF file format to evaluate the calculated results and reproduce the issue you have mentioned.

Please spare us little time, we will figure it out soon.

Thank you.

5

@andyczerwonka

Thanks for using Aspose APIs.

We reproduced your issue with our own sample code and that sample code was driven from your sample code. So, there is nothing to be worried. It is our day to day task to reproduce Workbook formula calculation issues. Even if you did not provide us any sample code, we would be able to reproduce it easily.

6

@andyczerwonka

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSJAVA-42338 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

7

@andyczerwonka,

Please try our latest version/fix: Aspose.Cells for Java v17.6.7:

Your issue should be fixed in it.

Let us know your feedback.

Thank you.

8

The issues you have found earlier (filed as CELLSJAVA-42338) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

9

The issues you have found earlier (filed as CELLSJAVA-42338) have been fixed in Aspose.Cells for Java 17.7.