Have tested various configurations in relation to memory, yet still does not work.
Adriano Moreira * Att,Adriano Martins MoreiraCel.: 82 8177-4885 (VIVO)Cel.: 82 9945-8803 (TIM)e-mail: [email protected] <[email protected]>* 2015-11-13 19:08 GMT-03:00 TomD [via Document Foundation Mail Archive] < [email protected]>: > 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 <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=4166258&i=0>> wrote: > > > On Fri, Nov 13, 2015 at 7:52 AM, ammorei <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=4166258&i=1>> 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 > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4166258&i=2> > > > > -- > > To unsubscribe e-mail to: [hidden email] > <http:///user/SendEmail.jtp?type=node&node=4166258&i=3> > > 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: [hidden email] > <http:///user/SendEmail.jtp?type=node&node=4166258&i=4> > 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 > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://nabble.documentfoundation.org/Large-spreadsheet-does-not-open-in-LibreOffice-tp4166243p4166258.html > To unsubscribe from Large spreadsheet does not open in LibreOffice., click > here > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4166243&code=YW1tb3JlaUBnbWFpbC5jb218NDE2NjI0M3wxOTUzMDUxMzYz> > . > NAML > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://nabble.documentfoundation.org/Large-spreadsheet-does-not-open-in-LibreOffice-tp4166243p4166497.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] 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
