Re: [Libreoffice-ux-advise] new listbox in calc options pages

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