In our application we are using aspose.slides to fill powerpoint documents, defined by the user, with data from our backend, when using charts with certain formulars in the datasheet apsose throws an exception on saving the document. (which did not happen in earlier versions)
I am using Aspose.Slides 21.4
When saving a Presentation, where a slide contains chart which is using IF or OR functions in its data areas
Sample Formular =IF(OR(in!$H5="False";in!$H5="");in!B5;"Z")
Exception: Aspose.Slides.Spreadsheet.CellUnsupportedDataException: The cell 'temp'!F4 contains an unsupported formula.
This error did not exist in previous version of Aspose(19.8), there I had to use Aspose.Cell to recalculate the workbook and reapplied it to the chart. When the calculation was not successfully the chart went in the document without a view update, this happened without an error from the aspose side, this was also not ideal, but still better than how it is now.
There are a few issues I have with this error:
-
Why does this error happen at saving and not earlier. This error should happen at the moment when I modify the chart, not on saving the document.
At the moment our generator is at the mercy that the user did not use any unsupported formular. Currently Report that was generated totally fine, can crash because of one lousy chart. And I am not even able to choose to catch this errors so I could add an error message to the chart and have an otherwise fine working document -
Why does it happen at all? We are talking about IF and OR functions which are two of the most basic spreadsheet functions.
-
Can I disable the processing of the charts onSave so it would use the cached values in the spreadsheet provided by Aspose.Cells? And atleast the generation would not crash
Currently our only workaround for this error is to not use the charts or the unsupported formular. Which defeats the point of using it.
Greetings Julian