Issue 67332

Summary: wrong result summing up a column
Product: Calc Reporter: mwigge <mwigge>
Component: editingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: ambrogio.de.lorenzo, issues
Version: OOo 2.0.3Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
this file shows the bug none

Description mwigge 2006-07-13 16:33:46 UTC 
I just copied a column from a MS-Word document and pasted it in calc to sum up
the values and noticed that the sum() function ignored a value which had leading
spaces.
Afterwards I rechecked in Excel which calculated the sum correctly ignoring the
leading spaces.
Comment 1 mwigge 2006-07-13 16:34:37 UTC 
Created attachment 37748 [details]
this file shows the bug
Comment 2 delorea 2006-07-21 16:12:05 UTC 
have a look to issue n. 5658
In OO there is a difference from Text and Number that is marked. Engineering
doesn't want to make the difference lite as Excel.

So this is by design.
If it is your issue, I think that your can be closed ad invalid.
Let me know
Comment 3 mwigge 2006-07-25 11:55:47 UTC 
Well, thats fine for the design part, but when I change my point of view
and act as a user and not as a programmer I just want to copy and paste
values to sum them up.
So I mark the stuff I want and paste it to calc and all what I see is
that it makes a wrong result.
I as a programmer already had that problem and I understand the reasons
but not a quite normal user. BTW: It took me a little time to actually
find the problem.
So I think at this point we have a problem with the design that should
be fixed.
And don't forget to think like a user even if it hurts ;-)
Comment 4 frank 2006-07-28 13:17:19 UTC 
Hi,

Excel calculates with text values, Calc does not as text is text and not a
number and you can't calculate with text. Your example shows that the cell
containing numbers with leading spaces is interpreted as text.

So this is a double to Issue 5658 .

Frank

*** This issue has been marked as a duplicate of 5658 ***
Comment 5 frank 2006-07-28 13:17:44 UTC 
Hi,

Excel calculates with text values, Calc does not as text is text and not a
number and you can't calculate with text. Your example shows that the cell
containing numbers with leading spaces is interpreted as text.

So this is a double to Issue 5658 .

Frank

*** This issue has been marked as a duplicate of 5658 ***
Comment 6 frank 2006-07-28 13:18:23 UTC 
closed double