Bug 77491 - It takes a long time to performance a Lookupv
Summary: It takes a long time to performance a Lookupv
Status: RESOLVED DUPLICATE of bug 79892
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2014-04-15 16:31 UTC by nain.santiago
Modified: 2014-10-31 09:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description nain.santiago 2014-04-15 16:31:47 UTC
When I make a lookupv to 500,000 records, it takes long time and never finished.  

as above when I delete a column or add one in this file with 500,000 records takes about 20 min and does it

And Linux takes a longer time than Windows but in Windows cannot save it just close up the aplication and when i reopen the file it displays the recovery file window.
Comment 1 m_a_riosv 2014-04-15 22:45:56 UTC
Hi nain, thanks for reporting.

Please can you attach a sample file.
Comment 2 m_a_riosv 2014-04-24 02:31:25 UTC
Hi Nain, looking at your sample file in my opinion maybe calc is not the proper tool to work with a so large number of records and specially with such quantity of formulas like VLOOKUP().
I think is a job for a database, in the documentation you can find database samples.

You can try if a formula like:
J3: =IF(ISBLANK(H3);"";VLOOKUP(H3;clientes.A$2:B$664;2;0))
make a bit faster recalculations, avoiding calculate the VLOOKUP() when there is not value to find.
Comment 3 raal 2014-10-30 20:20:58 UTC
what's the result? Is it bug or not? Maybe you can try to sort data, then vlookup should be faster.
Comment 4 m_a_riosv 2014-10-30 23:39:55 UTC
Maybe it's the same problem than here https://bugs.freedesktop.org/show_bug.cgi?id=79892, a pain.
Comment 5 raal 2014-10-31 09:27:42 UTC
I'm going to close this bug as duplicate of bug 79892. Symptoms looks similar. There is not test file in this bug report, we cannot investigate more. You can revert status to Unconfirmed if you have additional informations. You can try using vlookup on sorted data or try suggestions from this link https://fastexcel.wordpress.com/2012/03/29/vlookup-tricks-why-2-vlookups-are-better-than-1-vlookup/ (it's for excel but maybe helps on LO too).

*** This bug has been marked as a duplicate of bug 79892 ***