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


Hi :)
It does seem like an usually huge file-size.  150 kb would be more normal!

There is a "memory" setting that might be useful to increase quite
dramatically.  From the "Tools" menu;

Tools - Options - Memory

You can see the settings are mostly all very low so that people can
easily use LibreOffice on very low-spec machines.  Modern desktops and
laptops have plenty of Ram these days and i'm guessing you are not
using a tablet or phone so you can radically increase most of those
values.  I tried bumping the "used by LibreOffice" one up from around
10-20 Mb to about 200 Mb.  I think the maximum value is 256 Mb because
when i tried higher values they got reduced to 256 Mb.  I usually
reduce the number of steps it can undo because 100 usually takes me to
waaay before my last back-up.

If the file really is Mb instead of just kb then is it due to having
lots of images and art?
Regards from
Tom :)





On 13 November 2015 at 19:27, Joel Madero <jmadero.dev@gmail.com> wrote:
On Fri, Nov 13, 2015 at 7:52 AM, ammorei <ammorei@gmail.com> wrote:

Good afternoon!

I have a spreadsheet in '.xlsx', with a size around 150Mb and containing
+/-
400000 lines.


I have never seen a 150 mb functional spreadsheet before. I'd like to see
the file because I'm relatively sure that a database is what is
needed (especially if there are a ton of functions in it and nested ifs)

I would recommend trying to open the file and leave the computer going over
night. The issue is that LibreOffice has to use xlsx filters to open the
file, this is going to be slow when you're talking about 150 megs. Open the
file over night, save it as an open document format (ods) and I suspect it
will be quite a bit faster.

But, again, I bet that file needs to be a database and not a spreadsheet...


Best,
Joel
--
*Joel Madero*
LibreOffice QA Volunteer
jmadero.dev@gmail.com

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

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.