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

Kohei Yoshida wrote (12-12-12 21:07)
> 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.

I would say that - also in the very special cases - one can be 
(almost..) sure that the results on opening are the same as when saved, 
is a considerable change.
But I agree, choosing words here is a matter of taste.

> > 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.

Yes, that is what I mean.

> [snipped in]
> Ah I should also point out that there are exceptions to this rule.  If a
> cell contains what's called volatile function which need recalculating
> on every input change, that cell gets recalculated on load.  Examples
> are cells containging NOW() and TODAY(), and there may be other
> functions that are in this category.
> [\snipped in]
>
>
> > 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,

(sometimes Calc functions behave different with arguments that should be 
optional, sorting of ranges, different date within a referred range and 
such.
This is a second reason for different results that sometimes occur, then 
differences in processors, floating points, software versions.)

> 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).

Clear.

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

OK, thanks for your further explanation.
I'll make to poste my draft text.

Cheers,


--
 - Cor
 - http://nl.libreoffice.org
 - www.librelex.org