Free Support Forum - aspose.com

Calculation succeeds in Excel, Aspose Cells results in "#N/A"

Hi,

Using Aspose Cells for Java, version 19.11.9.

Sample code:

Workbook workbook = new Workbook("input.xlsx");
workbook.calculateFormula();
workbook.getSettings().setCalcMode(CalcModeType.MANUAL);
workbook.getSettings().setReCalculateOnOpen(false);
workbook.save("output.xlsx");

Opening the resulting workbook will show cell IT Concentration!E11 evaluating to #N/A.
However, recalculating the workbook using Excel results in a valid value for the cell. We’ve verified this using both Excel 2010 as well as Excel 365.

The input and output files are attached.

Kind regards,
Taras

input.zip (6.1 MB)
output.zip (6.1 MB)

@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-43070 – calculateFormula() does not calculate value

Hi @ahsaniqbalsidiqui,

The problem seems to originate when Aspose Cells is calculating row 1079 of sheet IT Concentration, and specifically cell W1059.

Please let us know when there is a version to test, since the incorrect #N/A results generated by Aspose Cells are quite a blocker for us.

Kind regards,
Taras

@TarasTielkes,
Thank you for sharing additional information. We have logged it with the ticket for our later reference. Regarding the ETA, I am afraid that still no ETA is available as this issue is pending for analysis. We will write back here as soon as some update is available in this regard.

@TarasTielkes,

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

Hi @Amjad_Sahi,

That is great news, thank you!
We’ll be happy to test a bugfix build on our side for regressions.

Kind regards,
Taras

@TarasTielkes,

Sure, once the fix is available for public use, we will share it with you.

Keep in touch.

@TarasTielkes,
Please try our latest version/fix: Aspose.Cells for Java v19.12.2:
aspose-cells-19.12.2.zip (6.7 MB)

Your issue should be fixed in it.

Let us know your feedback.

Hi @ahsaniqbalsidiqui,

I’ve tried 19.12.2, and the fix looks good.
Thanks for the quick turn-around.

Kind regards,
Taras

@TarasTielkes,
Good to know that your issue is sorted out by the suggested fix. Feel free to contact us at any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Hi @ahsaniqbalsidiqui,

We seem to encounter a performance regression when comparing the currently used version of Aspose Cells for Java (19.9) to the bugfix update (19.12.2) that you’ve made available.

I’ve started a new topic for that here:

Kind regards,
Taras

@TarasTielkes.

We noticed the issue as you pointed out. Please follow up your other thread for reference and for a fix.

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