sum()'s result is not correct...
Steps to Reproduce:
sum total (sum()) is not correct
User Profile Reset: No
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.
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.