Re: [office-formula] Table:search-criteria-must-apply-to-whole-cell

[Eike Rathke <eike.rathke@oracle.com>]

Hi Eric,

On Wednesday, 2010-11-17 17:40:13 +0000, Eric Patterson wrote:

> In the latest draft of the spec, I see section 4.11.8 that describes
> Criterion as affected by this setting.  The database functions clearly
> reference this and the following functions reference 4.11.8: COUNTIF,
> COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS.
> 
> There seems to be a few problems here:
> - LOOKUP, VLOOKUP, HLOOKUP & MATCH make no reference to section 4.11.8
> or to Table:search-criteria..., so in the current state, these
> functions are not affected by this setting.  Was this the intent?

No, oversight. I'll add that for rev07.

> - The functions that do reference 4.11.8 explicitly say, "The values
> returned may vary depending upon the HOST-USE-REGULAR-EXPRESSIONS or
> HOST-USE-WILDCARDS properties", but do not mention
> table:search-criteria.  This would help greatly to clarify things.

I'll add HOST-SEARCH-CRITERIA-MUST-APPLY-TO-WHOLE-CELL for rev07.

Thanks for catching.

  Eike

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

PGP signature