Date: prev next · Thread: first prev next last
December 2012 Archives by date, by thread · List index


On 12/12/2012 01:32 AM, Cor Nouws wrote:
Hi Markus & team ;-)

Markus Mohrhard wrote (07-12-12 22:35)

Since 4.0 we are able to use the cached values written into OOXML
files to prevent a slow recalculation when opening a file. Hoewever
Excel and Calc don't always give the same result for formulas so we
(Eike, Kohei and me) agreed that we need to give the user a choice
wether to recalculate the formulas or not. This is already implemented
[...]

It's not only a matter of speed and not always giving the same results.
Unless I'm misinformed, it's a drastic change in behaviour.

No it's not a "drastic change in behavior". That to me is a gross dramatization of this change. But that's just a difference of opinion I guess.

For the
first time, users are sure they can always (?) open an Excel-sheet and
be sure that what they see is what they get... I mean what they see is
what has been saved.

Yes (if I interpret your wording correctly). The formula results at the time of the last save are what get cached and what get loaded, both in ods and xlsx.

Especially in larger sheets, and those where undocumented or not yet
solved differences in behaviour (reg. arguments or ranges for some
formulae) exist.

I'm not sure I fully understand this sentence, but I'll just say there may be some instances in some corners where the formula get calculated differently, to a varying degree depending on the version and application (Calc vs Excel).

I know some of those examples from real life.
Is my understanding correct?

I believe so.

Kohei

--
Kohei Yoshida, LibreOffice hacker, Calc

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.