https://bugs.documentfoundation.org/show_bug.cgi?id=98822
Pedro <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Pedro <[email protected]> --- (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 [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
