Description: the addtiton by calc is wrong Steps to Reproduce: 1.=Summe (C4:C5) 2. 3. Actual Results: Stromrechnung Verbr./KW Preis/KW Summe 254 0,4309 109,45 € MwSt 20,80 € Summe 130,24 € Expected Results: 130,25 Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes
Created attachment 147245 [details] Spreadsheet
well, if you changed the formula C5 to =ROUND((C4/100*19),2) instead of (C4/100*19) otherwise if you extend the number of decimal places you show for the values you see why the addition ends in 24 and not 25. I think that is all this is.
Its not really a error, select C6 and then press F2 followed by F9, you will see that the total off C4+C5 is something like 130,243834 euro. You can do these to cells C4 and C5 as well same result more numbers after the comma So if you want a visual correct notation off 130,25 euro, then go to tools => options => LibreOffice Calc => calculate and check the option "Precision as shown" and you will have 130,25 euro Version: 6.0.6.2 Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77 CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group So WMF, if you not agree you can still reopen as unconfirmed