To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63259
------- Additional comments from [EMAIL PROTECTED] Tue Mar 21 11:50:14 -0800
2006 -------
Arguments used are :
- The value I wan't to find (ex : $E9)
- Matrix where to search (this is the link to the external file)
(Ex:'file:///C:/Xchange/composants.ods'#$Composants.$A$2:$J$101)
- Index of the column inside the matrix
(EX:7)
- Boolean to specify if the matrix is sorted or not.
(Ex: false, because datas are not sorted)
Here is the complete formula :
"=RECHERCHEV($E10;'file:///C:/Xchange/composants.ods'#$Composants.$A$2:$J$101;7)"
As I said in the first description, I have "#NA" inside some cells and
as you told me, I've just added "false" argument inside the formula and I
receive "#NOM?" ("#NAME?") inside ALL cells.
Any idea?
---------------------------------------------------------------------
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]
