Apache OpenOffice (AOO) Bugzilla – Issue 97914
cell range selection fails if cell being edited overlaps range
Last modified: 2013-12-15 15:06:18 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).
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?
>@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
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.
In Calligra Sheets when highlighting B1:B2, =sum( --> (B1:B2 . AOO410m1(Build:9750) - Rev. 1548193 2013-12-07_04:10:48 - Rev. 1548790 Debian