do you save it as *.ods or as *xls?

Iám save the file as *.ods

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?

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.

Experience kind of slow save of .ods document compared to version 3.0 on ubuntu
jaunty. The document is 1.1 mb in size.

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
~5secs.

Why saving .ods files keeps more time? Is it possible to increase the speed of
opening & closing .ods files?

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.

Created attachment 63922 [details]
sample ods file 1,2Mb

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

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

*** Issue 101942 has been confirmed by votes. ***

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

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.

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.

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
question
 

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

 


Questions:

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