To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=3740
------- Additional comments from [EMAIL PROTECTED] Tue Sep 6 18:25:43 -0700 2005 ------- My issue number 44292 was closed as a duplicate of this issue, and similarly a more recent issue number 45705 was also closed as a double. This is NOT just an import/export issue as one responder said. Sure, it comes up as a major problem loading spreadsheets from excel into OpenOffice and basically makes such importing impossible from my perspective, since OpenOffice Calc fails to support properly such a basic function. But even ignoring the excel import issue and considering writing wholly new spreadsheets in Calc without any intention of exporting them it is still a basic need to reference other Calc files, and using named ranges to do this solves many problems which can occur when the referenced file is updated. i.e. when a referenced file is changed, the location of a specific cell may move, say if you have added a new row, but by referencing it by cell number in the second sheet, you will lose the link. However, if you have referenced by name, then it doesn't matter how the cell is moved around, it will still be referenced correctly. There does seem to be a messy work around in OpenOffice using DDE, as I noted in my issue number 44292, which included example attacments. But it would be preferable if Calc performed this function properly. To my mind this is a basic failing in Calc which makes it unusable in my business, not just a nice enhancement. If the funtion works when using DDE, then why cannot the same code be used to make it work for normal referencing or when importing/exporting? Please consider introducing the correct functionality as soon as possible. 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]
