[sc-issues] [Issue 97463] RECHERCHEV 1st and last wh en "not trié"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97463 User canet_o changed the following: What|Old value |New value Issue type|FEATURE |DEFECT --- Additional comments from cane...@openoffice.org Sun Dec 28 23:04:13 + 2008 --- Sorry it is a problem of "feature n (special attraction) fonction nf" and not resolved by a feature". Its e bug is'n it ? = defect - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97463] RECHERCHEV 1st and last wh en "not trié"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97463 User regina changed the following: What|Old value |New value Keywords|oooqa |needmoreinfo, oooqa --- Additional comments from reg...@openoffice.org Thu Dec 25 23:27:16 + 2008 --- You have reopened the issue and set it to "feature", but I see no feature request. Please explain. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97463] RECHERCHEV 1st and last wh en "not trié"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97463 User canet_o changed the following: What|Old value |New value Status|CLOSED|UNCONFIRMED Issue type|TASK |FEATURE Priority|P2|P3 Resolution|INVALID | --- Additional comments from cane...@openoffice.org Thu Dec 25 18:03:41 + 2008 --- In help on Vlookup : "Si ordre_de_tri est paramétré sur FAUX ou zéro, une correspondance exacte doit être trouvée, sinon il en résulte l'erreur Erreur: valeur non disponible. Ainsi, avec une valeur de zéro, les données n'ont pas besoin d'être triées dans l'ordre croissant." In the exemple DEMO BUG RECHERCHEV pour « AB et FAUX » The reponse "texte ZZ_AB" is not as described in the help. Thanks for looking that. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97463] RECHERCHEV 1st and last wh en "not trié"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97463 User regina changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from reg...@openoffice.org Sun Dec 21 15:55:00 + 2008 --- closing, no bug - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97463] RECHERCHEV 1st and last wh en "not trié"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97463 User regina changed the following: What|Old value |New value CC|''|'regina' Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Resolution| |INVALID --- Additional comments from reg...@openoffice.org Sun Dec 21 15:54:23 + 2008 --- The function VLOOKUP works as it should. I cite the application help, "If the SortOrder parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact SearchCriterion is not found, the last value that is smaller than the criterion will be returned. If SortOrder is set to FALSE or zero, an exact match must be found" In your example the column containing the criteria is not sorted ascending, therefore the sortorder parameter _must_ be set to 0. And in that case - in your example in column I - the first match is returned. Using a non ascending column with sortoder parameter 1, TRUE or none, gives indeterminate results. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97463] RECHERCHEV 1st and last wh en "not trié"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97463 --- Additional comments from cane...@openoffice.org Sun Dec 21 15:26:14 + 2008 --- Created an attachment (id=58952) DEMO BUG RECHERCHEV - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97463] RECHERCHEV 1st and last wh en "not trié"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97463 Issue #|97463 Summary|RECHERCHEV 1st and last when "not trié" Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|TASK Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|canet_o --- Additional comments from cane...@openoffice.org Sun Dec 21 15:19:56 + 2008 --- =RECHERCHEV(valeur;champ;rang;0 ou 1) is wrong for first and for last line when the lines in the champ arent not decrechendo organized. Y can send a calc with the demo. Thanks - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
