https://bugs.documentfoundation.org/show_bug.cgi?id=172820

--- Comment #2 from nobu <[email protected]> ---
Created attachment 207740
  --> https://bugs.documentfoundation.org/attachment.cgi?id=207740&action=edit
Sample ods

=LAMBDA(a;b;a+b)(3;5)                                       -> 8
=LAMBDA(a;b;IF(ISOMITTED(a);3;a)+IF(ISOMITTED(b);5;b))(;)   -> 8
=LAMBDA(a;b;IF(ISOMITTED(a);3;a)+IF(ISOMITTED(b);5;b))(4;)  -> 9
=LAMBDA(a;b;IF(ISOMITTED(a);3;a)+IF(ISOMITTED(b);5;b))(;4)  -> 7

User Defined Named Formula
IFOMITTED : =LAMBDA(x;v;IF(ISOMITTED(x);v;x))

=LAMBDA(a;b;IFOMITTED(a;3)+IFOMITTED(b;5))(;)   -> 8
=LAMBDA(a;b;IFOMITTED(a;3)+IFOMITTED(b;5))(4;)  -> 9
=LAMBDA(a;b;IFOMITTED(a;3)+IFOMITTED(b;5))(;4)  -> 7

Rather than creating the same "Named Formula" everywhere in the world, I hope
it will be supported from the outset.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to