To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97093 Issue #|97093 Summary|Position of active cell when selecting a range Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|sweigel
------- Additional comments from [EMAIL PROTECTED] Wed Dec 10 10:29:51 +0000 2008 ------- When selecting a range either by dragging the mouse or by using the keyboard (SHIFT+Arrow) the active cell resides at the far end of the selection. For example, hold down the mouse button in cell B3, drag and release the mouse button in cell D7. This results in a selection of range B3:D7 and the active cell is D7. (See the attached screenshot.) The position of the active cell is very unfavourable. It would be a big enhancement to usability, to keep the position of the active cell at the beginning of a selected range. (This is the behaviour of the main competitor. See the attached screenshot.) Reasons: * Sorting. When you select a range in order to sort it and you choose "Data|Sort..." in the dialog the preselection for the sort criteria defaults to the column of the active cell. By now this means the sort criteria default to the last column of the selection. However in most cases the user wants to sort by the first column of his selection. * Sorting. When you select a range in order to sort it and you click the "SortUp"/"SortDown" button in the toolbar, sorting will default to the column where the active cell is (issue #7277). By now this means the sort criteria default to the last column of the selection. However in most cases the user wants to sort by the first column of his selection. * Selecting big ranges. After selecting a big range in most cases you want to continue your work in the top left region near the beginning of your selection rather than at the far end of the selection. Before you can continue your work you mostly have to scroll back the screen to the position of the beginning of the selection. For example when you select the range B2:X200 chances are that you want to enter a value or manipulate cell B2 rather than X200. But the latter is the position of the active cell. --------------------------------------------------------------------- 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]
