Summary: | Function "SearchV" don't work well | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Xavi <xavillorcasoria> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEEDINFO --- | ||
Severity: | normal | CC: | miguelangelrv, xiscofauli |
Priority: | medium | ||
Version: | 7.1.0.3 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Xavi
2024-02-05 12:35:23 UTC
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon. ATM I am writing this, the Summary is: Function "SearchV" don't work well FWIW, "SearchV" is Calc's function VLOOKUP(). ATM the Version field is 7.1.0.3. That version is no longer maintained, and later versions (e.g. 7.4) introduced changes to several lookup functions, especially when the data is unsorted. There have been reports of problems in such cases, some of them not yet resolved. I would suggest updating the version of LO and retesting. But, considering that there are other reports (that are not yet resolved) related to lookup functions when the data is unsorted, I'm not sure how much an update could help – it might depend on which exact LO version you end up testing. Attaching a minimal sample file might help to reproduce, but please keep in mind that it will be publicly available. from the description I would guess: Sort the source-list ascending by Name and the »bug« is solved! ⇒not a bug? (In reply to Werner Tietz from comment #3) > Sort the source-list ascending by Name and the »bug« is solved! Not necessarily; it depends on the arguments used for this specific case. We would need the file, in order to review whether the data is sorted or not, and to review whether the arguments of the function correspond to that. Having said that, there are reports not yet resolved, especially for unsorted data. |