Issue 122828 - autofill "text-numbers" behave differently than Excel
Summary: autofill "text-numbers" behave differently than Excel
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:
Depends on:
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: ---


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
autofill generate:
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:

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 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.