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>