Issue 117348 - freeze or out of memory , when paste a lot of cells with comment.
Summary: freeze or out of memory , when paste a lot of cells with comment.
Status: CLOSED DUPLICATE of issue 101776
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.3
Hardware: All Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-12 04:12 UTC by paz_ohhashi
Modified: 2019-09-12 21:28 UTC (History)
8 users (show)

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

Attachments
One sheet without comments, another with comments (9.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-15 07:02 UTC, bmarcelly 		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 paz_ohhashi 2011-03-12 04:12:48 UTC 
Freeze or out of memory, when paste 1,000,000 cells with comment.

How to reproduce this issue:
 1.Open Calc
 2.Insert comment to a cell　
 3.Copy the cell with comment
 4.Select A2:A1048575
 5.Paste it

 then freeze or out of memory

Reproduced in also:
 - MAC OS X 10.6.6 + Openoffice.org 3.3.0
 - Windows 7 Home Premium + Openoffice3.2.1
 - Windows XP + Openoffice3.3.0
 - Windows XP + Openoffice3.1.0
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:16:20 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 2 Edwin Sharp 2013-08-13 08:38:40 UTC 
As given in description.

Rev. 1507307 Win 7
Comment 3 bmarcelly 2016-02-09 19:36:25 UTC 
same problem as bug 109276
Comment 4 orcmid 2016-02-09 22:32:38 UTC 
We need to reconfirm this, and whether it is a duplicate of Issue 109276.
Comment 5 bmarcelly 2016-02-15 07:02:52 UTC 
Created attachment 85287 [details]
One sheet without comments, another with comments

In this attachment, sheet "NoComment" contains a row of 10 cells with numbers.
Copy (Ctrl-C) the range A1:J1
Select range A2:A2000 (type it in the Name Box above header A)
Paste (Ctrl-V)
In a blink of an eye you obtain 20 000 filled cells.

Reload the document.
Use now sheet "WithComments". It contains a row of 10 cells with numbers and comments.
Copy (Ctrl-C) the range A1:J1
Select range A2:A2000
Paste (Ctrl-V)
Calc is working for 90 seconds to do this copy, without responding.

If not convinced, repeat the test for A2:A50000 or bigger.

Tested on a Windows 7 PC, with processor i5-4570 with 4 cores at 3.2GHz, 8 GB RAM. CPU usage 25% during the copy.
Comment 6 b. 2019-06-03 21:04:57 UTC 
retested this bug today with AOO416m1(Build:9790)  -  Rev. 1844436
2018-10-23 12:57 under win7 pro (x64) SP1, still an issue, pls. see add. comments in #128121, could somebody pls. recheck and set to confirmed, or new? 
see also #109276
Comment 7 b. 2019-09-12 17:29:52 UTC 
hi @ all, 

this bug is 8.5 years old now, 

it is! very easy to reproduce, 

(one might consider it questionable to add 1.000.000 cells at all, but the problem occurs with fewer cells too), 

i retested today on a quite fast machine,

pasting 500k cells with content '1' is finished as you finish typing - nearly -, 

pasting 500k cells with content '1' and comment '1' takes ... i'd kill the task after a coffe, having been to the toilet and a second coffee ... 

pasting 2,5k cells with content '1' and comment '1' takes about 2 minutes, but comes to an end,  

imho it's another manifestation that something is! broken in the representation or handling of comments (notes), these problems are reported since first version of apache and libreoffice, thus likely inherited from OO 3.x, 

see also #109276 and #102716 and plenty duplicates, 

so could please somebody with enough 'karma' look at it, check it and set to 'new' or 'confirmed'? i'd be very pleased. 

tia. 



b.
Comment 8 Peter 2019-09-12 19:53:26 UTC 
Ok I confirm this, based on the comments above.
Comment 9 Peter 2019-09-12 19:56:18 UTC 
Okay and when checking against my list of crashes this is a dublicate...

*** This issue has been marked as a duplicate of issue 101776 ***