Bug 94099 - Calc performance degradation after selecting cells in an Excel document and activating font chooser with previews enabled
Summary: Calc performance degradation after selecting cells in an Excel document and a...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, perf, regression
Depends on:
Blocks: Cell-Selection
  Show dependency treegraph
 
Reported: 2015-09-10 14:43 UTC by Igor
Modified: 2021-05-04 14:02 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
example sheet (203.00 KB, application/vnd.ms-excel)
2015-09-11 17:44 UTC, Igor
Details
video (6.35 MB, video/quicktime)
2015-09-14 15:40 UTC, Igor
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Igor 2015-09-10 14:43:25 UTC
When i select all cells on sheet (1000 rows, 15 colomns) and try to change font, even if didn't save any changes, Calc becomes very slow.
Comment 1 Igor 2015-09-10 15:14:21 UTC
file extention .xls
Comment 2 Alex Thurgood 2015-09-11 05:47:29 UTC
@Igor : please provide a sample document where you see the problem, otherwise we can not know whether it is the document format, the cell contents, or some other problme that is causing the slowdown.
Comment 3 Igor 2015-09-11 17:44:14 UTC
Created attachment 118618 [details]
example sheet
Comment 4 Alex Thurgood 2015-09-14 13:15:56 UTC
Version: 5.0.1.2
Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261
Locale : fr-FR (fr.UTF-8)

Can not reproduce.


1) Open Excel sheet attached to current bug report.
2) Select all cells in sheet by clicking in upper leftmost corner outside of sheet
3) Click on font dropdown menu, the font list displays with previews where available.
4) Select a font to apply to all cells.
5) Cells get updated with chosen font display.


We need more information, and detailed steps as to how you are able to reproduce the problem/
Comment 5 Alex Thurgood 2015-09-14 13:17:00 UTC
Which version of OSX are you using ?
How many fonts / font families are installed on your system ?
Comment 6 Igor 2015-09-14 15:40:39 UTC
Created attachment 118709 [details]
video
Comment 7 Igor 2015-09-14 15:57:56 UTC
OSX 10.10.5, 233 fonts installed.
Program freezes after activating font chooser.
Added small video.
Comment 8 Alex Thurgood 2015-09-14 16:06:10 UTC
Hi Igor,

Thanks, I understand now what you are referring to, and can reproduce the behaviour. Confirming. This rings a bell, so might be a duplicate of an existing bug report.
Comment 9 Alex Thurgood 2015-09-14 16:09:55 UTC
How to reproduce :


1) Open Excel sheet attached to current bug report.
2) Select all cells in sheet by clicking in upper leftmost corner outside of sheet
3) Click on font dropdown menu, the font list displays with previews where available.
4) Select a font from the list to apply to all cells.

5) Now try selecting any cell with the mouse cursor >> Calc becomes very slow to respond, cells or cell selections get made that the user didn't actually select, the whole document becomes unresponsive.
Comment 10 QA Administrators 2016-09-20 10:32:51 UTC Comment hidden (obsolete)
Comment 11 eisa01 2018-06-15 21:41:32 UTC
I'm still seeing slowness following directions per comment #9

Was not like this is in LO 3.3, so inherited from OOo

Version: 6.2.0.0.alpha0+
Build ID: b292a27698e85fd9d60c03613c3b0c67835c4dc1
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-06-06_23:25:55
Locale: en-US (en_US.UTF-8); Calc: group threaded
Comment 12 Buovjaga 2018-07-11 18:35:46 UTC
After-change slowness reproduced on Linux as well.

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: bd394492c165d27c96a44495d9ca694a242acb8f
CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on July 11th 2018
Comment 13 Buovjaga 2018-07-11 20:02:15 UTC
Bisected with Linux 42max. Blamed commit has been blamed for several other similar issues. This might be considered a dupe...

commit 06271499c829a52c702c2c6dc8f99c2ec9c46fd3
Author: Matthew Francis <mjay.francis@gmail.com>
Date:   Sat Sep 5 20:42:38 2015 +0800

    source-hash-bcc51fb2ebdf77a1cc089857775fd742085b45b6
    
    commit bcc51fb2ebdf77a1cc089857775fd742085b45b6
    Author:     Noel Power <noel.power@suse.com>
    AuthorDate: Thu Aug 29 17:15:33 2013 +0100
    Commit:     Noel Power <noel.power@suse.com>
    CommitDate: Thu Aug 29 21:42:05 2013 +0100
    
        add support for in-place style preview
    
        selecting a style in the styles dialog ( without double clicking )
        will apply the style to the currently selected cell(s) You can
        with the keys navigate to other styles and they in turn will
        also be applied. Preview will end when you click back onto the
        document.
Comment 14 QA Administrators 2019-07-12 02:52:26 UTC Comment hidden (obsolete)
Comment 15 eisa01 2019-08-10 20:55:56 UTC
It's slower than Excel, and switching toolbar mode while having selected all cells take 10-15 seconds, so something is definitely wonky

Version: 6.4.0.0.alpha0+
Build ID: 54028dc503fc08eb12e287919d5e2850cff05b73
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-07-31_01:48:19
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 16 Buovjaga 2021-05-03 10:00:17 UTC
(In reply to Alex Thurgood from comment #9)
> How to reproduce :
> 
> 1) Open Excel sheet attached to current bug report.
> 2) Select all cells in sheet by clicking in upper leftmost corner outside of
> sheet
> 3) Click on font dropdown menu, the font list displays with previews where
> available.
> 4) Select a font from the list to apply to all cells.
> 
> 5) Now try selecting any cell with the mouse cursor >> Calc becomes very
> slow to respond, cells or cell selections get made that the user didn't
> actually select, the whole document becomes unresponsive.

No problem anymore, could others please re-test?

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 9c930c4f3109d123c0831d0fcecf9c8b32e5bbc7
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded
Comment 17 Buovjaga 2021-05-03 10:04:15 UTC
I'll go ahead and close this - another bug blaming the same commit is gone: bug 78254
Comment 18 Buovjaga 2021-05-04 14:02:23 UTC
Also tested on Linux and no problem either

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: dc4b4137520645495d1a7ead9744f515f53e5c84
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded