https://bugs.documentfoundation.org/show_bug.cgi?id=173202
Bug ID: 173202
Summary: Inconsistencies of LAMBDA functions between Excel365
and Calc
Product: LibreOffice
Version: 27.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Note 1:
Writing "=LAMBDA(a;b;a+b)" in any cell :
Excel 365: display "#CALC" error "Formula result is a function" in cell
ERRORTYPE of "#CALC" error is 14
Calc: display Greek character lambda in cell
Note 2
Writing "=LAMBDA(a;b;a+b)" in cell A1 and writing A1(2;3)
Excel365: Returns #REF error
Calc: Computes 5
Note 3
EXcel365 only accepts a lambda function when inserted as a named formula.
--
You are receiving this mail because:
You are the assignee for the bug.
