Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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: ammorei@gmail.com <ammorei@gmail.com>*

2015-11-13 19:08 GMT-03:00 TomD [via Document Foundation Mail Archive] <
ml-node+s969070n4166258h19@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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.