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] Semantics

On 2/28/06, Dan Bricklin <danb@bricklin.com> wrote:
> I can see why you'd want COUNT vs. COUNTA -- define a range bigger

The problem with COUNT/COUNTA: what if a cell contains a string that
can be converted to a number ? Say, "3". What then ? With this
approach, COUNT doesn't include this, but your average user will say,
but it's a number.

Another question is, do we even WANT to delve into problems like this
? Or shall we simply choose the approach which is currently used most

I think this introduces the problem of our goal: shall we design a
spec based on real spreadsheets, or also put in new/changed things, if
we feel that it makes sense ?

/ Tomas

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