[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
            Version|6.1.5.2 release             |5.4.7.2 release
                 OS|Mac OS X (All)              |All
             Status|UNCONFIRMED                 |NEW

--- Comment #3 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to forouhcr from comment #0)
> I played with the formula by changing some conditions. When the VLOOKUP is
> replaced with a text value, the IFS formula works.

reproducible with LO 5.4.7.2
it seems evaluting is stopped as soon as vlookup returns #N/A

-- 
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/20190413/f131203a/attachment.html>