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] General question (not yet a JIRA issue)

On Fri, 2009-12-11 at 09:17 -0500, Patrick Durusau wrote:
> Greetings,
> When looking at TYPE I read:
> > Portable documents *shall not* depend on receiving a value of 4.
> >
> Since TYPE returns a number indicating a value type, I am not real sure 
> what it means to "not depend on receiving a value of 4." ???
> BTW, 4 is logical.
> So a portable document could accept some other number for logical type? 
> Or doesn't recognize logical type? Or if it does, then it isn't a 
> portable document?

Logical values may be implemented as a distinct, distinguishable type
from numbers, so that ISNUMBER(TRUE()) and ISLOGICAL(1) evaluates to
FALSE(). However, logical values may also be implemented as a subtype of
Number, where TRUE() simply returns 1 and FALSE() simply returns 0. Note
that due to the implicit conversion operator ┤Number to
Logicalí (discussed below), when a number is passed as a condition, 0 is
considered False and all other numeric values are considered True.

So there may not be a Logical type. For example OOo does not implement a


Andreas J. Guelzow <aguelzow@pyrshep.ca>

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