https://bugs.documentfoundation.org/show_bug.cgi?id=163281
Ming Hua <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Sum function in LibreOffice |Sum function in LibreOffice |comes back with a large |comes back with a small |negative number in |negative number in |scientific notation rather |scientific notation rather |than 0 |than 0 --- Comment #4 from Ming Hua <[email protected]> --- (In reply to Werner Tietz from comment #3) > please attach an reduced example.ods which shows the issue! I don't see the need of an example. -6.537E-13 is a rather small number, not a large number as the report summary says (I'll change the summary as well). It's just the regular confusion by user when he/she sees a non-zero floating point number due to rounding error when zero is expected. Dan, this is just the way floating point math works in software. Your cell should have a zero, but you set it to display numbers with any precision, so it is showing some rounding error from your calculation. Judging by the limited screenshot, I'm guessing it's some currency numbers from accounting, so please change your cell format (main menu Format > Cells..., Numbers tab), to "Numbers" with two decimal places, or just "Currency", and you'll get 0.00 that you are familiar with. -- You are receiving this mail because: You are the assignee for the bug.
