Issue 122828

Summary:	autofill "text-numbers" behave differently than Excel
Product:	Calc	Reporter:	efa <efa>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	delest.hagar, issues, marcelly.bernard
Version:	3.4.0
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	4.0.0
Developer Difficulty:	---

Description efa 2013-07-24 21:39:36 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"

Comment 1 Hagar Delest 2013-08-05 19:35:40 UTC

Confirmed on 4.0 xubuntu 64bit.

Comment 2 Oliver-Rainer Wittmann 2013-08-09 12:58:58 UTC

I reproduced this defect on my Windows 7 with OOo 3.3.0 and AOO 3.4.0 --> adjusting field Version accordingly.

Comment 3 bmarcelly 2014-07-15 06:45:18 UTC

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.