Bug 75701 - FILEOPEN: LibreOffice freezes in Windows 8.1 when open files with http-url
Summary: FILEOPEN: LibreOffice freezes in Windows 8.1 when open files with http-url
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.5.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-03 10:35 UTC by hp4everything
Modified: 2015-02-11 19:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description hp4everything 2014-03-03 10:35:05 UTC
Problem description: 

Steps to reproduce:
1. install LibreOffice on Windows 8.1 64-Bit(patch status up to date)

2. open file "http://ichart.yahoo.com/table.csv?s=%5EGDAXI&a=3&b=3&c=2012&d=1&e=28&f=2014&g=d&ignore=.csv" from behind a router in a private network.


Current behavior:

LibreOffice freezes (no response message from Windows in title bar at least for more than half an hour). Entering the same URL in Firefox almost immediately loads the file with EXCEL, which proves that there are no network or firewall problems.

Loading very small files from webserver in the private LAN (192.168.n.n) takes several seconds, orders of magnitude more than loading the file in firefox 


Expected behavior:

error-free URLs should be loaded in times comparable to Firefox.

Loading should be supervised by timers.

Erroneous URLs or timeouts should be reported to the user in a meaningful way








              
Operating System: Windows 8
Version: 4.1.5.3 release
Comment 1 hp4everything 2014-03-03 12:01:05 UTC
in a second try after about 25 minutes asked for the import parameters for the csv-files. Again after a long time the csv file was opened in the window. But now I'm again waiting after clicking the "File-Menu":  LibreOffice seems to have entered a state in which every user interaction takes about have an hour!!!
Comment 2 retired 2014-03-04 11:20:37 UTC
Is this bug still valid / reproducible with the latest LO release?  Currently 4.2.1: http://www.libreoffice.org/download/

Please also try resetting your user profile and let us know if that helps: https://wiki.documentfoundation.org/UserProfile

Should this be still reproducible for you with the latest LO release please set this bug back to UNCONFIRMED. Should this issue be solved set it to WORKSFORME.

Setting to NEEDINFO until more detail is provided.
Comment 3 hp4everything 2014-03-04 12:12:19 UTC
In the meantime I had the chance to test it on an actuak SuSE-23 Linux distribution with LibreOffice 4.1.4.2 with the same problems !!!!

I'v also your suggestions:

- problem persists after resetting user profile
- problem persists after complete new installation of LibreOffice 4.2.1

But after a lot of trials maybe the error title has to be updated: the problem seems to be the url on Linux as well as on Windows!! Depending on the url LibreOffice freezes for intervals from seconds to half an hour (or maybe even worse?). The whole application freezes including the GUI thread, so it is blocked somewhere outside the message loop. No visible CPU-/disk-/network-activities, so maybe it's waiting for timeouts?

Since the problem appears for me in two completely independent Linux/Windows-systems, I expect that you can also verify it yourself by simply running the following trivial example with different URLs. (the uncommentaed one is the worst!)

BR
Hans-Peter


Sub TryToOpenCsvFromTheInternet
    Dim loadArgs2(1) as New com.sun.star.beans.PropertyValue
    ' this works fast but slower than firefox
    'lurl = "http://192.168.178.9/cgi-bin/mycmd"
    'this works worse, freezes for several seconds
    'lurl = "http://download.finance.yahoo.com/d/quotes.csv?s=%40%5EDJI,GOOG&f=nsl1op&e=.csv"
    'this is the worst case, freezes for nearly half an hour
    lurl = "http://ichart.yahoo.com/table.csv?s=%5EGDAXI&a=3&b=3&c=2012&d=1&e=28&f=2014&g=d&ignore=.csv"
    lsfo = "44/32,34,ANSI,2,"

    loadArgs2(0).Name = "FilterName"
    loadArgs2(0).Value = "Text - txt - csv (StarCalc)"
    loadArgs2(1).Name = "FilterOptions"
    loadArgs2(1).Value = lsfo

    lDoc = StarDesktop.LoadComponentFromURL(lurl,"_blank",0,loadArgs2())
    lSheet = lDoc.Sheets().getByIndex(0)
End Sub
Comment 4 hp4everything 2014-03-04 12:13:32 UTC
sorry, SuSE-13 !! not SuSE-23
Comment 5 hp4everything 2014-03-04 15:38:16 UTC
one additional observation:

when the file eventually is loaded via http-url and displayed in the LibreOffice window, every subsequent user click in the GUI again takes up to half an hour to complete. I've tried opening a menu and quitting the application via windows title bar. 

So the whole message handling of the GUI and/or application seems to be in a strange state.
Comment 6 Cyril 2014-05-03 18:24:18 UTC
Not reproduced with Ubuntu x86_64 LO Version: 4.2.3.3 Build ID: 420m0(Build:3).

I click on the link. Firefox asks for saving or opening file with LO Calc. I chose Calc. Calc dialog asking for separator opens, I choose coma and click ok: .csv files opens quickly.
Comment 7 Yousuf Philips (jay) (retired) 2014-06-08 15:03:21 UTC
Tested on Linux Mint in 4.0.6, 4.1.6 and 4.2.4 and they all open immediately within 5 seconds. Please note that firefox download the csv file and sends the filename to LibreOffice, it does not pass the http url to LibreOffice for it to open it. Are there any other information you can give us so we can reproduce this.
Comment 8 QA Administrators 2015-01-10 18:06:40 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

Message generated on: 10/01/2015
Comment 9 QA Administrators 2015-02-11 19:52:59 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided):

a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. 
Please do not:
a) respond via email 
b) update the version field in the bug or any of the other details on the top section of FDO

Message generated on: 2015-02-11
Comment 10 QA Administrators 2015-02-11 19:59:19 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided):

a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. 

Please do not:
a) respond via email 
b) update the version field in the bug or any of the other details on the top section of FDO
Message generated on: 2015-02-11