Can you change that for all users ? Ta
Mal On Friday 13 Nov 2015 22:07:01 Tom Davies wrote: > 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....@gmail.com> wrote: > > On Fri, Nov 13, 2015 at 7:52 AM, ammorei <ammo...@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....@gmail.com > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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