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...
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
Keywords: crash
Depends on:
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: ---

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 review?
Details | Diff

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
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
Pre-calculate needed memory, and reserve enough memory in advance

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