Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

edit

I too experience slow loading/saving in Calc 3.6.4.3 and this seems to be directly related to document size. For example, a document with 13 worksheets ranging from a few to 550 lines takes much longer to load/save than a document with fewer sheets. MS Office is lighting fast with both. I must stress that all documents are now ODS converted from XLS. My system is i7, 4GB RAM and an SSD (!) and all of this makes no difference.

I found a temporary workaround that improved the performance from 40 seconds to 1 second or less in my case, read more at http://ask.libreoffice.org/en/questio...

It is known to some people that OpenOffice.org struggled to catch up with MS Office speed and functions.

I knew it, but I didn't consider its a big issue as of opening speed, it won't be too long as startup.

However, I concern any lags during processing, and I heard that "LibreOffice would be slower if the current code base do not change" or something like that after read mail-list and some articles.

where Excel vs Calc: calc do not support over 1024 columns. where Word vs Writer: writer do not support over 65534 characters.

The user have their right to say "no" b/c the 2 feature above; I could laugh at them tolerated a office suite that style nearly do not exist.

Same or Different.

Take a look to the settings in: Menu/Tools/Options/LibreOffice/Memory

Hi guys,

I have made some time trails myself and see the time differences. The test only uses two files that are the same in content. The ods file is 3.2MB saved in Calc and the xlsx file is 3.9MB saved in Excel, you can see that ods is even smaller than the xlsx.

Program is still close

LibreOffice 3.5.6.2 Calc

• ods: 14.5 sec
• xlsx: 16.8 sec

Microsoft Excel 2010 (Trial)

• ods: 4.6 sec
• xlsx: 2.8 sec

Program is already open

LibreOffice 3.5.6.2 Calc

• ods: 11.8 sec
• xlsx: 16.2 sec

Microsoft Excel 2010 (Trial)

• ods: 3.7 sec
• xlsx: 1.5 sec

My OS is: Microsoft Windows 7 Home Premium x64 Laptop Specs: Intel i5-2430M, 8GB RAM, nVidia Geforce GT540M Cuda w/ 2GB

You should tell us what version of LibreOffice You use. E.g. Calc 3.5 import native files (.ods) faster approximately about from 86% to 90%.

http://kohei.us/2011/11/30/performance-improvement-in-opening-ods/

Hello, Same observation here. I need to do the following- 1) Data is organized in single column A 2) I have to select some rows at a time copy them and transpose then in column B in order to split that in columns. I have created a macro for this. At a time, i select about 15 rows. The macro execution takes about 2 seconds to execute completely. Same file, same macro on Excel, its instantaneous. Details of the File as follows - Note- the file has been created in Excel saved in XLS format. Converting it to XLSX makes no difference. 1) File size ~55MB 2) Number of sheets - ~30 3) Rows per sheet - ~10500 Saving the file in Calc takes > 5 minutes. Till the files is completely saved, cannot use any other LibreOffice tool. Saving the same file on Excel is within a minute at the most. Strange thing observed, the macro execution becomes a little faster when I am charging the laptop. Please let me know if any more information is needed. I can attach the file required. Thanks.

I am finding the same problem, but with Writer.

I run LibreOffice on OpenSuse 12.1 X64, so I don't think this is problem is specific to the Windows version, although it could be something to do with X64.

At first I thought it could be a problem about exporting to .doc format, as I happened to be working on a Word document. So I saved it as .odt and it still takes about 20 secs per save. I'm not sure how long it was taking before, using LibreOffice 3.4.5, but I have a habit of pressing Ctrl-S every few seconds, and it was saving seamlessly, so I'd guess no more than a couple of seconds.

It's not a particularly large document - the odt file is only 130KiB (the doc version was 1.4 MiB). It is a single table covering about 70 pages, but there are no graphics in it.

I just tried a larger document (1.5 MiB, 59 pages with a lot of complex graphics) and saving that took over 40 secs.

Finally I tried starting a new document, typed a couple of sentences in it and saved. It took only a second or so, but if I remember rightly, previously, this would have seemed instantaneous.