Hi Bryce, Jim,
The reason for the long load and save times is that all OOo files are
stored in XML format. Basically, they're text files and must be parsed
and translated to binary each time. MSO saves only in binary format, so
the load time is shorter. The only way around it is to break your file
up into more manageable sections if that's possible, and link the output
of each section into one file.
tc
Bryce Schober wrote:
On 10/26/05, Jim Martin <[EMAIL PROTECTED]> wrote:
Hello All:
I have recently been able to open one of my large (25 meg) excel
spreadsheets in Calc. With help from Daniel Rentz I was able to clean up
a few of the formulas and the whole thing is working (well I have not
tried the macros yet). Anyway, Calc took a LONG time to open the file
and even LONGER to save it (many minutes, I didn't time it because I'm
not that patient). I thought that maybe when I saved it in ODS format it
would go much faster but it did not. These long save times will prevent
me from migrating to Calc.
Is there a trick to working with large files in calc? The same
spreadsheet opens and saves in a few seconds with excel and gnumeric.
Apparently not. I've had similar problems (see
http://qa.openoffice.org/issues/show_bug.cgi?id=1905 ), and they don't
seem to care much. I guess our usage doesn't fit the profile of the
users that they care about...
--
Bryce Schober
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
