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

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

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

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 :)


On 7 November 2013 05:44, Denis Navas Vega <> 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

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

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.
Sent from the Users mailing list archive at

 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.