Bug 34719

Summary: EDITING: Undoing column delete operation with merged cells is very slow and scrolls the document
Product: LibreOffice Reporter: Aurimas Fišeras <aurimas>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: aurimas
Version: 3.3.1 release   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: Sample document
How it looks.

Description Aurimas Fišeras 2011-02-25 06:33:59 UTC
Created attachment 43803 [details]
Sample document

How to reproduce:
1. Open attached document.
2. Select Column B.
3. Delete Column B (takes too long).
4. Undo last operation (Ctrl+Z) (takes very long).
5. (Optional) Redo last operation (Ctrl+Y) (takes very long).

Column B is restored, but the document starts scrolling, and merged cells are selected one by one. This takes very long time to complete.

This affects LibO 3.3.1, OO 3.2 - 3.4 on Linux/Windows.
In Excel both operations (3, 4) are completed instantly.
Comment 1 tester8 2011-02-26 04:14:26 UTC
Not Reproduced with LO 3.3.1 RC2 Ubuntu 10.04 x86.
All operations takes less then 2 seconds.
Please provide uname -a and Windows version.
Comment 2 Aurimas Fišeras 2011-02-26 04:54:15 UTC
I can reproduce it on Windows XP, Windows 2003 64-bit TS server with clean user's profile.

I can also reproduce it on Ubuntu 11.04 (Linux 2.6.38-5-generic #32-Ubuntu SMP Tue Feb 22 16:10:15 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux) with LibO 3.3.0, 3.3.1, 3.4-git.
Comment 3 Don't use this account, use tml@iki.fi 2011-03-08 00:08:04 UTC
Kohei, any ideas? Assign back to list if nothing can be done without a complete rewrite;)
Comment 4 Aurimas Fišeras 2011-05-14 03:00:20 UTC
Created attachment 46703 [details]
How it looks.

I can still reproduce the effect on all machines (Linux, Windows) I try with all versions of LibreOffce (up to LO 3.4b5).
Comment 5 Aurimas Fišeras 2011-12-27 03:11:39 UTC
I can still reproduce this bug in 3.5.0beta2 on Windows XP.
Comment 6 Aurimas Fišeras 2012-08-14 08:15:09 UTC
Still a problem in LibO 3.6.0 (and AOO 3.4).
Comment 7 Aurimas Fišeras 2012-11-05 10:28:24 UTC
Still a problem in LibreOffice 3.6.3.2 (Build ID: 58f22d5) on Windows XP and Ubuntu 12.10 64-bit.
Comment 8 Aurimas Fišeras 2012-11-05 10:35:02 UTC
Checked with Libreoffice 3.7.0.0.alpha0+ (Build ID: bce042) on Ubuntu 12.10 64-bit - same problem.
Comment 9 Aurimas Fišeras 2012-11-24 14:55:32 UTC
Ubuntu 13.04 64-bit. LibreOffice 4.0.0.0.alpha1+ (Build ID: 233369b1e7990c6a3d03810b81eae0ee9175771)

Callgrind log: http://ubuntuone.com/1q8MmMEkwL1FLZnbreec9F

Callgrind log collected by running:
valgrind --tool=callgrind --simulate-cache=yes --instr-atstart=no --dump-instr=yes ./soffice.bin --calc --splash-pipe=0

Then opened a sample document, deleted column B. Started callgrind with "callgrind_control -i on", and pressed Ctrl+Z. After undo operation finished, exited LibreOffice.
Comment 10 Aurimas Fišeras 2013-09-24 13:14:31 UTC
It is even worse in 4.2 (4.2.0.0.alpha0+ Build ID: d3c70e68c652bbdeeaea20200e003b6c5f92a62f).

Ubuntu 13.10 64-bit:
On LibreOffice 4.1.1.2 undo operation (step 4) takes 21 seconds to complete
On LibreOffice 4.2.0.0.alpha0+ undo operation (step 4) takes 137 seconds to complete.
Comment 11 Aurimas Fišeras 2014-11-20 11:03:07 UTC
Version: 4.4.0.0.alpha2+
Build ID: 9dc7bae64d1c08e06c755ea97c21e50bd6a8eec1
Locale: lt_LT

Still reproducible.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.