Issue 70778 - Calc, applying "Sum" button when x*y range is selected.
Summary: Calc, applying "Sum" button when x*y range is selected.
Status: CLOSED DUPLICATE of issue 51564
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.4
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2006-10-24 11:09 UTC by kpalagin
Modified: 2006-10-27 13:03 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Sample spreadsheet (7.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-10-24 11:10 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2006-10-24 11:09:08 UTC
Calc's current behavior when clicking "Sum" button on formula toolbar with x*y 
range selection does not seem to make much sense.
What Calc currently does is filling of selected range with randomly generated 
formulas (see repro steps below). I doubt that this is what user could ever 
want to happen, let alone want often. I suggest mimicking competing 
spreadsheet by inserting "Sum" below (and enhance behavior by inserting it 
above selected range or sideways, depending on if Ctrl and/or Shift keys are 
Repro steps:
1. Open attached "summing-example.ods" in Calc.
2. Select B2:D11 range and click "Sum" button on "Formula" toolbar. Note how 
contents in all cells in the range is replaced by seemingly random formulas 
like "=SUM(B#REF!:B1)".

Suggested behavior:
2. Select range B2:D11, click "Sum". Calc should generate "Sum(B1:B11)", "Sum
(C1:C11)", "Sum(D1:D11)" in cells B12, C12, D12 respectively.

Suggested enhancement:
2. Select range B2:D11, hold Ctrl key and click "Sum". Calc should 
generate "Sum(B1:B11)", "Sum(C1:C11)", "Sum(D1:D11)" in cells B1, C1, D1 
Holding Shift key should cause Calc to insert "Sum(Bx:Dx)" in cell Ex for 
every row of selection.
Combining Ctrl and Shift should cause Calc to insert sums to the left of the 
Comment 1 kpalagin 2006-10-24 11:10:00 UTC
Created attachment 40022 [details]
Sample spreadsheet
Comment 2 frank 2006-10-27 13:02:43 UTC
double to Issue 51564.

please transfer your comments about the CTRL/SHIFT enhancements to this Issue.

*** This issue has been marked as a duplicate of 51564 ***
Comment 3 frank 2006-10-27 13:03:33 UTC
closed double