We’re using Aspose.Cells v18.12.0 for .NET and we’ve noticed a couple of issues that appear when we export excel files to PDF, after we purchased the Aspose.Cells product. We decided to share the most easily-reproducible issue here, because the others depend on confidential data. But we could create topics for the rest in the future, if we manage to reproduce them with dummy data.
Namely, the current issue is that the NUMBERVALUE excel formula does not work as expected when exporting files to PDF.
Code used for exporting:
Workbook workbook = new Workbook(“NumberValueBug.xlsx”);
SaveOptions saveOptions = new PdfSaveOptions
OnePagePerSheet = true,
CalculateFormula = true
The test files (source excel and exported pdf) are attached to this topic (in a zip file).
NumberValueFormulaIssue.zip (19.2 KB)
Is there any workaround for this?
Thank you in advance,