[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 --- Comment #6 from Eike Rathke --- Shortest reproducer: =IFS( 0, NA(), 1+0, "no idea") -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 --- Comment #5 from Eike Rathke --- Seems to be an error in error propagation.. Same with =IFS( OR(I9="pago",I9="reci"), NA(), AND(I9="tran",E9>0),"FT from", AND(I9="tran",E9<0), "FT to", 1, "no idea") but not with =IFS( 0, NA(), 0,"FT from", 0, "FT to", 1, "no idea") where the result is "no idea". Also =IFS( OR(I9="pago",I9="reci"), NA(), 0,"FT from", 1, "no idea") produces the expected result, but not =IFS( OR(I9="pago",I9="reci"), NA(), 0+0,"FT from", 1, "no idea") and also not =IFS( OR(I9="pago",I9="reci"), NA(), 0,"FT from", 1+0, "no idea") So whenever an expression is to be evaluated for the condition after a not to be returned error result was encountered. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Oliver Brinzing changed: What|Removed |Added CC||er...@redhat.com --- Comment #4 from Oliver Brinzing --- @Erack, I thought you might be interested in this issue... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Oliver Brinzing 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 --- (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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #2 from Oliver Brinzing --- Created attachment 150728 --> https://bugs.documentfoundation.org/attachment.cgi?id=150728&action=edit simple ifs example -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 forou...@gmail.com changed: What|Removed |Added OS|All |Mac OS X (All) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124710] [1] IFS function mishandles valid #N/A results from functions within IFS
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 forou...@gmail.com changed: What|Removed |Added Summary|[1] IFS function does not |[1] IFS function mishandles |use default result in |valid #N/A results from |certain cases |functions within IFS -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs