Apache OpenOffice (AOO) Bugzilla – Issue 74733
AutoFill should continue numerical trends
Last modified: 2017-05-20 09:55:37 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).)
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
Use a formula. Auto Fill is prone to fail.