Excel Compatibility Bug: IFERROR (and probably other functions)

[eekboom]

Create a workbook that contains a cell with this formula:

=IFERROR(A1, 99)

and save as *.xlsx

When I use Excel 2016, then it stores exactly that text ("IFERROR(A1, 99)") in the worksheet (in xl/worksheets/sheet1.xml).
When I use Planmakler 2018 (rev 938.1004), then it stores the text "_XLFN.IFERROR(A1, 99)".

Why? There should be no difference to Excel itself!

There should be no prefix, because Excel only uses "_xlfn" for functions that are not supported in the output file format.
Also if there really is a need for that prefix, then it should be LOWER CASE "_xlfn", bevause that is what Excel uses.

I just wasted almost a day, because an Excel file that was created by our businest analyst did not work when I tried to use it via the Java library Apache POI ... and it was just because I fixed some small bugs in the excel with Planmaker and saved the result.

[sven-l]

I will refer these issues to the developers.

[sven-l]

The issue has been solved and should no longer occur in the next service pack. Note that Excel was perfectly happy with these files; it's just the Java library that was a bit picky.