https://bugs.documentfoundation.org/show_bug.cgi?id=98822
Pedro <pedl...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |pedl...@gmail.com
--- Comment #2 from Pedro <pedl...@gmail.com> ---
(In reply to goodrichm from comment #0)
> I have a spreadsheet with multiple sheets sharing cell info between each
> other. If i have a cell that adds multiple linked 'cross-shared' cells, the
> result is always .01 less than it should be...
>
> This has been present for several years/versions...
Using the provided file it shows that this is a result of the rounding. The
Total Expenses are _visually_ rounded to two decimal cases but the sum is the
rounded value of the sum of the two non-rounded values.
If you want these to be exact to the cent write =round(sum(C19:C35);2) in cell
C36, copy C36 to D36 and the total should be exact to the cent.
--
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
