To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44292 Issue #:|44292 Summary:|Links to named cells or ranges in other files not |possible?? Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|code Assigned to:|spreadsheet Reported by:|gunamoi
------- Additional comments from [EMAIL PROTECTED] Sun Mar 6 23:32:36 -0800 2005 ------- OpenOffice.org Calc lets you assign names to individual cells or cell ranges. Aside from making formulas easier to read, this feature allows you to still refer to the correct named cell even if rows or columns are inserted. Even after you insert or delete rows or columns, OpenOffice.org still correctly assigns the ranges identified by name. The defined name works for all sheets in a file, so for example if the name 'total' is defined as '$Sheet1.$A$1', then when you insert a formula in Sheet2 such as "=total" the result will be the number from the nmaed cell in Sheet1. All this is good and seems to work as it should. But what happens when I wish to refer to a named cell in another file? Calc allows me to reference a cell in another document. But the reference must be by address (e.g. ='file:///file1.ods'#$Sheet1.$A$1). Then if you edit File 1 and say add a row at the start, the reference in File2 will be wrong!!!!! Why do references to cells in another file not recognise names in that other file? e.g. surely it would be acceptable to reference the named cell like this: ='File:///file1.ods'#total ????? I have raised this issue previously for version 1.1.0, and was told it would be fixed in version 2.0. Has a decision been made not to allow reference to named ranges in other files? or is it still coming in a future version? 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]