Issue 101942 - save and open file too slow
Summary: save and open file too slow
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.1
Hardware: PC All
: P3 Trivial with 11 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: performance
Depends on:
Reported: 2009-05-15 07:56 UTC by vlbouw
Modified: 2013-01-29 21:43 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sample ods file 1,2Mb (1.12 MB, application/vnd.oasis.opendocument.spreadsheet)
2009-08-02 15:56 UTC, vlbouw
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description vlbouw 2009-05-15 07:56:31 UTC
When i have a big file from 1,5 Mb and i open or save the file, take the time in
openoffice +/- 24 sec. and when i save or open it in excel is the time 1 sec.

This is happen on more pc's.

Is it possible the time for saving and opening file's make it faster?
Comment 1 Mechtilde 2009-06-04 13:52:39 UTC
do you save it as *.ods or as *xls?
Comment 2 vlbouw 2009-06-04 17:32:51 UTC
Iám save the file as *.ods
Comment 3 Mechtilde 2009-06-09 20:46:00 UTC
this is a very very big *.ods file with 1.5 MB

so I'm not supprised how long it takes. Does it contains many charts?
Comment 4 vlbouw 2009-06-09 20:56:03 UTC
The file have many data and formula.
I'm not be glad of this, because when i'm use it in excel this is than very fast.
Is it possible that this make faster for openoffice, when this is possible it is
a very improvement for openoffice.
Comment 5 tmstaedt 2009-07-08 20:48:02 UTC
Experience kind of slow save of .ods document compared to version 3.0 on ubuntu
jaunty. The document is 1.1 mb in size.
Comment 6 taro1 2009-07-16 12:07:10 UTC
I have experience with 400kB .ods file (there is no extra in it, such chart,
pivottable or so) on WinXP (OOo310m14). Opening time ~5secs, saving time
~10secs. During save it hangs up the spreadsheet, cells cannot be edited/used.

Second file is about 1,5MB .xls file (containing the same data, than the
previously mentione .ods file). OOo opens it during ~3secs and saves it during

Why saving .ods files keeps more time? Is it possible to increase the speed of
opening & closing .ods files?
Comment 7 ooo 2009-07-17 15:34:18 UTC
Loading/saving binary file formats such as .xls ususally is always faster than
XML based formats because of the file structures used. Loading/saving .xls
within Excel if of course even faster because the binary file structure
resembles more Excel's memory layout of the model.

We were doing various load/save performance optimizations in recent milestones,
but without the sample file attached to this issue we can't tell whether it
would benefit. You might want to try yourself using, for example, the DEV300_m52
developer milestone build.

Unless there's a sample file attached to this issue I'd tend to close this issue
because it is too unspecific.
Comment 8 vlbouw 2009-08-02 15:56:41 UTC
Created attachment 63922 [details]
sample ods file 1,2Mb
Comment 9 monty241070 2009-09-16 15:41:22 UTC
We have the same problem with a number of rather simple ods. The biggest one is
1.034 Kb.

Opening takes up to 1 minute and saving to. Tested on XP and W2K3 with plenty of
RAM (at least 4Gb) and multiple CPUs.

I am very sad to say that we have needed to move part of the larger ods already
to Office 2007, since OpenOffice Calc could not save them in a few minutes.
Therefore, I would like to propose to raise the priority to P2 or higher.

I think many other sites are having problems with this, especially when a look
at the typical excel sheets in my line of business (financials). Sheets larger
than 3 Mb are not rare.

I can send example by email to developer (it contains intellectual property data).
Comment 10 janve 2009-10-15 22:11:22 UTC
Dear reader,
ODS files are incredidable slow to open and to save them compared to MS Office 2007.
I find this really a pity and forces me to convert my files to MS Excel.
I seriously hope it's possible to do something about the speed. How can this not
be a big issue????

Regards, Jan
Comment 11 phoinv 2009-10-16 07:30:40 UTC
*** Issue 101942 has been confirmed by votes. ***
Comment 12 vitusp 2010-02-15 14:59:51 UTC
Same problem here! We do data gathering from large xls-files (1.5 to 3 MB) on a
Linux server using OOo calc (many thousands xls files) and feed the extracted
csv-data into a database.
But now may be getting forced to change to a Windows environment ;-( due to very
poor performance.

E.g.: xls sample file (2.5 MB, no charts - only formula and text, 3x ~30k jpgs)

Some Benchmarks (opening the xls until content is visible/usable; no macros

OOo 2.4, Ubuntu 8.04 LTS (Xenon multicore cpu, 8MB RAM): 10+ MINUTES
OOo 3.1, Ubuntu 9.10 Desktop (AMD multicore, 4GB RAM): 8 to 15 minutes (time
varies with the same testfile!?)
OOo 3.2, Ubuntu 9.10 NBR (Asus Eee PC 1005H, 2GB RAM): ~3 minutes
(=> OOo 3.2 is ~3x faster here than 3.1, even on an very small computer)

M$ Excel (Office 10/XP), Win XP, (Laptop 1.2Ghz cpu, 1GB RAM): 3-5 seconds
M$ Excel 2004, OS-X, (MacBook Pro 2.5Ghz, 4GB): 10 seconds

Performance gap OOo Calc : Excel (Minutes vs. Seconds!) =~ 200 : 1

Performance is not dependend on auto_open macros or external file references.
Performance degrades tremendiously if files getting larger.

I am not able to upload a sample file here (customer property), but will be glad
to send one as personal email if needed.

BTW: Out of curiosity i've done a "strace -t -f scalc sample.xls" and have seen
a lot of "Resource temporarily unavailable"-messages, but can't conclude if this
has to do with the performance issues regarding opening large xls-files.
Comment 13 lewiscollier 2010-03-13 19:25:36 UTC
a 17 kByte file takes 11 seconds to save (on both a local drive and a network 
drive). scalc goes to (not responding) state for much of this time.

Fix this please.
Comment 14 nidhi 2010-12-06 10:43:00 UTC
We need some inputs on the performance of open office calc on Solaris:
Please re-direct to the related forum if this is not the right place to ask the

Some background information of our application


In very basic terms our application reads records from database and creates
excel file using openoffice calc


Testing environment1 – Windows + Tomcat  +OpenOffice

Testing Environment2 – Solaris + Websphere + OpenOffice


With 2500rows and 18columns it takes approx 100 secs to write all the cells in
Testing environment1 as compared to 660 secs in Testing environment2



1.       Is there any known limitation on performance of openoffice with Solaris
and Websphere combination

2.       Or this kind of behavior is totally unexpected


We are trying to find why the time taken is so different in both the
environments. We logged time taken by every cell and found that (Initially when
writing the cell- time take per cell is approx 1-3 millisecs.  As the number of
row increases this time taken per cell increases. It reaches up to 15millisecs
per cell at around 2500 row number )


Please let us know if you can give us any pointers for the same

Really appreciate your inputs/help on this