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

Hi Tomas,

On Thu, Sep 07, 2006 at 16:43:18 +0200, Tomas Mecir wrote:

> >> - COUNT and COUNTA are exceptions, as they just count values - COUNT
> >> counts number values and nothing else. COUNTA also counts logical and
> >> text values.
> >
> >So why is that an exception then? It is congruent with the behavior
> >above, or did I miss anything?
> Because they never attempt conversion of strings to numeric values.
> Hence, the COUNTA function would never propagate an error if it were
> to get something like "test" - whereas AVERAGEA or something, if using
> automatic conversion to numbers, would fail conversion and thus return
> an error on the same parameters.

Ah, ok, the error cases, yes. Btw, Excel interprets and counts inline
numeric strings also for COUNT. As usual.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

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