To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112482 Issue #|112482 Summary|Shift-Ctrl-Arrow selection of 2D sparse data does not |perform as expected Component|Spreadsheet Version|OOo 3.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|reemrevnivek
------- Additional comments from reemrevni...@openoffice.org Thu Jun 17 16:09:24 +0000 2010 ------- Consider a sparse data set such as: [a][b][c][d][e][f] [1] H E A D E R [2] J 2 9 5 [3] K 3 8 9 [4] L 2 7 (import CSV: H,E,A,D,E,R,;J,,2,9,5,,;K,3,,8,,9,;L,2,,7,,) Shift-Ctrl-Arrow selection stops just before the first empty block, then proceeds to the next data, then stops just before the next empty block etc. This seems like good behavior for a 1-dimensional selection. However, when working with a 2-D selection (In reference data Shift-Ctrl-Down from cell A1, then Shift-Ctrl-Right) the selection stops before the first empty cell in the current row (resulting in A1:B4), as with one-dimensional selection. Subsequent Shift-Ctrl-Right entries result in A1:D4, then A1:AMI-4 (the far right boundary.) This behavior is likely not what is desired. I expect that most users who enter this sequence want A1:F4; their sparse matrix. I propose that the behavior when Shift-Ctrl-Arrow is entered with part of a column already selected) should be one of: 1. Stop just before the first completely empty column for all of the selected rows. This is most likely (in any situation I can imagine) to be what the user wants. 2. Use the current behavior, then behave as in 1 after the last entry in the current row (Instead of moving to all the way to the right of the spreadsheet). This preserves the current experience, but also allows the desired behavior, and avoids selecting entire rows or columns( Whether adjoining columns and rows should participate (How to select the data B2:F4) should also be considered. Yes, I know that starting from cell A4 or F1 and going up-right or left-down respectively results in the desired selection. However, data without row identifiers or column headers is also common. --------------------------------------------------------------------- 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