To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44292
------- Additional comments from [EMAIL PROTECTED] Sat Mar 12 17:21:35 -0800 2005 ------- After further testing, I find that one can refer to a named cell or range in another file if one uses DDE linking. The attached files give examples of various types. - a1.xls is a base spreadsheet with some data and a named cell called 'total'. - a1.ods is the same spreadsheet loaded by OOO and saved as ODS format. - a2.xls is a test spreadsheet that contains links to a1.xls. One link is a direct cell reference and the other refers to the cell name 'total'. Both links work in excel. - a2.ods is the a2.xls file as loaded by OOO. Note that the direct reference has been translated correctly, but the named reference gets an Err:508. - a3.ods is another test spreadsheet playing around with various types of links to a1.xls and a1.ods. Here you can see that a link "=DDE(..." works ok with either cell numbering or cell names. But you can also see that a link "='file:..." does not work with cell names. Two points emerge: 1) if you can refer to a named cell in another file using "DDE", then why not using "file:" ?? 2) if only DDE can be used to reference a named cell in another file, then maybe the excel import tool should convert such links in xls files to "DDE" links instead of giving an unacceptable "Err:508" message ?? There will always be those die-hards who insist on sticking with the expensive office products like excel. And those of us already converted to OOO will still need to be able to work with them in future, so little problems like this need to be ironed out soon. regards, --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
