Re: [libreoffice-users] Loading and Saving in Calc is too slow

Hi :)
At 4Mb the file sounds quite large.  Perhaps ramp-up some of the values in

Tools - Options - Memory

Is java involved at all?  Is Calc doing read/writes to a database?  If you look in 

Tools - Options - Java

and check which version of java you are using that can sometimes make a difference.  The 6u21 was 
the best.  After that the versions were increasingly problematic for LibreOffice.  Java is written 
by a competitor.  Well, they seem to see themselves as competitors.  The _20 and _22 were quite 
good but _21 was/is the best.  

Regards from
Tom :)

--- On Thu, 24/11/11, Johnny Rosenberg <gurus.knugum@gmail.com> wrote:

From: Johnny Rosenberg <gurus.knugum@gmail.com>
Subject: Re: [libreoffice-users] Loading and Saving in Calc is too slow
To: users@global.libreoffice.org
Date: Thursday, 24 November, 2011, 18:16

2011/11/23  <pedro.nunes@mail.autoindustrial.net>:
> Hello,
>
>
>
> I use various excel files (around 4mb in size), that open instantly in
> excel, but when converted to ods file format, Calc takes too much time to
> open/saving these same files.
>
> The reason I converted the files to ods, is because I need that those file
> are shared by various users who use calc (this function doesn't seem to be
> available in Calc using the xls file format).
>
>
>
> Is there a way to speedup the loading/saving time of large soreadsheets in
> Calc?

The ODS file format is by nature slower than that very old Excel
format. XLS files are binary files, kind of like a memory dump, which
is very fast but has other disadvantages. An ODF (ods, odt and more)
on the other hand, is a zip file containing a few XML files, folders
and things like that. So every time you need to save or load the
document, it will first be extracted, then all the different files is
explored and so on. I guess those things take quite a lot more time
than just reading or writing a binary file.

So the only thing you can do about it is probably to get a faster
computer and things like that…


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


> Im using LibreOffice 3.4.3 on Windows XP Pro SP3 / Windows 7 Pro machines.
>
>
>
> Thanks,
>
> Pedro Nunes
>
>
> --
> For unsubscribe instructions e-mail to: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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