[sc-issues] [Issue 97914] cell range selection fails if cell being edited overlaps range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97914 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' Issue type|DEFECT|ENHANCEMENT Keywords| |needmoreinfo, oooqa OS/Version|Linux |All --- Additional comments from rainerbielef...@openoffice.org Sat Feb 27 21:52:21 + 2010 --- 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? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97914] cell range selection fails if cell being edited overlaps range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97914 --- Additional comments from pfor...@openoffice.org Sun Feb 28 03:23:56 + 2010 --- @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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97914] cell range selection fails if cell being edited overlaps range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97914 Issue #|97914 Summary|cell range selection fails if cell being edited overla |ps range Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|pfortin --- Additional comments from pfor...@openoffice.org Fri Jan 9 21:01:59 + 2009 --- 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). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org