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] MATCH function

I checked the OOXML specification -- it does not define the behavior in the presence of duplicate entries.

So if the apparent behavior of Excel appears reasonable, I agree with documenting that.


Eike Rathke <erack@sun.com>

01/18/2008 09:29 AM

Re: [office-formula] MATCH function

Hi Kohei,

On Thursday, 2008-01-17 16:41:51 -0500, Kohei Yoshida wrote:

> [... MATCH last/first of sorted source range for <=query ...]
> Now the real question is whether it is worthwhile to standardize this
> behavior.

I think so. People may rely on it to retrieve an index into related data

I'll add this to the spec. Thanks for pointing out.


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]