To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84562 Issue #|84562 Summary|links to "external data" done with Excel are not impor |ted Component|Spreadsheet Version|OOo 2.3 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|pagalmes
------- Additional comments from [EMAIL PROTECTED] Fri Dec 14 07:48:43 +0000 2007 ------- In Excel, you can insert in a spreadsheet the result of a request on external data (xls files, Access db...). Such requests can't be updated anymore if you open the file within Calc. I created two documents: - source: it contains the data. - request: is the result of the request on the source file. To reproduce the issue: - try to open the request file. - It asks if you want to update the data - if you answer "yes", even if everything is correct, OOo answers it can't update the data. Thus, this is a compatibility issue... To create the source file: - open an empty sheet in Excel - write some data - select the data - give a name to that data To create the request file: - open an empty sheet in Excel - Tools > external data > create a request... - select "Excel file" - select the file - follow the wizard to define the data you want - and that's it --------------------------------------------------------------------- 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]
