https://bugs.documentfoundation.org/show_bug.cgi?id=172820
Bug ID: 172820
Summary: Add IFOMITTED function to Calc
Product: LibreOffice
Version: 27.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Now that Calc supports ISOMITTED, I have noticed that there is a particularly
common usage that looks like this:
IF(ISOMITTED(param);value;param)
I propose to add a function IFOMITTED that would shorten that idiom to:
IFOMITTED(param;value)
along the same lines as IFNA, and for the same reason.
Steps to Reproduce:
1. Use IFOMITTED inside a LAMBDA, e.g.:
=LAMBDA([a];[b];IFOMITTED([a];3)+IFOMITTED([b];5))(4)
Actual Results:
Err:507 appears in the cell.
Expected Results:
The cell should contain 9.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
I think it would be a good idea, if this function is desired, to include this
in 27.2 alongside ISOMITTED.
I would be happy to write it myself, but I am soliciting feedback first.
--
You are receiving this mail because:
You are the assignee for the bug.
