To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62335 Issue #:|62335 Summary:|"remember" external sheet reference after deleting |them Component:|Spreadsheet Version:|OOo 2.0.1 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|save-export Assigned to:|spreadsheet Reported by:|rmano
------- Additional comments from [EMAIL PROTECTED] Mon Feb 20 06:35:54 -0800 2006 ------- Hi all, I really do not know if this is an issue or a "driver error". The scenario: open a file with a few data in it (in the attached .tar.gz: to_be_reffed.ods). Save it. Now open another file and put in it a formula referring to the above one (reffing.ods). All ok. Now select the range with the formulas, and to copy-paste special (only string and number). Save it again (loose_ref.ods). My understading is that now the last sheet is independent, no more cross-reference. But if I close it and re-open it, it still says "extrenal reference etc etc". Inspecting a bit, it seems that I have a sheet with a file:/// url as name. I am unable to delete it or select it. (see phantom_sheet.png). Is this supposed to be like that? How can I "lose" the references completely? Thanks, Romano --------------------------------------------------------------------- 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]