Results 1 to 8 of 8

Thread: Calc hangs when I try to get external data

  1. #1

    Default Calc hangs when I try to get external data

    I have tried to get external data form numerous websites in calc,
    When I insert the web address into the box for URL of external data source my calc document hangs.
    I am trying to download sports results into my calc document from
    Code:
     http://www.bbc.com/sport/0/football/26998951
    http://www.sportinglife.com/racing/results
    I queried with libre to see if there was a problem with their software but they replied that it works fine in Debian & Ubuntu.
    I let the query run over night last nigh & my calc document was still hanging this morning & I hadn't received an error report.

    Is there a way for me to retrieve an error report when the document hangs?

    I am running opensuse 13.1-X86- 64 bit
    Version: 4.1.5.3

  2. #2

    Default Re: Calc hangs when I try to get external data

    Quote Originally Posted by Hermes14 View Post
    Is there a way for me to retrieve an error report when the document hangs?
    Sounds like this:
    https://bugzilla.novell.com/show_bug.cgi?id=869715

    Btw, I can reproduce it here. And it makes no difference whether I use the KDE integration or not, so it's not related to that.

  3. #3

    Default Re: Calc hangs when I try to get external data

    I just tried with LibreOffice 4.2 from the LibreOffice:Factory repo and there it worked fine and DID NOT hang.

    So you could install that as workaround:
    http://software.opensuse.org/downloa...ge=libreoffice
    (choose "install xxx (with vendor change)" whenever YaST asks...)
    or
    Code:
    sudo zypper ar http://software.opensuse.org/repositories/LibreOffice:/Factory/openSUSE_13.1 LibreOffice:Factory
    sudo zypper dup --from LibreOffice:Factory

  4. #4
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,144
    Blog Entries
    2

    Default Re: Calc hangs when I try to get external data

    I've posted to the bugzilla my surprise that you can point Calc generally to a webpage with all sorts of stuff in it, and not specifically to the data, eg the HTML table on the webpage(which I've done).

    I didn't know that what these individuals are trying to do might be possible, and so far my admittedly sometimes questionable Google talent can't come up with a tutorial or reference that this is possible. For it to work, some "smarts" in the code has to be able to parse the objects on the webpage and extract only objects with tags that could potentially contain importable data. Then it also becomes a question what happens if the page is comprised of multiple tables, and webpages often use tables for object placement instead of holding data.

    And, that doesn't even start to address the issue that HTML5 is obsoleting tables with its "flowing objects" approach.

    TSU

  5. #5

    Default Re: Calc hangs when I try to get external data

    Quote Originally Posted by tsu2 View Post
    I've posted to the bugzilla my surprise that you can point Calc generally to a webpage with all sorts of stuff in it, and not specifically to the data, eg the HTML table on the webpage(which I've done).

    I didn't know that what these individuals are trying to do might be possible, and so far my admittedly sometimes questionable Google talent can't come up with a tutorial or reference that this is possible.
    AIUI, they are selecting "Insert"->"Link to external Data..." in Calc's menu and enter the URL into the dialog that appears.
    At least that's how I reproduced the hang with LO 4.1.5.3...

    And it works fine with LO 4.2.3.3 here, so it _should_ be a valid operation.

  6. #6

    Default Re: Calc hangs when I try to get external data

    Quote Originally Posted by wolfi323 View Post
    AIUI, they are selecting "Insert"->"Link to external Data..." in Calc's menu and enter the URL into the dialog that appears.
    At least that's how I reproduced the hang with LO 4.1.5.3...

    And it works fine with LO 4.2.3.3 here, so it _should_ be a valid operation.
    Thanks Wolfi it works fine for me aswell in LO 4.2.3.3.

    I would have posted earlier if I had not made a very big mistake.
    When I tried to uninstall LO 4.1.5.3 via bash I typed
    Code:
     sudo zypper rm libre*
    this crashed my machine.
    Once I repaired it I found out that
    Code:
     sudo zypper rm LibreOffice
    removed enough files to install the new version.

  7. #7

    Default AW: Re: Calc hangs when I try to get external data

    Quote Originally Posted by Hermes14 View Post
    When I tried to uninstall LO 4.1.5.3 via bash I typed
    Code:
     sudo zypper rm libre*
    this crashed my machine.
    Yes, I think so.
    When I try to run that on my system, I get:
    Code:
    sudo zypper rm libre*
    root's password:
    Daten des Repositories laden ...
    Installierte Pakete lesen ...
    Paketabhängigkeiten auflösen ...
    
    The following 4162 packages are going to be REMOVED:
     ...
    Not really a good idea to say yes to that...

    Once I repaired it I found out that
    Code:
     sudo zypper rm LibreOffice
    removed enough files to install the new version.
    How did you install it?
    If you install it from the LibreOffice:Factory repo, you _don't_ have to install the old version first.

    For the version from the LibreOffice website, it might indeed be better (or even necessary) to remove the old version first though.
    Last edited by wolfi323; 21-Apr-2014 at 13:50.

  8. #8

    Default Re: AW: Re: Calc hangs when I try to get external data

    Quote Originally Posted by wolfi323 View Post
    Yes, I think so.
    When I try to run that on my system, I get:
    Code:
    sudo zypper rm libre*
    root's password:
    Daten des Repositories laden ...
    Installierte Pakete lesen ...
    Paketabhängigkeiten auflösen ...
    
    The following 4162 packages are going to be REMOVED:
     ...
    Not really a good idea to say yes to that...

    How did you install it?
    If you install it from the LibreOffice:Factory repo, you _don't_ have to install the old version first.

    For the version from the LibreOffice website, it might indeed be better (or even necessary) to remove the old version first though.
    I found out too late that there is a big difference between Libre & LibreOffice.
    I downloaded the package form the Libreoffice website & installed it.
    I have never used the LibreOffice:Factory before but I definitely try it next time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •