Excel Compatibility Bug: IFERROR (and probably other functions)

Fehlerberichte, Hilfe und Anregungen zu PlanMaker 2018 für Linux

Moderator: SoftMaker Team

Antworten
eekboom
Beiträge: 4
Registriert: 24.05.2015 12:14:51

Excel Compatibility Bug: IFERROR (and probably other functions)

Beitrag von eekboom » 16.10.2018 13:37:51

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
SoftMaker Team
SoftMaker Team
Beiträge: 12685
Registriert: 09.04.2008 09:50:06
Wohnort: Nürnberg
Kontaktdaten:

Re: Excel Compatibility Bug: IFERROR (and probably other functions)

Beitrag von sven-l » 19.10.2018 15:58:17

I will refer these issues to the developers.
Sven Leßmann
SoftMaker Software GmbH

sven-l
SoftMaker Team
SoftMaker Team
Beiträge: 12685
Registriert: 09.04.2008 09:50:06
Wohnort: Nürnberg
Kontaktdaten:

Re: Excel Compatibility Bug: IFERROR (and probably other functions)

Beitrag von sven-l » 29.10.2018 13:39:03

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

Antworten

Zurück zu „PlanMaker 2018 für Linux“