[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 Eike Rathke changed: What|Removed |Added Resolution|--- |WONTFIX Status|UNCONFIRMED |RESOLVED --- Comment #7 from Eike Rathke --- See also https://erack.de/bookmarks/D.html#010203 -- 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 --- Comment #6 from Uwe Auer --- (In reply to Chuck from comment #5) > Uwe Auer, your solution also works. Thanks for the work-around. Thanks, but it is not meant as a workaround but the way it needs to be done using spreadsheet applications and when doing math with computers using a binary representation of decimal values, which inherently is only an approximation to the decimal value. This binary approximation causes a small difference and when using functions like SUM this difference is added as well and you get error propagation. -- 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 --- Comment #5 from Chuck --- I think it's odd to have to tell the program to round to 2 decimal places when all of the numbers in all of the cells are set to 1 or 2 decimal places already. There is nothing to cause the program to round. I wonder if it has something to do with trailing zeros getting dropped, e.g., inputting "25.00", pressing enter then returning to the cell to find "25". Laurent Combe, that works, but it's "0.01", not "0,01". The comma gave me an error code. Thanks for the work-around. Uwe Auer, your solution also works. Thanks for the work-around. -- 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 --- Comment #4 from Uwe Auer --- Use "=IF(ROUND(B18;2)=ROUND(B39+B59;2);"OK";"No Match")" -- 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 --- Comment #3 from laurent combe --- it's more a rounding calculation issue (well known in spreadsheet) in B79 if you replace your original condition B18=B39+B59 by B39+B59-B18<0,01 is it an acceptable solution for you ? -- 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 --- Comment #2 from Chuck --- Later, I added 3 more columns of data, using the same format. Where additions and subtractions occurred, all numbers evaluated as positive numbers. But the same problem occurred in 2 out of 3 columns. So the problem is NOT restricted to negative numbers. -- 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru 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 141609] LibreCalc IF function incorrectly evaluates negative numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 --- Comment #1 from Chuck --- Created attachment 171085 --> https://bugs.documentfoundation.org/attachment.cgi?id=171085=edit Calc file -- 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