Bug 100008 - VLookups are incredibly slow and crash even on small datasets.
Summary: VLookups are incredibly slow and crash even on small datasets.
Status: CLOSED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-23 12:59 UTC by Rob
Modified: 2016-09-03 08:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rob 2016-05-23 12:59:50 UTC 
I have a spreadsheet with 1000 rows and 2 columns.  I create another spreadsheet with the first column identical to the first spreadsheet.  I then vlookup the second column from the first spreadsheet.  Even on this small dataset the lookup takes up to and over 30 seconds (on an i7 with 8gig RAM! Also verified on several other office PCs of similar spec) and often will hang and crash.  This becomes exponentially worse if the source dataset has more columns.

If I try identical vlookups in Excel they are *instant*, even with spreadsheets with many thousand rows and 50+ columns in the source data.

I started using Calc over Excel a while back because it's handling of CSV files is so much better :)  But not being able to do vlookups has forced me to move back again :(
Comment 1 Cor Nouws 2016-05-23 13:24:08 UTC 
Hi Rob,

Thanks for writing here.
We've seen reports like this one in the past, so maybe..

Could you please give information about your version of LibreOffice and more... See Help > About LibreOffice.
If it's an older LibreOffice: try a new version or master build.

And in case the bug is in a recent version: do you have a test file?

Ciao - Cor
Comment 2 Cor Nouws 2016-05-28 10:57:20 UTC 
ping..