Issue 97914 - cell range selection fails if cell being edited overlaps range
Summary: cell range selection fails if cell being edited overlaps range
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO300m9
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-01-09 21:01 UTC by pfortin
Modified: 2013-12-15 15:06 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description pfortin 2009-01-09 21:01:59 UTC
b1:c3  cells contain numbers

edit a2 and click "sum" icon -> "=SUM()"
mouse select any combination of cells and formula should change to "=SUM(start:end)"

This works unless column A is narrow enough for the formula to spill over into
column B.  In that case, it is possible to select:
- b1->c3, c3->b1 (full range)
- b1->b3, b3->b1; but not b1->b2 or b3->b2 (column)
- not b3->b2
- c2->b1, c2->b3 (successfully includes b2)
- no range where the mouse attempts to start at b2

IOW, it is not possible to mouse select a range which includes the cell to the
right of the formula if the formula column is narrower than the displayed
formula; unless cell b2 is not part of the formula itself (i.e., b2 is included
in the full range).
Comment 1 Rainer Bielefeld 2010-02-27 21:52:21 UTC
I can confirm the effect. It's not only a range problem, if you click into 'A1',
type "=" and then alternating 5 times click into a cell (except 'B1') and add
"+" for a formula like "=C2+C3+C4+C5+C6+". Nor try to select 'B1' by mouseclick
to finish the formula: it won't work because 'B1' is covered by the formula in 'A1'.

No Idea how that problem can be solved. 

Any ideas concerning a desired behaviour?
Comment 2 pfortin 2010-02-28 03:23:56 UTC
>Any ideas concerning a desired behaviour?

Sitting here, thinking about the problem and wondering why we have *two* edit
areas (cell and top edit field)...  OK...  I can buy into having both; but the
problem as you state is how to solve the problem....  

To me, a really cool solution would require the in-cell edit box "getting out of
the way"...  Imagine the in-cell edit area being left-justified (current
behavior), then magically becoming right-justified when the mouse is moved over
the next cell to the right...  If a cell becomes complex enough to require
multiple lines of entry, then there would need to exist top/bottom-justification
to similarly move the edit field away from adjacent cells.

Lead, follow, or GET OUT OF THE WAY!!!  LOL

Comment 3 Rob Weir 2013-02-02 02:59:46 UTC
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
Comment 4 Edwin Sharp 2013-12-15 15:06:18 UTC
In Calligra Sheets when highlighting B1:B2, =sum( --> (B1:B2 .

AOO410m1(Build:9750)  -  Rev. 1548193
2013-12-07_04:10:48 - Rev. 1548790