https://bugs.documentfoundation.org/show_bug.cgi?id=98844
Bug ID: 98844
Summary: The accuracy of the calculation?
Product: LibreOffice
Version: 5.1.0.3 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: sergej_volos...@mail.ru
Created attachment 123794
--> https://bugs.documentfoundation.org/attachment.cgi?id=123794&action=edit
Screenshot Calc
How to configure so that would be considered with an accuracy of "as
displayed"?
Options> Calculation>calculate is set the check-box "Precision as displayed",
but it's not working!!
For example (pic in attach): In the cells are calculated values: 11,89 11,75
11,87 4,03 8,06 The format of each cell is specified the fractional part:2, -
accuracy two digits after the decimal point. If you add the digits of the
number of turns = 47,6. Calc gives 47,62.
Indeed, if you add up all the numbers with a given precision of 3 digits after
the decimal point, we get approximately 47,615.... Thus, Сalc shows some values
(with two digits after the decimal point) but calculation maintains maximum
precision for him. It's good, but in this case I kind of precision is not
required.
I apologize for my bad English,I'm Russian.
--
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
