Apache OpenOffice (AOO) Bugzilla – Issue 105427
SUM() function returning junk
Last modified: 2009-09-29 05:12:24 UTC
sometimes when the SUM() function is used for a range, for example, SUM(A47:A64) it returns some nonsense number, instead of the sum of the values in the range.
Created attachment 65012 [details] A67must return the sum of A47 to A64, which is not obviousely 10!!
Hi, not a bug but a support request ! Please press CTRL+F8 As you can see all 'numbers' in the range A1:A64 are black and therefore Text ! (except A42 which is blue indicating it as a number) This feature is called value highlighting (have a look in the Help system for it). Text is Text and numbers are numbers. And therefore you can't calculate with text. The behaviour shown by Calc will be changed soon. Have a look at Issue 5658 also. Frank *** This issue has been marked as a duplicate of 5658 ***
closed double
thanks for the solution, but still don't understand why only one of the numbers (A42) in the range is a real "number", and all others appear as text! I just entered all of them the same way in my file!