Issue 105427 - SUM() function returning junk
Summary: SUM() function returning junk
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: Other Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2009-09-28 14:33 UTC by hassanik
Modified: 2009-09-29 05:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

A67must return the sum of A47 to A64, which is not obviousely 10!! (10.52 KB, text/plain)
2009-09-28 14:36 UTC, hassanik
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description hassanik 2009-09-28 14:33:17 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.
Comment 1 hassanik 2009-09-28 14:36:33 UTC
Created attachment 65012 [details]
A67must return the sum of A47 to A64, which is not obviousely 10!!
Comment 2 frank 2009-09-28 15:48:06 UTC

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.


*** This issue has been marked as a duplicate of 5658 ***
Comment 3 frank 2009-09-28 15:48:30 UTC
closed double
Comment 4 hassanik 2009-09-29 05:12:24 UTC
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!