[Libreoffice-bugs] [Bug 124710] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 --- Comment #13 from QA Administrators --- Dear forouhcr, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 124710] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Winfried Donkers changed: What|Removed |Added Status|ASSIGNED|NEW Assignee|winfrieddonkers@libreoffice |libreoffice-b...@lists.free |.org|desktop.org -- 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] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Winfried Donkers changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |winfrieddonkers@libreoffice |desktop.org |.org Status|NEW |ASSIGNED --- Comment #12 from Winfried Donkers --- (In reply to Xisco Faulí from comment #11) > Dear Winfried Donkers, > This bug has been in ASSIGNED status for more than 3 months without any > activity. Resetting it to NEW. > Please assigned it back to yourself if you're still working on this. Changing the IFS function to a so called 'jump function' (like e.g. IF) that will not propagate error results from arguments not relevant to the end result is a complicated task. I still hope to succeed -with the help from Eike Rathke- but it will take time. Developers who can do this change easily are welcome, currently I have a lot of coding problems to solve and Eike hasn't a proven solution either. Changing the IFS function to a jump function is the only way to solve this bug report and similar problems with the function. -- 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] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Status|ASSIGNED|NEW Assignee|winfrieddonkers@libreoffice |libreoffice-b...@lists.free |.org|desktop.org --- Comment #11 from Xisco Faulí --- Dear Winfried Donkers, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this. -- 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] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Winfried Donkers changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |winfrieddonkers@libreoffice |desktop.org |.org Status|NEW |ASSIGNED --- Comment #9 from Winfried Donkers --- The cause is clear now (the 'error' NA() is propagated on the stack, causing incorrect results in certain cases), the solution too (redesign of the function to jump-type). I will give it a try, it will probably take time. A workaround is to avoid using parameters that can give errors as result, i.e. use references that have been tested not to contain an error value. In the formula given in description, that would mean putting VLOOKUP(J9,$local_vlookup.A:C,2,0) in an unused cell, e.g. Z9, as follows: IFERROR( VLOOKUP(J9,$local_vlookup.A:C,2,0), "ERROR OCCURRED:) and replace the formula by =IFS( OR(I9="pago",I9="reci"),Z9, AND(I9="tran",E9>0),"FT from", AND(I9="tran",E9<0),"FT to", 1,"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] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 --- Comment #8 from Winfried Donkers --- (In reply to Eike Rathke from comment #6) > Shortest reproducer: > > =IFS( 0, NA(), 1+0, "no idea") I know what happens, but not yet why. The raw stacktype for the arguments in ScInterpreter::ScIfs_MS() is 0 svDouble, NA() svError, 1+0 svError, "no idea" svString. This is not influenced by reversing the stack. ScInterpreter::ScIfs_MS() gives #N/A as result, which is not parameter NA(), but the result of PushNA(), because of svError (1+0) is not popped and evaluated. I saw that the parameter parser (I don't know its proper term) parses 1+0 into 1, but have not yet found out if/when the raw stacktype for parameter (1+0) changes into svError. I keep on digging, but it may cost some time. -- 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] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Winfried Donkers changed: What|Removed |Added CC||winfrieddonkers@libreoffice ||.org --- Comment #7 from Winfried Donkers --- I will have a look at it and decide if I can make a fix. -- 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] IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
https://bugs.documentfoundation.org/show_bug.cgi?id=124710 Eike Rathke changed: What|Removed |Added Summary|[1] IFS function mishandles |IFS function erroneously |valid #N/A results from |propagates error results |functions within IFS|from functions within IFS ||(smallest reproducer in ||comment 6) -- 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