https://bugs.documentfoundation.org/show_bug.cgi?id=115490
Bug ID: 115490
Summary: VLOOKUP unsorted is too slow in larger row sets
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I'll attach a test file.
Take a lookup in 10.000 columns
Unsorted takes ~40 secs on my laptop. Sorted is done in < 1 sec.
(for reference, in 4.0.6.2, unsorted takes more then 4 minutes.)
One might decide that it is good to sort the lookup range.
Indeed.
However… if a value that is seached for, is not available, then there will
still be a result returned (see Help on VLOOKUP, 4th argument, (un)sorted)
To prevent this, one could first check if a matching value is available, by use
of VLOOKP unsorted ..
So no joy in that approach.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
