Issue 114138 - Regression: Fill or Paste too slow
Summary: Regression: Fill or Paste too slow
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m18
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-08-27 09:40 UTC by bormant
Modified: 2017-05-20 11:33 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Test case (372.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-27 09:42 UTC, bormant
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bormant 2010-08-27 09:40:57 UTC
1) Open attached test file,
2) Make sure AutoCalculate is on,
2a) Select U9:AE2016
3a) Edit - Fill - Down (Ctrl+D)


2b) Select U9:AE9 and Copy (Ctrl+C) 
3b) Select U10:AE2016 and Paste (Ctrl+V)

OOo Calc 3.2.1 and Dev-330m3 freeze with "Adapt row height" in status bar. Be 
patient, they do this work very very very slow.

OOo Calc 3.1.1 has no the problem.
Comment 1 bormant 2010-08-27 09:42:25 UTC
Created attachment 71422 [details]
Test case
Comment 2 bormant 2010-08-27 10:09:15 UTC
When AutoCalculate is off pressing F9 after Fill or Paste has the same effect --
calculations are very slow.
So, this may be LOOKUP() performance issue.
Comment 3 helenrussian 2010-08-27 10:35:06 UTC
Confirm with OpenSUSE 11.0, OOo 3.2.1 - as described.
Comment 4 niklas.nebel 2010-08-27 14:31:55 UTC
This is caused by the changes for issue 81214. LOOKUP is forced to array
semantics, and if a cell range is passed as first parameter, it's calculated for
every cell from that range. Simple example: 1 in A1, 2 in A2,
=LOOKUP(A1:A2;A1:A2) in B2 should return 2, but gives 1 (the first element of
the result matrix).

As a workaround, use only a single-cell reference for the first parameter
(change it from $C$9:$C$2016 to $C9). The example looks like VLOOKUP should be
used anyway, with 0 as the last parameter for exact lookup.
Comment 5 Oliver Brinzing 2010-08-27 16:23:49 UTC
Comment 6 Marcus 2017-05-20 11:33:11 UTC
Reset assigne to the default "".