[Libreoffice-bugs] [Bug 158487] Calculation bug in LibreOffice Calc when working with €
https://bugs.documentfoundation.org/show_bug.cgi?id=158487 --- Comment #5 from Mike --- I added the document "test bug.ods" This shows what I mean. I found the setting "Precision as shown" and that is indeed exactly what solves this. You can toggle it to see the difference in the calculation. If you did not set "Precision as shown", the outcome of the 2 and 3 decimal calculations are exactly € 0,01 off. Now I am running Linux Mint which comes with LibreOffice. The default setting of "Precision as shown" is "Not activated". I presume that on whatever OS you install it, that is also the dafault setting. Why is this setting off by default? Seems to me it should be on by default... -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158487] Calculation bug in LibreOffice Calc when working with €
https://bugs.documentfoundation.org/show_bug.cgi?id=158487 --- Comment #4 from Mike --- Created attachment 191190 --> https://bugs.documentfoundation.org/attachment.cgi?id=191190=edit Example what I though was a bug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158487] Calculation bug in LibreOffice Calc when working with €
https://bugs.documentfoundation.org/show_bug.cgi?id=158487 --- Comment #3 from Werner Tietz --- Cannot reproduce input of: 0.015 0.01 shows with 2 decimal places: 0.02 0.01 and the sum of both with 2 decimal places _shows_ : 0.03 If you need also further calculations with the _formatted_ Values, you should probably use →→Tools→Options→LO-Calc→Calculate→→ [x]Precision as shown -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158487] Calculation bug in LibreOffice Calc when working with €
https://bugs.documentfoundation.org/show_bug.cgi?id=158487 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- There is an option for this. Menu/Tools/Options/LibreOffice Calc/Calculation - Precision as show. null/C:/Program%20Files/LibreOffice/help/en-US/text/shared/optionen/01060500.html?System=WIN=CALC=modules/scalc/ui/optcalculatepage/OptCalculatePage#:~:text=with%20Microsoft%20Excel.-,precision%20as%20shown,-Specifies%20whether%20to -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158487] Calculation bug in LibreOffice Calc when working with €
https://bugs.documentfoundation.org/show_bug.cgi?id=158487 --- Comment #1 from Mike --- I just realized that in my situation it showed up in calculating money but of cause the rounding of numbers with more decimals as you want to show also means that faulty calculations in Calc can happen to al numbers it calculates. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158487] Calculation bug in LibreOffice Calc when working with €
https://bugs.documentfoundation.org/show_bug.cgi?id=158487 Mike changed: What|Removed |Added Keywords||difficultyInteresting -- You are receiving this mail because: You are the assignee for the bug.