Issue 97914

Summary:	cell range selection fails if cell being edited overlaps range
Product:	Calc	Reporter:	pfortin <pfortin>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	elish, issues, rainerbielefeld_ooo_qa
Version:	OOO300m9
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	4.1.0-dev
Developer Difficulty:	---

Description pfortin 2009-01-09 21:01:59 UTC

cells:
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. 

@pfortin:
Any ideas concerning a desired behaviour?

Comment 2 pfortin 2010-02-28 03:23:56 UTC

>@pfortin:
>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

Thoughts?
Pierre

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 http://www.openoffice.org/download

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
future.

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
Debian