To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74245
------- Additional comments from [EMAIL PROTECTED] Wed Feb 13 16:28:31 +0000
2008 -------
Ok, here is my note. Let me just copy-n-paste.
---------------------------------------------------------------------------
* 2-parameter case ([lookup value], [lookup-result matrix])
* The search direction, either horizontal-search or vertical-search,
is determined from the dimensions of the matrix; if the data
matrix is wider than taller, the search direction is horizontal,
and if it is taller than wider, the direction is vertical. If the
data matrix is a square, the search direction is vertical.
* In vertical search mode, only the first column gets searched, and
the last column is used as the result array. Those columns that
are not either the first nor the last are simply not used. In
case of a one-column matrix, the search column and the result
column are identical. These rules also apply in horizontal search
mode but to rows instead of columns.
* 3-parameter case ([lookup value], [lookup matrix], [result matrix(vector)])
* The result matrix must be a vector, or it raises an error.
* The lookup matrix does not need to be a vector. If it's not a
vector only the first column or row gets searched (= search
vector). [NOTE: the ODFF spec requires this to be a vector, but
Excel does not.]
* The search direction is determined from the dimensions of the
lookup matrix. The same rules as the 2-parameter case apply.
* The directions of the lookup matrix and the result matrix can
differ. [NOTE: the ODFF spec does not mention this.]
* The lengths of the search vector and the result vector do not need
to be identical; however, when the match position falls outside
the length of the result vector, an error is raised if the result
vector is given as an array object. If it's a cell range, it gets
automatically extended to the length of the searched vector. If
the cell range cannot be extended due to size limit, then '0' is
displayed. [NOTE: the ODFF spec requires the search vector and
the result vector to be of the same length.]
---------------------------------------------------------------------------
The spec covers the 2-parameter case pretty well, and my note reveals nothing
new here. But for the 3-parameter case there are some behaviors of Excel that
are not mentioned or not accurately depicted in the ODFF spec.
Actually I have a new patch to cover the last item of my note. I'll attach it
here shortly.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
