[Libreoffice-bugs] [Bug 136796] New: Fill down cells with VLOOKUP formula is slow

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136796

            Bug ID: 136796
           Summary: Fill down cells with VLOOKUP formula is slow
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

Created attachment 165556
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165556&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200916/e1c8ecdf/attachment.htm>