Re: [office-formula] A-functions

["David A. Wheeler" <dwheeler@dwheeler.com>]

> On 9/7/06, David A. Wheeler <dwheeler@dwheeler.com> wrote:
> > In the specific case of in-line vs. in-a-range, there are actually
> > rational reasons for how SUM() etc. typically work.

Tomas Mecir:
> Hmm, for KOffice at least, the functions don't know whether the
> parameter that they are getting is coming from inline value or from a
> reference...
> Besides, the difference only really matters for inline text values, as
> that's the only scenario where different results are produced...
> Or am I again missing something obvious ?

I think you're forgetting that logical types are distinct types in
some apps (like Excel, Gnumeric, and SheetToGo).
Yet _ALL_ applications handle this identically:
 SUM([.A1:.B3]; [.C4]<10)
because the second number is a logical, and inline logicals ARE converted
to numbers, even when logical values are distinct types.
This construct can be used to include compensating factors.

--- David A. Wheeler