DO NOT REPLY [Bug 118811] New: Range that defined from name box is not added into range list

[bu...@apache.org]

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

             Bug #: 118811
        Issue Type: DEFECT
           Summary: Range that defined from name box is not added into
                    range list
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3
          Platform: PC
        OS/Version: Windows XP
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: P5
         Component: editing
        AssignedTo: spreadsheet@openoffice.org
        ReportedBy: louqingle@gmail.com
                CC: ooo-issues@incubator.apache.org


1. new a Calc
2. select some cells, e.g. A1:A3, now the name box will display A1:B3
3. replace "A1:A3" with a name in name box, e.g. "Range1", now A1:B3 is named
as "Range1"
4. Click menu Data->Select range

expect: Range1 should be list here since it's a range name user defined
actual: the list is empty

5. close the range list dialog, then select another region,e.g. B1:B3, name it
by menu Data->Define range as "Range1"

expect: it should report invalid name since the name has been used
actual: named as "Range1" successfully..

6. Click menu Data->Select range, "Range1" is in the list. double-click it the
region named in step 5 will be highlighted..

7. enter different numbers into A1:A3 and B1:B3, then in any other cell input
"=sum(Range1)", it's using the data in region A1:A3

Which region is "Range1"?

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

DO NOT REPLY [Bug 118811] Range that defined from name box is not added into range list

[bu...@apache.org]

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

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

[Bug 118811] Range that defined from name box is not added into range list

[bu...@apache.org]

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

Oliver-Rainer Wittmann (orw at apache dot org) <or...@googlemail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|enhancement                 |normal

--- Comment #1 from Oliver-Rainer Wittmann (orw at apache dot org) <or...@googlemail.com> ---
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.

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

DO NOT REPLY [Bug 118811] Range that defined from name box is not added into range list

[bu...@apache.org]

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

louqle <lo...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |INVALID

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.