Issue 67332 - wrong result summing up a column
Summary: wrong result summing up a column
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-07-13 16:33 UTC by mwigge
Modified: 2006-07-28 13:18 UTC (History)
2 users (show)

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

Attachments
this file shows the bug (8.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-07-13 16:34 UTC, mwigge 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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