Hello, It is too much easy to freeze calc. Just select some cells with a formula, select a column and paste. LO will repeat the cells for every possible line over and over again. This is too easy to occur. Just a simple click on column header instead of A1 will trigger the problem. I did it myself several times and I lost all my work since last autosave. This is extremely annoying. If calc will do some operation that will take several minutes, it would warn the user. I guess no user will bother to waste 3 seconds to confirm something that will run for several minutes. it will avoid many problems. Also, generally, it is never necessary to paste, repeating a pattern, for every line of a column, every column of a line or even for every cell on a sheet. I cannot imagine a usecase for this.
I try LO 4.2.0.4 and Calc takes 'only' 15 seconds to fill all the column with a formula copied there. Memory consumption go to ~550MB, but maybe this another bug/issue involving Calc core. Set to WORKSFORME.
I tried with the last 4.2.1.1 version. For me, 15s is already a problem. Something should exist to prevent it. However, the test I performed today still gets me LO frozen for minutes. I filled the cells with not too complex formulas. A1 10 A2 11 A3 log(A1^A2) A4 log(A2^A3) ... A16 log(A14^A15) Copied them, selected column B and pasted. I started it before even opening bugzilla and I'm still waiting for a result. My machine is not a bad one (i7, 8 GB ram) Teo91, maybe your test was too simple to trigger the problem.
Never independently confirmed by QA team - moving to UNCONFIRMED to make sure they see it. Thanks for your patience and understanding.
Created attachment 111136 [details] Test spreadsheet based on comment 2 repro steps
TESTING with LO 4.4.0.1 + Ubuntu 14.04 (In reply to Luiz Angelo Daros de Luca from comment #2) REPRO Steps: > I filled the cells with not too complex formulas. > > A1 10 > A2 11 > A3 log(A1^A2) > A4 log(A2^A3) > ... > A16 log(A14^A15) Yep: Just saved that as attachment 111136 [details]. > Copied them, selected column B and pasted. I tried this two ways: 1) Copying just A1:A16, clicking on B1, and pasting 2) Click on the "A" column header and copying the entire column, then clicking on "B" column header and pasting > I started it before even opening bugzilla and I'm still waiting for a > result. My machine is not a bad one (i7, 8 GB ram) NOREPRO: My machine is a Core2Duo with 4G of RAM, and the data copied-over instantly. > For me, 15s is already a problem. Something should exist to prevent it. > However, the test I performed today still gets me LO frozen for minutes. No freezing or problems at all. I've got several other programs running at the same time. What OS are you running? Status -> NEEDINFO
The bug is real but appears to be random and not reproducible at all times. We need to be provided with some extension to LO to be able to produce a detailled crash log.
Summary -> reword for clarity; fix typo
(In reply to rinvel from comment #6) > The bug is real but appears to be random and not reproducible at all times. Rinvel: Have you reproduced the problem? > We need to be provided with some extension to LO to be able to produce a > detailled crash log. We've got various debugging tools, as well as debug builds of LibreOffice. I'll ask the devs what would be most helpful for them.
This is a dupe of bug 43008 or bug 85764. (In reply to Robinson Tryon (qubit) from comment #5) > I tried this two ways: > 1) Copying just A1:A16, clicking on B1, and pasting > 2) Click on the "A" column header and copying the entire column, then > clicking on "B" column header and pasting Neither one of these methods causes a freeze, but combining them does: - Copy just A1:A16 - Click on the "B" column header and paste *** This bug has been marked as a duplicate of bug 43008 ***
1) The problem I encountered was similar to the other scenarios : I had a spreadsheet (10 columns * 2000 rows) with a line with formulas that was duplicated (SUM and SEARCH). LO and OO did freeze when I did a duplicate down. I did lose a lot of work. 2) I logged the bug but it was refused because it was not reproducible and seen as a feature request. 3) I gave up and switched to MS Excel 2010 that works fine ... 4) We can see the many duplicate bugs as a way to reproduce the same bug. I am not the only reporter so there is a serious issue somewhere. 5) This is not a performance issue : the calculation capacity of today's computer are far beyond the needs of power needed to recalculate whole spreadsheets in less that a second. 6) We need a easy-to-use debugger extension. Also that extension needs not to disclose document content for privacy reasons.
Migrating Whiteboard tags to Keywords: (perf) [NinjaEdit]