https://bugs.freedesktop.org/show_bug.cgi?id=88576
Bug ID: 88576
Summary: functions IFNA and IFERROR second argument; export
IFNA to xlsx
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 112452
--> https://bugs.freedesktop.org/attachment.cgi?id=112452&action=edit
test documents before and after the export to xlsx
In bug 59819 functions IFNA and IFERROR was added.
According to specification is second argument of functions mandatory.
spec>
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018448_715980110
Calc allows create functions without second argument and returns results. After
export to XLSX this create incompatibility.
Also export of function IFNA to XLSX is broken (same symptoms as in bug 59819).
Steps to reproduce Error1:
- open iferror_ifna_second argument.ods
- save as .xlsx
- open in excel
Actual results
Error message: broken file, repair. After repair:
A1 = 1 (cached value; formula lost)
A2= =_xlfn.IFNA(F1)
***
IFERROR with second argument is correctly exported to .xlsx.
IFNA with second argument is not correctly exported to .xlsx ->
=_xlfn.IFNA(E1;E2)
Tested with LO 4.3.5, win7
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
