Issue 70015 - Position of AutoFill handle when entire row/column is selected
Summary: Position of AutoFill handle when entire row/column is selected
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: usability
Depends on:
Blocks: 15522
  Show dependency tree
 
Reported: 2006-09-30 20:28 UTC by niederbayern
Modified: 2014-01-13 06:48 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Screenshots showing problem and solution (46.87 KB, image/png)
2006-09-30 20:29 UTC, niederbayern 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description niederbayern 2006-09-30 20:28:20 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!
Comment 1 niederbayern 2006-09-30 20:29:42 UTC 
Created attachment 39477 [details]
Screenshots showing problem and solution
Comment 2 oc 2008-07-15 10:43:31 UTC 
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 3 clement_pillias 2009-01-27 12:12:59 UTC 
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)
Comment 4 clement_pillias 2009-01-27 12:15:34 UTC 
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)
Comment 5 Edwin Sharp 2014-01-13 06:48:58 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian