Hi all, in the meantime LibreOffice has implemented empty and missing parameters. Find all mentioned cases in the attached spreadsheet. Gnumeric seems to work the same as LibreOffice. Excel too, only that it does not allow to enter the case =IF(condition). Kind regards Regina Attachment: Test_LO_60_strict_ODF12.ods Description: application/vnd.oasis.opendocument.spreadsheet