https://bugs.documentfoundation.org/show_bug.cgi?id=100008
Bug ID: 100008
Summary: VLookups are incredibly slow and crash even on small
datasets.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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 :(
--
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
