On Mon, 2005-29-08 at 10:47 +0200, Niklas Nebel wrote: > 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.
Interesting to know. I can understand why the excel files are completely recalculated. In an environment like ours, where external editing of the files will not happen, it should be possible to have a checkbox asking if they want to recalculate the results on each load? > >>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? No charts. The spreadsheet that I talked about, (specifically, spreadsheet #1) is about 3 worksheets of 4000 rows, and 125 columns, and 1 worksheet with maybe 25 cells filled in. Lakin > Niklas > > --------------------------------------------------------------------- > 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]
