Lakin Wecker wrote:
I assume these discrepancies are the result of caching formula results.
The assumption is that Excel stores the previously calculated results of
the formulae in the spreadsheet and uses these values at load time,
while OO.o ignores these and fully recalculates the formulae on each
load? I haven't been able to find concrete proof of this, can anyone
confirm this is the case? I tried looking for an option to force OO.o to
use more disk-space and save on load times. I found: "Size Optimization
for XML Format" and un-checked that option, but did not notice much of a
difference(9k in file size, nothing for load times).
According to someone on the [email protected] mailing list, OO.o does
indeed cache the formula results. If this is the case, then something
else is going on.
Excel files are recalculated after loading because we can't guarantee
our results will be exactly the same in all cases.
Our own files are recalculated to allow external editing of the files.
Someone can change a formula in the file, not caring about the stored
result, and be sure the changed formula's result is shown.
I'm curious to know if there are plans to address this for the 2.0
release? If not, I am willing to put in some work on this, but would
need some direction as to where the relevant processing takes place.
To clarify this point: I'm more interested in whether this is a known
issue. If not, I don't mind doing some profiling and digging to find
out what is the problem. I just don't want to waste any time on
something which is already being worked on, and/or finished.
Generally, load/save performance is an area that is being worked on. But
there are many different possible causes for slow loading of files. It
depends on the content of the files. Also, loading of our own files and
Excel files is quite different. Recalculating the formulas might be the
problem in your case, but it doesn't have to be. Most performance
problems with Excel files are currently due to charts. Are there any
charts in your files?
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
