https://bugs.documentfoundation.org/show_bug.cgi?id=172863
Bug ID: 172863
Summary: Incorrect behaviour when saving =LAMBDA([x]) to
ODS/XLSX
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
>From https://gerrit.libreoffice.org/c/core/+/20807:
Xisco:
So this is the issue:
Open Calc
Add =LAMBDA([x]; IF(ISOMITTED(x);12;5))() to A1 -> value is 12
Save to XLSX and reopen -> formula becomes =LAMBDA([_xlpm.x];
IF(ISOMITTED(_xlpm.x);12;5))() after reopening and value is still 12
Now try to follow the same steps but save it ODS instead:
Open Calc
Add =LAMBDA([x]; IF(ISOMITTED(x);12;5))() to A1 -> value is 12
Save to ODS and reopen -> formula becomes =LAMBDA(x;
IF(ISOMITTED(x);12;5))() after reopening and value is #VALUE
Do you reproduce it on your end ?
Ben:
I am indeed seeing that on my end. So that means that both XLSX and ODS export
are doing the wrong thing, though they are doing different things wrong. XLSX
should produce _xlop.x instead of [_xlpm.x], and ODS should produce [x] instead
of x (I think). Does that sound right to you?
--
You are receiving this mail because:
You are the assignee for the bug.
