Issue 74733 - AutoFill should continue numerical trends
Summary: AutoFill should continue numerical trends
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2007-02-21 14:55 UTC by niederbayern
Modified: 2017-05-20 09:55 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description niederbayern 2007-02-21 14:55:39 UTC
When performing AutoFill on a series of numbers Calc should continue this series
according to a numerical trend (linear or growth). 

For example:

cell A1 = 5
cell A2 = 12
cell A3 = 13
cell A4 = 20
cell A5 = 24

Select the range A1:A5 and pull down the AutoFill handle to A10. According to a
linear trend the result should be:

cell A6 = 28,6
cell A7 = 33,2
cell A8 = 37,8
cell A9 = 42,4
cell A10 = 47

(This is exactliy what MS Excel is showing.)

However, OOo Calc is showing:

cell A6 = 6
cell A7 = 13
cell A8 = 14
cell A9 = 21
cell A10 = 25

Suggestion: Take over the competitor´s behaviour, since this is a lot more
usefull and this is what most users would expect.

(See Issue #74662 about how to provide options for deciding what type of trend
has to be applied (linear, growth).)
Comment 1 oc 2008-07-15 10:43:12 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 2 Edwin Sharp 2014-01-13 07:18:36 UTC
Use a formula. Auto Fill is prone to fail.