[Libreoffice-bugs] [Bug 124710] [1] IFS function does not use default result in certain cases

[bugzilla-daemon at bugs.documentfoundation.org]

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

forouhcr at gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |forouhcr at gmail.com

--- Comment #1 from forouhcr at gmail.com ---
Created attachment 150721
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150721&action=edit
Small spreadsheet showing IFS working and malfunctioning.

In sheet 1 the highlighted #N/A values show where the IFS function mishandles a
valid #N/A result from a VLOOKUP. You will also see three rows where the
VLOOKUP found a match and the IFS formula worked.

Note that this spreadsheet was created in Excel 2016 where no such problem
exists; i.e. the #N/A result in Excel is treated as a FALSE and the following
conditions are evaluated until TRUE or the default is reached.

-- 
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/20190412/ddd5e561/attachment.html>