Description: sum()'s result is not correct... Steps to Reproduce: sum total (sum()) is not correct 24,092 24,092 24,092 34,892 34,892 13,292 13,292 10,800 24,092 10,800 21,600 34,892 24,092 24,092 24,092 2,492 10,800 10,800 10,800 -------- =sum() Actual Results: 367,200 Expected Results: 367,196 Reproducible: Always User Profile Reset: No Additional Info: I performed the same on Google spreadsheet, the result is 367,196. And also calculate with calculator, the result is 367,196. User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36
I wonder if there might be a hidden cell in the range you are summing? If that is not the case, can you please send us a spreadsheet showing the problem? Remember that your submission will be visible to the whole world. I am setting bug status NEEDINFO. When you respond, please set the status back to UNCONFIRMED. Thank you, Terry.
I calculated with a spreadsheet and calculator and my sum is 377,996. My opinion you mist on 10,800, that's the difference 377,996 and 367,196. I think its not a bug and my i suggest to upgrade your LO to still version.
Created attachment 138759 [details] correct calculation off sum
I guess when you encounter this bug, some cell contents in your spreadsheet are actually "text", not "numbers". This can be observed when you set the cell alignment to default. The values in "text" format are aligning left. If a value is "text", you can see there is a "'" before the number.