You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/07/24 23:39:36 UTC

[Bug 122828] New: autofill "text-numbers" behave differently than Excel

https://issues.apache.org/ooo/show_bug.cgi?id=122828

            Bug ID: 122828
        Issue Type: DEFECT
           Summary: autofill "text-numbers" behave differently than Excel
           Product: Calc
           Version: AOO 4.0.0
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: efa@iol.it
                CC: issues@openoffice.apache.org

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"

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 122828] autofill "text-numbers" behave differently than Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122828

Oliver-Rainer Wittmann <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |orw@apache.org
            Version|4.0.0                       |3.4.0

--- Comment #2 from Oliver-Rainer Wittmann <or...@apache.org> ---
I reproduced this defect on my Windows 7 with OOo 3.3.0 and AOO 3.4.0 -->
adjusting field Version accordingly.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 122828] autofill "text-numbers" behave differently than Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122828

Hagar Delest <ha...@laposte.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |hagar.delest@laposte.net
     Ever confirmed|0                           |1

--- Comment #1 from Hagar Delest <ha...@laposte.net> ---
Confirmed on 4.0 xubuntu 64bit.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 122828] autofill "text-numbers" behave differently than Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122828

Oliver-Rainer Wittmann <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|orw@apache.org              |

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Issue 122828] autofill "text-numbers" behave differently than Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122828

bmarcelly <ma...@club-internet.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |marcelly@club-internet.fr

--- Comment #3 from bmarcelly <ma...@club-internet.fr> ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Bug 122828] autofill "text-numbers" behave differently than Excel

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122828

Oliver-Rainer Wittmann <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Latest|---                         |4.0.0
    Confirmation on|                            |

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.