Hello!
I have an empty document with a formula “=SUM()” in one cell.
Aspose fails to export document to PDF with error ‘Error converting document: Error in Cell: B2-Invalid formula:“SUM()”’.
Expected result: document is exported, the formula in cell evaluates to “0”.
Also actual for:
-DAY()
-MONTH()
-COUNTBLANK()
-HOUR()
-SECOND()
Well, you cannot enter invalid formulas into MS Excel worksheet cells, MS Excel itself displays error message as I tested, see the screenshot for your reference:
Aspose.Cells follows MS Excel standards, so you got to fix the formula first before rendering to PDF file format.
How could “=SUM()” gives you “0”, this is wrong as I tested in MS Excel manually. You have to enter “=SUM(0)” which will give you “0” as calculated value.