https://bugs.documentfoundation.org/show_bug.cgi?id=173995
Winfried Donkers <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|bibisectRequest, regression | --- Comment #10 from Winfried Donkers <[email protected]> --- (In reply to ady from comment #8) > As mentioned in comment 4, IFS() is "COM.MICROSOFT.IFS", not in ODFF. > Minimal conditions to trigger the bug: > > _ The first argument is a boolean, or a result of a boolean test; a numeric > non-zero value does not trigger the bug. > > _ The Result argument is a negative numeric value; other Results do not > trigger the bug. I can confirm the minimum conditions (my tests yesterday did not meet the first of the conditions, I can also confirm it happens with version 27.2 (dev.build). Interestingly, =IFS(FALSE(),-1,1,-2) also returns TRUE instead of -2, so the conclusions of ady are very accurate. -- You are receiving this mail because: You are the assignee for the bug.
