| Summary: | Other: Not working locate function. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Elesca <xcalibur.uy> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | gerard.fargeot, neutr |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | The image that explains by itself this odd behavior. | ||
I mean BUSCAR is the locale name of LOOKUP.
This function requires search vector to be sorted in ascendant order.
I can see that this is the case in your sceenshot but :
You may not inculde the headers in the search vector.
The field name "name" false the result : A1:A16 is not sorted, A2:A16 is.
=BUSCAR("Fred";A2:A16;F2:F16) will gives you the expected result.
|
Created attachment 90287 [details] The image that explains by itself this odd behavior. Just follow the sample published in OOo manual for locate or vlocate usage. Current behavior: Returns a value one row above the located value. Expected behavior: Return the value on the same row the located value is. Tested EVERY version i coudl find, and it does always the same. Operating System: All Version: Inherited From OOo