Apache OpenOffice (AOO) Bugzilla – Issue 122828
autofill "text-numbers" behave differently than Excel
Last modified: 2014-07-15 06:45:18 UTC
A1=A-2 autofill generate: A2=A-1 A3=A0 A4=A1 ... so the "-" is interpreted as minus not dash, also when preceded by text. Edit menù, fill series doesn't work with text, so as now no possibility to correctly fill a list with template "text-number"
Confirmed on 4.0 xubuntu 64bit.
I reproduced this defect on my Windows 7 with OOo 3.3.0 and AOO 3.4.0 --> adjusting field Version accordingly.
I reproduce this behaviour on an antiquated version 1.1.5 The Autofill increments numbers, which means in case of a negative number: -2002 -2001 -2000 -1999 If you want the Autofill to consider the absolute value of the number, it makes sense not to use the negation character "-". As explained in https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=71039 the solution is to use a non-breaking hyphen instead of the ordinary hyphen. When typing the first cell, use menu Insert > Formatting Mark > Non-Breaking-Hyphen. IMHO, the behaviour is not a bug.