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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141609

--- Comment #5 from Chuck <chuckarnett2008 at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210412/4578aeaa/attachment-0001.htm>