incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 118811] New: Range that defined from name box is not added into range list
Date Wed, 18 Jan 2012 06:41:38 GMT
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.

Mime
View raw message