← Prev in month ← Prev in thread

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

From
Eric Patterson <>
Date
2010-11-17T17:40:25+00:00
ID
Thread
[office-formula] Table:search-criteria-must-apply-to-whole-cell
I'm trying to identify which functions are affected by this calculation setting.
 
In looking at Office-1181, Office-969 & Office-2033, I see that Eike listed the following functions as being affected:
	DAVERAGE 
	DCOUNT 
	DCOUNTA 
	DGET 
	DMAX 
	DMIN 
	DPRODUCT 
	DSTDEV 
	DSTDEVP 
	DSUM 
	DVAR 
	DVARP 

	COUNTIF 
	SUMIF 
	LOOKUP 
	VLOOKUP 
	HLOOKUP 
	MATCH

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

As an implementer (and committee member), I'm very confused w
← Prev in month ← Prev in thread