Bug 136796 - Fill down cells with VLOOKUP formula is slow
Summary: Fill down cells with VLOOKUP formula is slow
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-09-16 07:31 UTC by Kevin Suo
Modified: 2020-09-17 12:14 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
test ods file (723.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-09-16 07:31 UTC, Kevin Suo 		Details
View All 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 Kevin Suo 2020-09-16 07:31:02 UTC 
Created attachment 165556 [details]
test ods file

It is very slow to fill down a column with VLOOKUP formula.

Steps to Reproduce:
1. Type in "=VLOOKUP(A2,$aufnr.A:B,2,0)" in cell B2 of tab Sheet3.
2. Fill down the formula by double-clicking the + handle at the bottom-right corner of cell B2.

Current Behaviour:
It takes a lot of time (>40s) on my pc before this column is successfully filled.

Expected:
The column is filled with vlookup formula within 3 seconds. 
Even the old Microsoft Excel 2010 can do this within 3s.

Version: 6.4.6.2
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3; 
Locale: zh-CN (zh_CN.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Kevin Suo 2020-09-17 12:14:57 UTC 
My bad - this may not be a bug, althrough it may be improved. Excel is also slow with such operation.

A workaroud is to sort the column A in sheet aufnr and then do vlookup with "=VLOOKUP(A2,$aufnr.A:B,2,1)".