Issue 74662 - Provide options for AutoFill
Summary: Provide options for AutoFill
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: usability
: 43380 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2007-02-19 14:57 UTC by niederbayern
Modified: 2017-11-19 15:10 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

screenshot showing the main competitor´s functionality (54.60 KB, image/jpeg)
2007-02-21 13:45 UTC, niederbayern
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.

please consider voting for
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.

Comment 3 frank 2007-02-21 13:15:40 UTC
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
Comment 7 oooforum (fr) 2017-11-19 15:10:55 UTC
*** Issue 43380 has been marked as a duplicate of this issue. ***