Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

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