When pasting something while accidently the topleft button was hit (everything is selected) instead of the intended first field (a:!) LO hangs and crashs.
[Reproducible] with "LibO 4.0.0.2 rc - GERMAN UI / German Locale [Build ID: 5991f37846fc3763493029c4958b57282c2597e)]" {tinderbox: @6, pull time 2013-01-24 07:20(?)} on German WIN7 Home Premium (64bit) with User Profile automatically created form renamed /3 User profile used by 3.6.5.2 Steps: 1. Open attached sample document (I think it should be possible with every document, even may be with an empty one) 2. With mouse pointer select B6:C9 3. <control+c> for copy 4. Click common row/Column header > All cells selected 5. <control+v> for paste Bug: LibO will become unresponsive, often even will crash afer some time (a minute or so) I will check where that started. @Reporter: Thank you for your attention, but it was only lucky chance that I was able to reproduce the bug you observed with that very rare report. If you fine other bugs, Please use LibO Menu 'Help -> Feedback/Bugreports', what will guide you and help to gain more useful information. Please add a comment with concrete and detailed information concerning your Operation system and LibO version
Created attachment 73835 [details] Sample Document Already [Reproducible] with Server Installation of "LibreOffice 3.3.3 English UI/ German Locale [OOO330m19 (Build:301) tag libreoffice-3.3.3.1] on German WIN7 Home Premium (64bit) Same with AOOo 3.4.0. So I think problem is inherited from OOo. I did not fin a DUP
Only Major, I don't believe that this that this problem so often happens @Spreadsheet Team Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC)
We need to forbid paste and other multiple-cell data entry after Ctrl+A (or that grid button) selection or other selections encompassing too many cells. Effectively the data is repeatedly pasted to all selected cells, in the case of Ctrl+A that is 1024x1000000 ... grinding available memory to the ground and application gets shutdown.
As a spin off I submitted "Bug 60056 - CRASH when fill all cells of sheet", please mark that one as DUP if a fix seems possible together with fix for that one. There is a difference to Bug 60056 concerning copying empty cells, I don't know whether that's interesting: Proceed as per original report, but with a new empty sheet: Here LibO Becomes unresponsive with maximum CPU load AND rapidly increasing memory consumption (so that LibO will crash finally?) Situation was a little different in LibO 3.3.3 (WIN), in step 6 (with empty document) also becomes unresponsive, but ONLY significant processor load, NO memory consumption, what ever that might mean.
Here is a video of Select All followed by Paste making LibreOffice Calc hang (eating up memory) on Fedora 18: http://www.youtube.com/watch?v=x15oL8BWiWk
I observe something very similar, here (OS X 10.7, LibreOffice 4.0.3.3). Basically, copying and pasting a full column (at least after removing, say, its first cell from the selection) is handled very inefficiently by LibreOffice: the CPU starts running, and the computer starts swapping like mad. I can imagine that LibreOffice is copying a huge number of cells instead of optimizing the copy by noticing that the column is completely empty after some row and only copying a few cells.
Calc Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) on Win 7 x64 does the same thing here when pasting just 6000 rows from Excel into a multi-sheet LO Calc document after pressing CTRL-A to replace the previously entered contents.
*** Bug 76807 has been marked as a duplicate of this bug. ***
*** Bug 89594 has been marked as a duplicate of this bug. ***
(In reply to Rainer Bielefeld Retired from comment #2) > Same with AOOo 3.4.0. So I think problem is inherited from OOo. Marked as such.
Created attachment 115691 [details] Debug with WinDBG in LO-dev
Bug 91825 maybe a duplicate.
*** Bug 91825 has been marked as a duplicate of this bug. ***
*** Bug 95746 has been marked as a duplicate of this bug. ***
Taking.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=984b0d1599ff1672cb0d28019bd652d58d6bdefa Resolves: tdf#60021 disallow Paste when entire sheet is selected It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fe46041a6b2fd29715389cc5eb2dfbaf65f7f1f9 do not force the Paste command to enabled for Calc, tdf#60021 related It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/27647 for 5-2 (and https://gerrit.libreoffice.org/27648 related)
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7d40a0b8fcba1bda84c8e756d8000b92e768f9e2&h=libreoffice-5-2 Resolves: tdf#60021 disallow Paste when entire sheet is selected It will be available in 5.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=849b2dcf38893608b3bce0c86668a0b9db802f55&h=libreoffice-5-2 do not force the Paste command to enabled for Calc, tdf#60021 related It will be available in 5.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5cf5975cef114870268bee792e44570ddfdaafe8 limit SelectionFillDOOM to 24117248 cells, tdf#60021 tdf#60056 related It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7dda28234cc516e864aff9a6c97b7c539a063c4e&h=libreoffice-5-2 limit SelectionFillDOOM to 24117248 cells, tdf#60021 tdf#60056 related It will be available in 5.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 92797 has been marked as a duplicate of this bug. ***