Bug 84475 - VIEWING: High CPU / slowness after a full font replacement
Summary: VIEWING: High CPU / slowness after a full font replacement
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.6.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Performance CPU-AT-100%
  Show dependency treegraph
 
Reported: 2014-09-29 16:28 UTC by André L F S Bacci
Modified: 2024-04-25 06:39 UTC (History)
4 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 André L F S Bacci 2014-09-29 16:28:27 UTC
Steps to reproduce:
1. Open LibreOffice Spreadsheet.
2. Select all cells.
3. Change the font name to anything not installed (ex.: Tahoma).
4. Try navigante cells with cursor keys.

Current behavior:
High CPU / slowness navigating a empty spreadsheet.

Expected behavior:
Instantaneous response.
              
Operating System: Linux macrossv 3.13.0-36-generic #63-Ubuntu SMP Wed Sep 3 21:30:07 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
Enviroment: Gnome Flashback (Metacity)


This bug is driving me crazy. This is a fresh instalation, and opening documents from Windows machine now forces to reformat the entire spreadsheet to operate then...
Comment 1 Jean-Baptiste Faure 2014-09-29 20:29:43 UTC
Did you try to use the replacement table (menu Tools > Options > LibreOffice > Fonts) ?

Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding.

Best regards. JBF
Comment 2 André L F S Bacci 2014-10-01 19:57:40 UTC
Yes. I got 100% CPU/slow response even with the replacament table.

Creating entries on replacement table deepens a little the problem...
Comment 3 Buovjaga 2014-11-14 17:24:50 UTC
I only get it to about 60% CPU when cursoring up and down furiously, with or without non-installed font.

Ubuntu 14.10 64-bit Version: 4.4.0.0.alpha2+
Build ID: 5bff4b016c4b44f4123e0e6a4fd4c0c4dc0cfa2d
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-13_00:14:29
Comment 4 André L F S Bacci 2014-11-15 20:34:25 UTC
I'm getting the slowness with installed fonts too.

Steps to reproduce:
1. Open LibreOffice Spreadsheet.
2. Press and hold down key.
3. Select all cells (CTRL+A)
4. Change the font name
5. CRTL+Home and then press and hold down key.

(2) never go above ~16% CPU and is very responsive. (5) goes to 100% in one CPU and get sluggish/delayed.
Comment 5 Buovjaga 2014-11-16 06:22:05 UTC
Ah, you are right, I actually forgot to Ctrl-A in my previous test! I changed only some dozens of cells.
Now I got to 95% CPU. Let's set as NEW and see what devs think.
Comment 6 QA Administrators 2015-12-20 16:16:39 UTC Comment hidden (obsolete)
Comment 7 André L F S Bacci 2015-12-26 20:37:30 UTC
The bug still present at version 5.0.4.2. Tested for Windows 64 bits.
Comment 8 QA Administrators 2017-11-28 08:39:40 UTC Comment hidden (obsolete)
Comment 9 André L F S Bacci 2017-12-03 00:05:58 UTC
The bug is still present on lastest of https://www.libreoffice.org/download/ .

Version: 5.4.3.2
Build ID: 92a7159f7e4af62137622921e809f8546db437e5
CPU threads: 8; OS: Linux 3.13; UI render: default; VCL: gtk2; 
Locale: pt-BR (pt_BR.UTF-8); Calc: CL
Comment 10 QA Administrators 2018-12-04 03:47:39 UTC Comment hidden (obsolete)
Comment 11 Roman Kuznetsov 2019-12-30 10:10:23 UTC
no repro in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 2d736e1a0a2bbd41fe7793d52bbcc7bfc89c7da3
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

but it's possibly only Linux bug

Buovjaga, can you retest it yourself on Linux machine?
Comment 12 Buovjaga 2020-01-14 15:03:17 UTC
The CPU use is only 10 percentage points higher after changing the font. Let's close.

Arch Linux 64-bit
Version: 6.5.0.0.alpha0+
Build ID: 94c1f5cfb96a826220b64608cf0ada76d3bdde31
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: kf5; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 14 January 2020