Issue 122828 - autofill "text-numbers" behave differently than Excel
Summary: autofill "text-numbers" behave differently than Excel
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-24 21:39 UTC by efa
Modified: 2014-07-15 06:45 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.