Hi :) I think so. I have no idea how to do that though. Which OS are you using? Is it a version of Windows? Xp, Win7 or something? Regards from tom :)
On 14 November 2015 at 11:20, malcolm <malc...@interele.demon.co.uk> wrote: > 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 > -- 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