Wrong sum displayed

Aspose.Cells Product Family
1

Hi,


The attached xlsx file is rendered wrong (see screenshot). The sum at the bottom is 6:00. In MS Excel it is 7:00. Tested with Aspose.Cells 8.9.2.0.

Best Regards,
Vassil
2

Hi,


Thanks for providing us template file and screenshot.

After an initial test, I observed the issue as you mentioned via your screenshot using your template file and following sample code. I found that wrong SUM is displayed when calculating formulas in the rendered file (PDF/image). The sum at the bottom is 6:00 but In MS Excel, it is 7:00.
e.g
Sample code:

Workbook wb = new Workbook(“E:\test2\ArbeitszeiterfassungJuli12345.xlsx”);
wb.CalculateFormula();
wb.Save(“E:\test2\out1.pdf”);

I have logged a ticket with an id “CELLSNET-44705” for your issue. We will look into it to figure it out soon.

Thank you.
3

Hi Vassil,


This is to inform you that we have resolved the problem logged earlier as CELLSNET-44705. We will shortly provide the fix here for your testing.
4
Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.9.2.6 and let us know your feedback.

5

Thanks! The bug is fixed in v8.9.2.6.

But, I need the version for .Net 4.
I think I can wait for the official release of the next version.

Best Regards,
Vassil.

6

Hi Vassil,


Thank you for the confirmation on fix. Please note, next official release of Aspose.Cells for .NET is scheduled for the upcoming week. You will be automatically notified here as soon as the next release is available for public use.
7

The issues you have found earlier (filed as CELLSNET-44705) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.