To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114504 Issue #|114504 Summary|SMB external references are not working Component|Spreadsheet Version|OOO330m7 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|sbosio
------- Additional comments from [email protected] Tue Sep 14 23:14:20 +0000 2010 ------- When inserting references to external cells using a "file:///..." link type, there are no problems, but if you use a "smb://host/..." link type, referenced values get lost when re-opening the files. I was making some tests on this problem, and get confused about what is getting exported to "content.xml" when using "smb://host/..." links: First, using "file:///..." external links only a copy of the referenced cells for the referenced sheet is saved on a hidden table that has a name equal to the absolute reference for that sheet. Things works as expected and you can update the referenced data. When using "smb://host/..." external links, values are lost after re-opening the file. All cells with SMB external references show a #NAME? error. When updating, a backup copy of the full referenced sheet get saved as a hidden table. They get names like: "Table", "Table2", ... and so on each time you update the references. And updating doesn't solve the #NAME? errors. You should edit the content using F2, making some movement using the cursor keys and pressing ENTER for the correct value to be visible again. When you have manually edited each cell with external references for the values to show up again, and after saving, you get two tables with the same name (the absolute URI of the referenced sheet) which I pressume should be invalid on that context. One of them has a full copy of the sheet, and the other one only has the referenced cells. I'm using relative links for saving. I have not tested this with absolute references. Best regards, Santiago Bosio --------------------------------------------------------------------- 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]
