[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Mon Apr 5 14:22:11 + 2010 --- worksforme -> closed - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 User rainerbielefeld changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from rainerbielef...@openoffice.org Fri Apr 2 06:52:13 + 2010 --- No answer from reporter, test file does no longer exist, closing issue due to reporter's inactivity as WFM. - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' Keywords| |oooqa --- Additional comments from rainerbielef...@openoffice.org Thu Mar 25 05:11:34 + 2010 --- Issue 103964, that might be related to this one, is no longer reproducible starting with 3.1. @tasker: Any news? - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 --- Additional comments from tas...@openoffice.org Fri May 8 21:49:58 + 2009 --- I have subsequently tried linking my spreadsheet to a table on an html page located on a server on the internet. Again it works when you initially set it up, but the link is to a copy of the html page stored in the Temporary Internet Folders cache. When OOo is asked to Update, it uses the copy in cache and does not force Windows to refresh the copy in cache first. I understand that it is normal Windows behaviour to download any internet file to cache before opening it, but there must be a way for OOo to force the cache to refresh other than by recreating the link. Excel manages it OK. - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 --- Additional comments from tas...@openoffice.org Fri May 8 14:09:44 + 2009 --- Created an attachment (id=62099) Screenshot 4 - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 --- Additional comments from tas...@openoffice.org Fri May 8 14:08:37 + 2009 --- Created an attachment (id=62098) Screenshot 3 - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 --- Additional comments from tas...@openoffice.org Fri May 8 14:07:02 + 2009 --- Created an attachment (id=62097) Screenshot 2 - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101682 --- Additional comments from tas...@openoffice.org Fri May 8 14:05:22 + 2009 --- Created an attachment (id=62096) Screenshot 1 - 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
[sc-issues] [Issue 101682] Linked sheet not updating from url on remote server
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 + 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
