Bug 98471 - Calc slows down after a column is deleted
Summary: Calc slows down after a column is deleted
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2016-03-06 11:44 UTC by MihailJP
Modified: 2016-11-08 12:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description MihailJP 2016-03-06 11:44:13 UTC
I've noticed that Calc slows down after a column is deleted in the following condition.

How to reproduce:
1) Select the entire worksheet by clicking top-left.
2) Set any font.
3) Enter something like "foo", "bar" or "baz" to some cells.
4) Delete a column containing a cell with data.

Expected:
Calc still runs at a usable speed.

Actual:
Calc slows down extremely.

Workaround:
Do not set format to the ENTIRE worksheet. Do it only to the cells in which actually the data exist.

Additional information:
Instead of deleting a column, swapping columns (Alt + drag) also causes this issue. If caused by this way, the undo doesn't speed up again. The issue can be undone if it is occured by deleting.
This doesn't apply for rows in lieu of columns.
Comment 1 MihailJP 2016-03-06 12:03:59 UTC
I forgot to write my environment:

Device: Desktop PC
Operating system: Windows 10, 64-bit
CPU: Core i7 860
Hyperthreading: disabled
Overclocking: no
Graphic card: GeForce GTX 950
Memory: 4 GB
Comment 2 raal 2016-03-10 06:21:56 UTC
I can not confirm with Version: 5.2.0.0.alpha0+
Build ID: aaca25d67eb5ea252730cdcf555ecc04ce04a5e6
CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-02-24_23:58:47

and Version: 5.2.0.0.alpha0+
Build ID: 817f6bd75e98a321c238b5906bfcb031908914b2
CPU Threads: 1; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-03-01_01:14:57;  win10

Please could you test with dev version?
http://dev-builds.libreoffice.org/daily/master/
Thank you
Comment 3 Buovjaga 2016-03-10 13:45:45 UTC
No problem.

Win 7 Pro 64-bit, Version: 5.1.0.3 (x64)
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
Locale: fi-FI (fi_FI)

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists with a newer version. Change to RESOLVED WORKSFORME, if the problem went away.
Comment 4 Xisco Faulí 2016-10-10 11:24:26 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2016-11-08 12:52:09 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20161108