https://bugs.documentfoundation.org/show_bug.cgi?id=160081
Bug ID: 160081
Summary: Performance: VLOOKUP is very slow even with 41670 rows
of data
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Keywords: perf
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: suokunl...@126.com
Steps to Reproduce:
1. Open the test ods file in attachment 147932.
The file is 145 KB in size, contains only one column with 41670 records, so it
is not too big dataset.
2. Insert new Sheet2. Copy column A of sheet 1 to Sheet2.
3. Set vlookup formula in Sheet2.B2, e.g.
=VLOOKUP(A2,$工作表1.A:A,1,0)
4. Double-click the cell handle in B2 to fill formulas down.
All the 8 cpu of my Thinkpad X1 Carbon is running at 99% for this and it took 6
minutes 23 seconds to run. By comparison, the same operation takes 85 seconds
in MS Excel even with 2 CPU cores in a virtualbox guest OS.
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 98c42f7e961e77d7f1c02d53862e4e78ecd07653
CPU threads: 8; OS: Linux 6.7; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded
Fedora 39 Gnome Wayland
--
You are receiving this mail because:
You are the assignee for the bug.
