[Bug 119819] New: Extra Names exist when open xls file in AOO

[bu...@apache.org]

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

          Priority: P3
            Bug ID: 119819
          Assignee: ooo-issues@incubator.apache.org
           Summary: Extra Names exist when open xls file in AOO
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: tingxiaox@gmail.com
          Hardware: PC
            Status: UNCONFIRMED
           Version: AOO340
         Component: open-import
           Product: spreadsheet

Created attachment 78043
  --> https://issues.apache.org/ooo/attachment.cgi?id=78043&action=edit
sample file of Define Names

Steps:

1. Open attached xls file in AOO
2. Click main menu Insert-->Names-->Define to open Define Names dialog.
3. Check the existing names

Problem:
Extra names "Data 1" and "test 1" exist. But when open the file in MS Excel
2003, you will find only "Data" and "test" names exist.

Please see attached screenshot for detail information.

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

[Bug 119819] Extra Names exist when open xls file in AOO

[bu...@apache.org]

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

Shan Zhu <sh...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |shanzhu33@gmail.com

--- Comment #3 from Shan Zhu <sh...@gmail.com> ---
It is not a defect.
There are indeed 4 named range in the .xls file.
They have duplicated name and different action scopes.
Half of them have global action scope.
Half of them are only for "sheet NumberName001".
So you can see 4 names in AOO's name list.

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

[Bug 119819] Extra Names exist when open xls file in AOO

[bu...@apache.org]

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

--- Comment #1 from xiao ting xiao <ti...@gmail.com> ---
Created attachment 78044
  --> https://issues.apache.org/ooo/attachment.cgi?id=78044&action=edit
screenshot of extra names

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

[Bug 119819] Extra Names exist when open xls file in AOO

[bu...@apache.org]

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

binguo <bi...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |binbjguo@gmail.com
     Ever confirmed|0                           |1

--- Comment #2 from binguo <bi...@gmail.com> ---
This bug can repros on AOO3.4.O Rev. 1327774,
and I change the status from Unconfirmed to confirmed.

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