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

Hi Tomas,

On Tue, Feb 28, 2006 at 14:43:34 +0100, Tomas Mecir wrote:

> 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.

I think all spreadsheet applications handle this the same: SUM, COUNT,
AVERAGE, and all the like, get passed what OpenFormula called
a NumberSequence. This by definition ignores string cell content, see

> 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

We'd then end up with a definition of "how does it the one application
of the big player". Which is not our goal, though will be congruent in
many but not all cases.

> 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 ?

Based on real applications, with changes only when and where necessary
for clear benefits.


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