Richard Detwiler wrote:
Nick Whitehead wrote:
I have just installed Open Office 2.3.0 (never having used it before)
and am basically very impressed.
However one thing that is an issue is calculation speed vs. Excel. I
have a fairy large (7.8MB) Excel spreadsheet, some thousands of lines.
In Excel it loads pretty much instantly. In Open Office Calc it (a)
loads slower, but worse (b) is very slow to calculate as part of the
load. If it is then saved as an Open Office native format spreadsheet,
it loads and calculates a bit faster (file size drops dramatically), but
is still probably an order of magnitude slower than Excel.
The Excel version is pretty old - Office '97.
Is this normal? Is there anything I can do about it?
Nick: Others wiser than I am can probably comment in more detail, but
from other reports that I have heard, your experience is not unusual.
With very large spread sheets such as yours, there have been studies
that have shown that OpenOffice Calc is slower than Excel, sometimes
by quite a bit. With more typical sized spread sheets, it's not a real
noticeable issue.
(I'm cc-ing you on this reply because you appear to be unsubscribed.
Please direct any additional responses to the list at
[email protected], and not to me personally. Thanks.)
Does your spreadsheet do mostly arithmetic in the cell formulae, or are
there any calls to higher math functions?
I ask because it is well known that Excel, even up to recent versions,
has some uncomfortable inaccuracies in many of the special functions
(things like Gamma and Bessel and the various stats distributions) and
even some of the elementary math functions (trig and log stuff, etc.). I
find that OOo seems superior in many ways respecting a few of such
functions I checked out. So the trade off for slower speed may be better
accuracy.
Les
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
