Re: [libreoffice-users] Calc worksheet stalls when opening. Solved!

I opened them in a browser, which, if everything was working correctly,
should not be different from the point of view of the server, meaning it
should provide the requested files to both. And I copy/pasted a page from a
website containing linked images into a calc file, which closed and
reopened just fine.
Now, I can't link these image specifically, as Calc just won't paste them
at all if they are not on a "complete" page (which is weird in itself).
Maybe there's something in the image format, or the fact that it's https,
that Calc just don't like. Saldy I can't test this extensively.

2014-03-14 12:26 GMT+01:00 William Drago <wdrago@suffolk.lib.ny.us>:

> Did you try embedded those images in a LO spreadsheet to see if they load,
> or did you just open them in your browser?
>
> -Bill
>
>
> On 3/14/2014 7:00 AM, Cley Faye wrote:
>
> > 2014-03-14 11:41 GMT+01:00 William Drago <wdrago@suffolk.lib.ny.us>:
> >
> >  All,
> > > I tried Tom's suggestion and opened the file with Gnumerics. This awesome
> > > little program opened the spreadsheet and let me know what was wrong with
> > > it:
> > >
> > > Unable to load the file 'https://retiretxn300.
> > > fidelity.com/images/savings2/alert.gif'.
> > > Unable to load the file 'https://retiretxn300.
> > > fidelity.com/images/savings2/alert.gif'.
> > > Unable to load the file 'https://retiretxn300.
> > > fidelity.com/images/savings2/alert.gif'.
> > > Unable to load the file 'https://retiretxn300.
> > > fidelity.com/images/savings2/alert.gif'.
> > > Unable to load the file 'https://retiretxn300.
> > > fidelity.com/images/savings2/alert.gif'.
> > > Unable to load the file 'https://retiretxn300.
> > > fidelity.com/images/savings2/alert.gif'.
> > > Unable to load the file 'https://retiretxn300.fidelity.com/static/
> > >
> > > netbenefits/common/images/nb_footer_logo.gif'.
> > >
> > > At one time I had copied & pasted some information from my retirement
> > > account into the spreadsheet. Unless I'm logged into my Fidelity account,
> > > none of these URLs will work.
> > >
> > > Now I have 3 questions:
> > >
> > > 1) Why doesn't LO tell us what the problems are like Gnumerics does
> > > instead of stalling for 20 minutes or more?
> > >
> > >  ​Not sure, maybe he is just trying to open them.​ But these images load
> > fine without being logged anywhere (I can see them), so I'm not sure that
> > the problem is there. It might be related to another resource on internet
> > anyway.
> >
> > 2) Why is the timeout period so long? 20 minutes? Really?
> > ​My previous statement kinda invalid the idea of a timeout (unless the
> > website was down all the time you tried to open the file...). But if the
> > issue lies in Calc behing unable to open a file with https links, the
> > ​timeout "per file" isn't insanely high: 2-3 minutes is a fairly
> > reasonable
> > value to accomodate with dead-slow connections.
> > But since the images load correctly... moot point :(
> >
> >
> >
> >  3) When we copy & paste a webpage why is LO storing links to images
> > > instead of the actual images?
> > >
> > >  I believe it's by design: it is not always desirable to create multiple
> > copies of the image source; especially if it's not a static image, that is
> > used to convey "updated" informations for example; or if you are working
> > on
> > a document where graphic designers can update their work, put placeholder
> > in places, etc. In this regard, it keeps the URL as the image source as it
> > would keep the abolute file path from a file source.
> >
> > Note that you can see and "kill" these links by going in the Edit menu:
> > Edit->Links. There you can select all links and hit "Break Links".
> > If the issue lies in Calc loading a file with linked images on the web,
> > this can avoid the issue (given you do it before saving, of course).
> > However, since these links are publicly accessible, a failure to load them
> > by Calc is likely a bug if it is confirmed.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted