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 <[email protected]> wrote: From: Johnny Rosenberg <[email protected]> Subject: Re: [libreoffice-users] Loading and Saving in Calc is too slow To: [email protected] Date: Thursday, 24 November, 2011, 18:16 2011/11/23 <[email protected]>: > 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: [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 > > -- For unsubscribe instructions 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 -- For unsubscribe instructions 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
