https://bugs.documentfoundation.org/show_bug.cgi?id=141292
--- Comment #27 from steffan.steff...@gmx.net --- (In reply to Heiko Tietze from comment #26) > Eike, what do you think? > > * Highlight/Mark calculated cells with imprecise results (why not show the > correct result in this case?) > * Remove/Hide/Warn for "Precision as shown" > * Small feedback at the statusbar if this option is on > * WF Sorry to be so blunt, you seem not to get it: - The option "Precision as shown" is **off** by default; - My problem was caused by "Precision as shown" being off, which is the default - there are no "incorrect results": there are results that are calculated with a bigger or smaller number of digits; - "precision as shown" thus causes a smaller number of digits to be used, since the usual internally used 15 (?) decimal places are deliberately cut off according to how many decimal places you choose to display in your respective cell of the spreadsheet; - my case (invoice) is a special case, which is nevertheless not a rare case, obviously; - in invoices, you want that the numbers "as displayed" or "on paper" add up, even if the result is mathematically less exact, and this is achieved by deliberately cutting off the decimal places that are usually internally used, but are not shown in the display according to the respective cell formatting you chose; - Removing the option "precision as shown" would cause that Calc is then unusable for invoices; If you read here: https://help.libreoffice.org/7.1/en-US/text/scalc/guide/rounding_numbers.html (at the bottom): To calculate with the rounded off numbers instead of the internal exact values Choose Tools - Options - LibreOffice Calc. Go to the Calculate page. Mark the Precision as shown field and exit the dialog with OK. “rounded off numbers” in the above paragraph means: Rounded off according to the formatting of the respective cell (which, obviously, in an invoice is usually 2 decimal places or https://help.libreoffice.org/7.1/de/text/scalc/guide/rounding_numbers.html Mit den angezeigten gerundeten Werten rechnen anstatt mit den internen genauen Werten Wählen Sie Extras - Optionen... - LibreOffice Calc. Wechseln Sie zum Register Berechnen. Markieren Sie Genauigkeit wie angezeigt und beenden Sie den Dialog mit OK. s.o. “angezeigte gerundete Werte” bedeutet ‘wie für die Formatierung der jeweiligen Zelle gewählt’, d.h. in einer Rechnung wird man die Anzeige üblicherweise für alle Zellen auf 2 Nachkommastellen formatieren oder runden (2 Stellen für Eurocent). Damit „Überraschungen“ vermieden werden, schreibt man jetzt Calc vor, dass auch für die interne Berechnung alle Stellen nach diesen 2 Nachkommastellen verworfen werden (=Genauigkeit wie angezeigt) -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise