Without the spreadsheet there is nothing we can do for you. Sorry. I suggest converting it to open standard (ods) and seeing if that helps. Otherwise, there's really not much more we can do without seeing the sheet.
Best, Joel > 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: ammo...@gmail.com <ammo...@gmail.com>* > > 2015-11-13 19:08 GMT-03:00 TomD [via Document Foundation Mail Archive] < > ml-node+s969070n4166258...@n3.nabble.com>: > >> 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: 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
