Apache OpenOffice (AOO) Bugzilla – Issue 70015
Position of AutoFill handle when entire row/column is selected
Last modified: 2014-01-13 06:48:58 UTC
When you have selected an entire row, the AutoFill handle appears in column IV. When you have selected an entire column, the AutoFill handle appears in row 65536. This is very unfavorable, because you have to scroll and move to the very end of the spreadsheet in order to grab the handle. In addition one cannot see the data evolving while draging. Improvement: When an entire row/column ist selected, the AutoFill handle should appaer in the top/left end of the selection. This enhancement is desirable not because MS Excel has it, but it would add a big step of usability to Calc. Also see the attached screenshots!
Created attachment 39477 [details] Screenshots showing problem and solution
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
Confirmed in 3.0. Alternative solutions: * Always keep the handle in-screen if possible (ie, if one of the selection borders is displayed) with preference toward the bottom-right corner. * Use the full selection borders in autofill (dragging the bottom border would only fill or delete rows, dragging the right border would only fill or delete columns)
Somebody of the User Experience Team should be consulted for this issue, but I don't know how to do this (I am not very familiar with the Issue Tracker)
Confirmed with AOO410m1(Build:9750) - Rev. 1555399 2014-01-06_04:13:46 - Rev. 1555657 Debian