Created attachment 49454 [details]
Sheet showing auto fill results
When entering for example a column of month names you can enter, say 'January', and use the autofill feature to generate 'February', 'March', etc just like you can with numbers.
However unlike with numbers entering a month name in two consecutive cells, selecting both, and using the autofill does not adjust the increment. For example entering 'July' twice in a column one directly above the other and using autofill still increments the names. Doing so with numbers, entering say '7' twice, then autofill gives a column of '7's.
Also entering '1st' and autofilling works as expected giving '2nd', '3rd', '4th', etc, however '1st Quarter' yields '2st Quarter', '3st Quarter' etc.
To be clear by 'autofill' I mean selecting a cell or a row/column of cells and dragging the 'handle' either left or down.
I've tested the out on the latest Libre Office for Mac, however I've noticed this on Linux with whichever version of OpenOffice that Ubuntu 10.4 had.
[Reproducible] with "LibreOffice 3.4.1 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:202)]"
Please see my result in attached sample.
LibO3.3.3 Portable, 3.4.2RC2. Master show the same behavior, also OOo 3.3.1
In OOo 3.4 for this case the behavior is consequent.
I believe a really consequent solution should continue numerical trends also for Month names and Day names, means
Jan - March => autofill => June - Aug
So IMHO OOo 3.4-dev does it better, but not in a perfect way.
Modified Version to first LibO Version due to my results
Please feel free to reassign if it’s not your area or if provided information is not sufficient.
Created attachment 49464 [details]
Sample Document, see Comment 1
Reproduced on LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux.
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
Fixed the problem with same entry and still incrementing. 1st Quarter, 2nd Quarter, ... can be added by you into Tools->Options->LibreOffice Calc->Sort.
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
don't deduce increment from multiple equal list entries, fdo#39500