To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 Issue #|101682 Summary|Linked sheet not updating from url on remote server Component|Spreadsheet Version|OOo 3.0.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|tasker
------- Additional comments from tas...@openoffice.org Fri May 8 13:59:36 +0000 2009 ------- This problem appears to be specific to OOo on Windows. Linux users in the community forum do not experience the same problem. I am trying to link a sheet to a tab delimited file accessed through the internet. I create an externally-linked sheet through 'Edit - Insert - Sheet from File' with the 'Link' box ticked. A browse window opens to select the file. I enter the url of the file in the form 'http://www.website.com/folder'file.xls' with filetype 'Text CSV(*.csv;*.txt;*.xls)'. The 'Text Import' window appears displaying data from the source file. I click OK and the 'Text Import' window closes, leaving the 'Insert Sheet' window. The linked file now shown in this window is located on my local hard drive in 'Documents and Settings/User/Local Settings/Temporary Internet Files/Content.IE/F2UIVQCW/file.xls' ie it is a local copy of the file on the remote server. If I click OK on the 'Insert Sheet' window, the data from the source file appears correctly on the sheet. However, when the 'Update' function is invoked, either on reopening the file or through 'Edit - Links - Update' the data on the sheet is refreshed from the copy on the local drive and not from the source file on the remote server. The copy on the local drive is not synchronised with the original source file prior to the update function being performed. The only way I can force a true update is by clicking 'Modify' in the 'Edit Links' window and re-entering the url of the source file ie by recreating the link each time I want to update. Since this behavious does not occur under Linux, I assume it is a defect, rather than an enhancement. I appreciate I could use a program such as WGET to synchronise the local file with the source file outside OOo, but this should not be necessary. This type of linkage to an external text file is very straightforward in Excel. I will attach screenshots showing what I have described. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org