Issue 63920 - Auto SUM creating sums within specified sums
Summary: Auto SUM creating sums within specified sums
Status: CLOSED DUPLICATE of issue 51564
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2006-04-03 06:02 UTC by abeburnett
Modified: 2006-04-10 08:57 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description abeburnett 2006-04-03 06:02:45 UTC
A column of numbers when selected and then the Auto SUM button clicked results
in SUM equations being assigned to all cells within the selected range.



Select A1 through A3 and click Auto SUM. The result is #REF! in every
cell--though the expected behavior would put the total of 6 in cell A4. In
larger spreadsheets with values above the current selection to be summed, those
values in the column above will find themselves integrated into the current sums
when each cell has a SUM equation erroneously added to it. Thus, even if Auto
SUM correctly yielded the correct sum of 6 in the above example, but Auto SUM
was again used on another set of numbers below...


(should yield 27, but instead will add the sum from above into it's sum--even
though it's outside the selected range)

For the above we should have the following SUM equations in the cells:

no formula
no formula
no formula
blank cell
no formula
no formula
no formula

INSTEAD we end up with the following (and herein occurs the problem):

blank cell

Am I explaining the problem adequately? Essentially the Auto SUM button doesn't
work as advertised.

The Intelligent Auto SUM seems to work though--interestingly enough. By which I
mean that if you simply position the cursor beneath the group of numbers you
want to sum and click Auto SUM it will present the suggested range, and then
when Enter is pressed it will correctly sum the numbers. The expected behavior
is also obtained when the formula is typed in manually. 

However, for those users like my mother who just want something to work, the
work-arounds aren't an acceptable alternative. I've worked hard to sell her on
OpenOffice so I hope this can be fixed so her faith is maintained. :)

Thanks for your excellent work!
Comment 1 drensink 2006-04-03 07:06:41 UTC
Confirmed on Windows XP OOo 2.02.  Cannot find any duplicates.  This one will
likely effect a large number of users since it is a widely expected basic
functionality of a spreadsheet. 

The result of an Auto Sum of a selection should be that the sums are entered in
the cells below the selection without changing anything in the selection itself.

Comment 2 drensink 2006-04-09 20:03:45 UTC
Duplicate of Issue 51564

*** This issue has been marked as a duplicate of 51564 ***
Comment 3 frank 2006-04-10 08:57:42 UTC
and closed