Issue 114138 - Regression: Fill or Paste too slow
Summary: Regression: Fill or Paste too slow
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Test case (372.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-27 09:42 UTC, bormant 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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)

or 

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 "issues@openoffice.apache.org".