Issue 119819 - Extra Names exist when open xls file in AOO
Summary: Extra Names exist when open xls file in AOO
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-06 05:32 UTC by xiao ting xiao
Modified: 2012-06-14 03:19 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
sample file of Define Names (31.00 KB, application/vnd.ms-excel)
2012-06-06 05:32 UTC, xiao ting xiao 		no flags Details
screenshot of extra names (114.34 KB, image/jpeg)
2012-06-06 05:32 UTC, xiao ting xiao 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description xiao ting xiao 2012-06-06 05:32:00 UTC 
Created attachment 78043 [details]
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.
Comment 1 xiao ting xiao 2012-06-06 05:32:38 UTC 
Created attachment 78044 [details]
screenshot of extra names
Comment 2 binguo 2012-06-12 07:13:17 UTC 
This bug can repros on AOO3.4.O Rev. 1327774,
and I change the status from Unconfirmed to confirmed.
Comment 3 Shan Zhu 2012-06-14 03:19:06 UTC 
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.