OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: Re: [office-formula] A-functions


On 9/7/06, David A. Wheeler <dwheeler@dwheeler.com> wrote:
> 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.

Wouldn't it then be sufficient to follow the way of OOo, and make the
non-A versions always include logical values as well ? Both reference
and inline ?

/ Tomas


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]