Libreoffice 4.1.3.2 slow

users
#1

I've had a number of problems with Libreoffice 4.1.3.2 as compared with 4.0.5.

Specifically it seems to be a lot slower, specifically with displaying dialog
boxes and forms. It also seems to be very slugish when trying to resize the
main window.

Sometimes, it seems to hang when displaying a dialog and doesn't display it
correctly, what I see is the outline of the dialog with some of the contents
of it displayed but not all. If I click in the dialog it then fills in the
missing contents.

Has anyone else experienced this?

My hardware is 10 years old - Pentium 4.

Alex

#2

Hi :slight_smile:
Can you defrag? Sometimes after installing something it's not very
streamlined and a defrag sorts it out a bit.

However i think it's more likely to be the "memory" settings. if you
open LibreOffice and go to
Tools - Options - Memory

My guess is that you have a lot more Ram and could easily bump the
values up by double or higher. how much ram do you have? If you are
using Windows you can find out by right-clicking on "My Computer" and
then hunt around for the tab that shows your systems specs.
Regards from
Tom :slight_smile:

#3

Hi Tom

I'm on Linux so the defrag is not an issue for me.

If I go back to 4.0.5 speed seems OK.

The slowness seems to be more apparent when loading forms in Base.

I'll look at the memory.

My machine is old I've always been more cpu bound than memory bound.

As no one else has replied with the same issue, it's looking like it's just
me.

Alex

#4

It is slow opening a 42 MB calc file; last 10 min.

It is slow too, specifying a crosstab table.

I don't know if the previous version could be faster than the actual version, but it speed is impractical.

#5

It is slow opening a 42 MB calc file; last 10 min.

It is slow too, specifying a crosstab table.

I don't know if the previous version could be faster than the actual version, but it speed is impractical.

#6

Hi :slight_smile:
42Mb is extremely large for a spreadsheet.

1. Perhaps try using Gnumeric instead? It's a dedicated spreadsheet
program so it is streamlined specifically for dealing with
spreadsheets and doesn't have to worry about any of the other
apps/modules taking up resources
https://projects.gnome.org/gnumeric/

2. Do you have a lot of embedded images or anything like that?
Perhaps link to them instead of embedding them? If you do then it
might be best to put the file in a folder of it's own and then put a
short-cut to it where-ever you currently have the file. Then all the
images can be in the folder with it, or copies of them, so as to make
it easier to keep track of the images.

3. Are you using the spreadsheet as a database? It can be a good way
to start off but you have long past the point where you need a proper
database. You will find the total file-size probably drops
dramatically when you do move it. To start with you might find it
easiest to use Base to read the existing spreadsheet but it would be
better to start moving all that data into a more suitable back-end.

4. In LibreOffice have you changed the "memory" settings yet? If not then
Tools - Options - Memory
and dramatically increase pretty much everything in there. I usually
go as high as 20Mb for most things but occasionally go much higher.
You might need more like 60Mb. Perhaps reduce the number of steps you
can undo. 100 is possibly excessive so perhaps drop that to 50?

Just to help other people give better answers please let us know what
Operating System you are using. Is it one of the Windows ones? Also
it might be interesting to know how fast your cpu is and how much Ram
you have although these last 2 facts probably wont help us help you.
Regards from
Tom :slight_smile:

#7

Gnumeric can't handle this size too.

Yes, it is a lot of data, that corresponds to 126,000 records with 230 columns.

I am using windows 7.

The point, more than the size, is that at those sizes, calc loses quickly its responsivenes.

This is just to inform that Calc has limitations.