To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109905 Issue #|109905 Summary|Range name gets changed on import from Excel Component|Spreadsheet Version|OOO320m12 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|open-import Assigned to|spreadsheet Reported by|john_talbot
------- Additional comments from john_tal...@openoffice.org Sun Mar 7 22:54:25 +0000 2010 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org