Issue 105427

Summary:

SUM() function returning junk

Product:

Calc

Reporter:

hassanik <hassani827>

Component:

code

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 2.4.1

Target Milestone:

---

Hardware:

Other

OS:

Linux, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
A67must return the sum of A47 to A64, which is not obviousely 10!!	none

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

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 ***

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!