Calc suddenly very slow on loading

users
#1

Hi,

I have an ods file with about 1800 lines and 25 columns. In each line
there are about 50 hyperlinks (they are links to web or local files - I
have two versions of the document).
Until recently (two weeks ago), LO was able to open it in a second or
two, and I was able to work with it normally (adding columns, sorting etc).

Suddenly everything has changed - loading takes about 10 minutes and
then no work is possible, since the response is horribly slow. I have
several versions of LO installed and I am sure that the 4.3 an 4.4.0
versions were OK.
Recently, I have upgraded 4.4.0 to 4.4.1 and installed 4.5 alpha. What
surprises me is that also 4.3 is slow now and removing of 4.4.1 and 4.5
does not change the situation.

I am using Ubuntu 14.10. I suspect that the problem is somewhere outside
LO.
A version of the document without the hyperlink loads instantly, so the
problem resides in them

Do you have any idea?

Thank in advance
Milos

#2

Hi all:

  I think it would be because you have low memory asigned for your big
spreadsheet. I suggest this:

1) Menu
2) Tools
3) Memory

There you find some topics where you can increase the memory that Libre
Office use for the program. If you increase them your Libre Office able
to manage more data and information in each spreasheet.

I hope this help you

Regards,

Jorge Rodríguez