Re: [office-formula] MATCH function

[robert_weir@us.ibm.com]

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.

-Rob

Eike Rathke <erack@sun.com>

01/18/2008 09:29 AM

To	office-formula@lists.oasis-open.org
cc
Subject	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
records.

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

  Eike

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

atts7cxp.dat