To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78030 Issue #|78030 Summary|Name Define does not work across spreadsheets Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|robertbradbury
------- Additional comments from [EMAIL PROTECTED] Fri Jun 1 20:40:49 +0000 2007 ------- In Excel spreadsheets, it is possible to "Insert >> Name >> Define" to insert names which reference cells in other worksheets. This feature also works for cells in other spreadsheets using a slightly more complex syntax. The syntax appears to be of the form: ='X:\[spreadsheet.xls]sheetname'!$columnletter$rownumber or ='X:\[spreadsheet.xls]sheetname'!Definition (where Definition is a defined name in the spreadsheet.xls namespace) When opening a spreadsheet with an external name definition, calc does not complain about the use of external definitions, nor does it seem to attempt to locate the definition. (Under Windows, I think Excel has a dialog box which attempts to assist one in searching for missing spreadsheets. Under Linux, a logical alternative might be to search the PATH directories for any external spreadsheets. Or perhaps there is a completely separate OO search path that should be used.) I think under Excel under Windows, the search process for spreadsheets is something like: "Open spreadsheets; Directory of referencing spreadsheet; Dialog search box". In any case OO (calc) *should* produce an error for names which are defined in external sheets whose spreadsheet file or worksheet or cell cannot be located. OO appears to recognize that the sheet contains references to external files and asks whether the links should be updated, but the name definitions end up as "#NAME!Definition" even when the referenced spreadsheets are present in the directory of the referencing spreadsheet. It is not clear whether this is (a) because OO is not processing the ='Drive:[filename.xls]' portion of the name (which obviously needs conversion to UNIX format) or (b) whether it fails to properly perform the Definition (or cell) lookup in the filename.xls namespace. This is a significant problem for people working with a number of spreadsheets which have complex cross-spreadsheet name define references as it prevents them from directly transferring a set of spreadsheets from Excel to Calc. Presumably there has to be some cleverness in the name resolution process as one could imagine circular references that would put the lookup process into infinite loops. I do have available a complex set of spreadsheets which use this feature which can be used to test whether the problem has been fixed. --------------------------------------------------------------------- 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]
