[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #27 from steffan.steffner at 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.