Issue 123909 - Select one column, paste cell range with merged cell in, AOO will be not responding.
Summary: Select one column, paste cell range with merged cell in, AOO will be not resp...
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Major (vote)
Target Milestone: 4.1.0
Assignee: Clarence GUO
QA Contact: liuping
URL:
Keywords: crash
Depends on:
Blocks:
 
Reported: 2013-12-23 09:05 UTC by fanyuzhen
Modified: 2017-05-20 10:35 UTC (History)
3 users (show)

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

Attachments
Sample Document (8.29 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-12-23 09:54 UTC, Rainer Bielefeld 		no flags Details
fix patch (9.82 KB, patch)
2014-01-06 02:21 UTC, Clarence GUO 		clarence.guo.bj: review?
Details | Diff
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 fanyuzhen 2013-12-23 09:05:24 UTC 
This defect is migrated from Symphony defect as below:

Sym3_3357	Select one column, paste cell range with merged cell in, symphony will be not responding.
Comment 1 Rainer Bielefeld 2013-12-23 09:53:43 UTC 
Already Reproducible with attached sample document and sever installation of "OOo 3.3.0 English UI / German locale [OOO330m20 (Build 9567)]" on  WIN7  Home Premium  (64bit) DE :

1. Open attached sample document from AOO Start center
2. Select yellow background cells using mouse
3. <control+c> for copy
4. Click Column Heading "B"
5. <control+v> for paste
   Bug: AOO will hang with maximum CPU load

Additional info:
----------------
(a) was still ok with OOo 3.1.1
(b) really related to cell range, copy / paste of merged cell will not
    cause Hang.
(c) LibO 4.1.3 still suffers from the Problem (see "FDO#45925 - EDITING: 
   HANG when copy - paste cells including merged ones to column"
(d)  Already reproducible with  Pre-3.4.0 (OOo 3.3.0), but because of crippled  
     Version selector (Bug 123063) no useful info can be contributed
Comment 2 Rainer Bielefeld 2013-12-23 09:54:43 UTC 
Created attachment 82153 [details]
Sample Document

See comment above how to use
Comment 3 Edwin Sharp 2013-12-23 20:26:48 UTC 
Confirmed also in
AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian
Comment 4 SVN Robot 2014-01-03 08:48:03 UTC 
"steve_y" committed SVN revision 1555031 into trunk:
Bug 123909 - Select one column, paste cell range with merged cell in, AOO wil...
Comment 5 Clarence GUO 2014-01-06 02:21:12 UTC 
Created attachment 82223 [details]
fix patch

Root Cause:
Because need to allocate too much memory for 1M rows, memory allocation cost too much time
Resolution:
Pre-calculate needed memory, and reserve enough memory in advance

NOTE:
With the fix, paste cells to 1M rows needs several seconds, but freeze will not happen. As the same scenarion in Excel 2010 also take several seconds, I think the result is acceptable.
Comment 6 Rainer Bielefeld 2014-01-18 08:24:05 UTC 
No longer reproducible with server installation of "AOO 4.1.0-Dev – English  UI / German locale - [AOO410m1(Build:9750)  -  Rev. 1558977 - 2014-01-18]" on German WIN7 Home Premium (64bit)", own separate user profile.

Fix works fine, paste within few moments.
Comment 7 liuping 2014-02-26 00:14:05 UTC 
Verify AOO410m1(Build:9750)  -  Rev. 1570848
Rev.1570848 on windows7 ,pass