Issue 109905 - Range name gets changed on import from Excel
Summary: Range name gets changed on import from Excel
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO320m12
Hardware: All Windows XP
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-03-07 22:54 UTC by john_talbot
Modified: 2013-01-29 21:42 UTC (History)
2 users (show)

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

This is the file manifesting the problem. (56.05 KB, application/
2010-03-07 22:57 UTC, john_talbot
no flags Details
FFC252SC_NumberName0001.xls (31.00 KB, application/
2012-06-05 09:18 UTC, Li Lin Yi
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description john_talbot 2010-03-07 22:54:25 UTC
A spreadsheet workbook used by many users around the world for reporting 
astronomical observations uses cell and range names that another workbook with 
a macro uses for translating data into a coded text format and for merging data 
from multiple users. 
When an observer opens the reporting file in Calc it changes some of the names.
I particular a Name "_Remark1" gets changed to "_Remark1_2".  There is another 
name "_TRemark1" on a different sheet that appears to be mistaken as the same 
name. This implies that Calc requires the last 6 or 7 characters to be unique.

I am able to change the macro to serach for both names as a work around so this 
is not too serious but it took quite a while to find what was happening and I 
was only able to analyse when the user mentioned that he used OpenOffice and 
not MSOffice.

I have searched you Issues database and have not found this problem or 
constraint on name uniqueness mentioned.

I would suggets that at very least a warning message should be given when names 
are changed. A note in the help about Range names may also be useful.
Comment 1 john_talbot 2010-03-07 22:57:20 UTC
Created attachment 68200 [details]
This is the file manifesting the problem.
Comment 2 Li Lin Yi 2012-06-05 09:17:52 UTC
Another attached file: FFC252SC_NumberName0001.xls

Open the attached file. Go to sheet "NumberName0010", "NumberName0015". Check cell B19. They should be =SUM(Data) and =test. But in AOO3.4 Rev. 1327774, they changed to =SUM(Data 1) and =test 1.
Comment 3 Li Lin Yi 2012-06-05 09:18:49 UTC
Created attachment 78013 [details]
Comment 4 Li Lin Yi 2012-06-18 03:18:57 UTC
Fogot to changed to confirmed.