Issue 74662

Summary: Provide options for AutoFill
Product: Calc Reporter: niederbayern <eva-email>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: clement.pillias, issues, kpalagin, openoffice
Version: OOo 2.1Keywords: usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 15522    
Attachments:
Description Flags
screenshot showing the main competitor´s functionality none

Description niederbayern 2007-02-19 14:57:22 UTC 
When performing AutoFill using the mouse, the only possibility to determine the
behaviour of the programme ist to hold down the CTRL-key. However, this is not a
wide choice.

Users would like to be able to decide whether cell formats should be copied by
AutoFill or not. Users would like to be able to decide what sort of calculation
has to be performed when filling the values (linear, growth, date, ...)

Suggestion: Allow AutoFill by using the right mouse key for dragging. Show some
popup dialog or context menu with all these options, when the right mouse key
has been used for dragging.
Comment 1 kpalagin 2007-02-19 19:49:28 UTC 
Would be nice to have.

swubuntu,
please consider voting for 
http://www.openoffice.org/issues/show_bug.cgi?id=33851
Comment 2 frank 2007-02-21 13:15:09 UTC 
IMHO it's not necessary as we have Edit-Fill...

but let's requirements decide.

Frank
Comment 3 frank 2007-02-21 13:15:40 UTC 
requirements
Comment 4 niederbayern 2007-02-21 13:45:42 UTC 
Created attachment 43231 [details]
screenshot showing the main competitor´s functionality
Comment 5 niederbayern 2007-02-21 13:47:21 UTC 
Please note that "Edit|Fill..." does not allow to decide whether cell formats
should be copied or not.

You may have a look at the attached screenshot taken from the main competitor
(sorry only in german). It shows the options given after dragging with the right
mouse button.

The options are:
- copy cells
- fill row
- fill formats only
- fill without formats
- fill days
- fill weekdays
- fill months
- fill years
- linear trend
- exponential trend
- row...
Comment 6 clement_pillias 2009-01-27 13:12:38 UTC 
Right-click drag-and-drop is not a common interaction technique and is not
possible on all computers (or it must be emulated with a key modifier.)

I would prefer a solution such as Direct Manipulation Snippets, IMO more
discoverable:
http://wiki.services.openoffice.org/wiki/User_Experience/DirectManipulationSnippets
Comment 7 oooforum (fr) 2017-11-19 15:10:55 UTC 
*** Issue 43380 has been marked as a duplicate of this issue. ***