Aspose Cells - wrong calculate of formula

Aspose.Cells Product Family
1

I have a Excel document (see attachment) that should be converted to Pdf format. The Excel document contains a calculated cell (F34).
In the converted Pdf document cell F34 wronly gets a value = 0,00 using the code below.
If CalculatFormula = false the value becomes 9114,57 (maybe because the value is cached inside the Excel document?)
The newest version of Aspose.Cells is used.

Why is cell F34 calculated to a wrong value?

Workbook workbook = new Workbook(filePathAndName)

Aspose.Cells.PdfSaveOptions pdfSaveOptions = new Aspose.Cells.PdfSaveOptions(Aspose.Cells.SaveFormat.Pdf) { CalculateFormula = true };

workbook.Save(ConvertedFilePathAndName, pdfSaveOptions);

Kopi af OPGOERELSE 2021.zip (40.2 KB)

2

@jwc.vestconsult.dk,
We have logged the issue as “CELLSNET-48145” in our database for investigations. Once we will have some news for you, we will update you in this topic.

3

@jwc.vestconsult.dk,

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

4

@jwc.vestconsult.dk,
Please try the latest fix:
Aspose.Cells21.6.5 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.5 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.5 For .NetStandard20.Zip (5.5 MB)

5

The issues you have found earlier (filed as CELLSNET-48145) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao