Problem with Totalling Formula- Cells M114 and N114

Aspose.Cells Product Family
1

With the attached Excel file- when converted to PDF the value in cell M114 and N114 are not the correct totals. (=$M$7) and (=$N$7) respectively.

2

Hi,


Thanks for your feedback and using Aspose.Cells.

We were able to observe this issue and logged it in our database for a fix.

This issue has been logged as

  • CELLSNET-45333 - Values in cell M114 and N114 are not correct after Workbook formula calculation

I have also attached the output pdf generated with this sample test code as well as the screenshot highlighting the issue for a reference.

C#
Workbook wb = new Workbook(“RW-29906.xlsx”);

wb.CalculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

wb.Save(“output.pdf”, opts);

3
Hi,

Thanks for using Aspose.Cells.

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

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.4.6 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.4.6 (.NET 4.0) compiled in .NET Framework 4.0.
and let us know your feedback.
5

The issues you have found earlier (filed as CELLSNET-45333) have been fixed in Aspose.Cells for .NET 17.5.

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