[Libreoffice-bugs] [Bug 144274] Formula not working for minimum positive number... but works in Excel.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.

First of all, you do not describe where exactly you put the formula "In a
neighboring cell". However, it's clear that you don't read the article that you
cite.

I suppose that you see this:
If you put the formula to B1, you see 0
If you put the formula to B2, you see -56
If you put the formula to B4, you see 0
If you put the formula to B5, you see -56

And these are absolutely correct results for the formula in normal mode,
because the first argument of IF is evaluated by intersection. But the article
tells about *array formula*, and explicitly tells that you need to press Shift
+ Ctrl + Enter keys. If you do that in Calc, you will get the same expected
result.

See also
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html?DbPAR=CALC

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210902/162f7240/attachment.htm>