[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 Eike Rathke changed: What|Removed |Added Resolution|--- |WONTFIX

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-12 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-12 Thread bugzilla-daemon
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.

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-11 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-11 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-10 Thread bugzilla-daemon
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

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=141609 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 141609] LibreCalc IF function incorrectly evaluates negative numbers

2021-04-10 Thread bugzilla-daemon
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