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 [email protected] Fri Jan 9 21:01:59 +0000 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
