[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 Eike Rathke changed: What|Removed |Added Resolution|--- |FIXED Status|NEW

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 --- Comment #8 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/1c14b9efb0677dea65ff220222fbb8d5c2aa6973 Resolves: tdf#146377 Prop

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 Adolfo Jayme changed: What|Removed |Added Whiteboard|target:7.3.0.2 target:7.2.6 |target:7.4.0 target:7.3.0.2

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 --- Comment #7 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/07e58ea08758018906c08321591d264f85a24e66 Related: tdf#146

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 Commit Notification changed: What|Removed |Added Whiteboard|target:7.3.0.2 |target:7.3.0.2 target:7.2.6

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 --- Comment #6 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/eb050ea5b004e2f4a6ba96474177251f678707e9 Related: tdf#146

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 Commit Notification changed: What|Removed |Added Whiteboard||target:7.3.0.2 -- You are

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 --- Comment #5 from Mike Kaganski --- (In reply to Eike Rathke from comment #4) > What does Excel do for this specific case? Both: =IF(NA();1;IFERROR(NA();2)) =AND(NA();IFERROR(NA();1)) result in #N/A. -- You are receiving this mail

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 Eike Rathke changed: What|Removed |Added Version|7.2.4.1 release |Inherited From OOo

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 --- Comment #3 from Paul den Hollander --- I am trying to achieve full compatibility compatibility between my own tool that evaluates formulas and LibreOffice Calc, so I'm trying to understand what happens. So after looking at the Libre

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 --- Comment #2 from Paul den Hollander --- (In reply to Werner Tietz from comment #1) > Hallo > it looks like `IFERROR` in second Formula "controls" the whole > evaluating-chain, no matter its own position, regardless the very uncommon >

[Libreoffice-bugs] [Bug 146377] Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR

2021-12-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=146377 Werner Tietz changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED