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.
Excel Compatibility Bug: IFERROR (and probably other functions)
-
- SoftMaker Team
- Beiträge: 10275
- Registriert: 09.04.2008 09:50:06
- Wohnort: Nürnberg
- Kontaktdaten:
Re: Excel Compatibility Bug: IFERROR (and probably other functions)
I will refer these issues to the developers.
Sven Leßmann
SoftMaker Software GmbH
SoftMaker Software GmbH
-
- SoftMaker Team
- Beiträge: 10275
- Registriert: 09.04.2008 09:50:06
- Wohnort: Nürnberg
- Kontaktdaten:
Re: Excel Compatibility Bug: IFERROR (and probably other functions)
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.
Sven Leßmann
SoftMaker Software GmbH
SoftMaker Software GmbH