Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


El 2013-11-20 04:04 a.m., Tom Davies escribió:
Hi :)
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 :)



On 20 November 2013 02:48, Denis Navas Vega <denis.navas@gmail.com> wrote:
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.




--
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

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.



--
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.