Hi :) 2 possible ways to make it go faster Toolos - Options - Memory and just ramp everything up that looks vaguely relevant. I tend to take things up to at least 20Mb but perhaps even higher like 200Mb might be better.
Also which format are you using? If native Ods then that should be a lot faster and better than MS's formats and especially better than the one with X on the end, such as .XlsX Third is to use a dedicated spreadsheet tool for hefty jobs like that. Gnumeric knocks the spots off Excel and leaves it far behind in your rear-view mirror. Again it's best if using it's native Ods format that is also native to LibreOffice. However even if your file is in XlsX then Gnumeric can still open it https://projects.gnome.org/gnumeric/ It's not particularly unusual to have MS Office, LO (or AOO) and Gnumeric all on the same machine, perhaps with Scribus or some other proper DTP in addition. Office Suites are meant to be a "jack of all trades" but not necessarily master of any. While Writer and Draw are more like DTPs than Word they are still not dedicated to that sort of thing and getting a proper tool such as Scribus or some LaTeX package takes it to the next level. Similarly with Gnumeric. It doesn't have to worry about side-issues so it can focus on purely spreadsheet functionality. Non-OpenSource tries to make 1 monolithic program to do everything but in OpenSource world we are more into the idea of having different specialist programs co-operating with each other. LibreOffice is quite unusual in that regard because it combines several different sorts of things but that usually works out superbly in LOs case. However, there are times when it's best to find the specialist tool instead Regards from Tom :) H On 7 November 2013 05:44, Denis Navas Vega <[email protected]> wrote: > El 2013-11-05 05:51 p.m., Pedro escribió: > >> krackedpress wrote >> >>> The next thing people will insist on is LO being designed to run on all >>> 2, 4, 6, or even 8 cores of the CPU at the same time to make it even >>> faster. >>> >> >> Do you really think it makes sense that Calc and Base are not prepared to >> use all the computing power available? >> >> Why do you think TDF and AMD are trying to bring GPU calculation to LO? >> Because Calc (I haven't even tried Base...) is absurdly slow! >> >> A heavy calculation spreadsheet I have takes 50 "seconds" to open in Excel >> 2010 and takes more than 10 *minutes* to open in Calc! (both 32bit >> versions) >> >> No wonder Kohei Yoshida (one of, if not *the* main Calc developer) said >> recently (August 2013): " You can’t compare Calc with Excel yet. They are >> still miles ahead of us." >> >> When Calc is able to use all cores and threads and eventually 64bit >> operations then it might be on par... >> >> Why do you assume the OP isn't doing number crunching? >> >> >> >> -- >> View this message in context: http://nabble. >> documentfoundation.org/64-bit-tp4081444p4081605.html >> Sent from the Users mailing list archive at Nabble.com. >> >> I won't insist on 64 bits, because I use machines that work on 32 bits, > but the affirmation that Excel is more faster than Calc is true. I have > been working the last six weeks with databases from a census, and can > confirm the following: > > -- Calc is really slow with lots of data. When the book requires more > than 384 MB of memory, it slows down to an impractical speed. Days ago, I > spent the whole day building a crosstab. > > Open/Save is really slow and does not help a different file format to > speed up things. > > Another difficult thing, is with sorting and filtering. Is slow too. > > > > > -- > 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 > -- 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
