Bug 134055 - "Format Cells" dialog box takes an extremely long time to appear (LibreOffice frozen for 42 seconds)
Summary: "Format Cells" dialog box takes an extremely long time to appear (LibreOffice...
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-16 23:04 UTC by Dan Weiss
Modified: 2020-10-12 05:39 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 Dan Weiss 2020-06-16 23:04:50 UTC
Description:
I'm having an issue with LibreOffice right now.  When I open the "Format Cells" dialog box, it takes 42 seconds of a frozen LibreOffice before the Format Cells dialog box finally appears.

This is not normal at all, something really screwy may be going on with my PC, is there any way to profile this and find out what is going wrong?

I have tried erasing the LibreOffice user profile.

Steps to Reproduce:
1. Open LibreOffice Calc
2. Right click on the first cell, select Format Cells
3. Wait 42 seconds

Actual Results:
LibreOffice is frozen for 42 seconds before the Format Cells dialog box finally appears.

Expected Results:
Format Cells dialog box should appear very quickly, within 250ms.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument

OS: Windows Version 10.0.19041.329
OS is 64bit: Yes
Comment 1 m_a_riosv 2020-06-17 21:18:53 UTC
About 4/5 seconds
Versión: 6.4.5.1 (x64)
Id. de compilación: be964ce243d03404cfeed53d0487f5d6bd49c627
Subprocs. CPU: 4; SO: Windows 10.0 Build 19608; Repres. IU: GL; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: threaded
Comment 2 Timur 2020-06-18 13:29:21 UTC Comment hidden (me-too)
Comment 3 Timur 2020-06-18 13:30:15 UTC
Rule of thumb is: search before reporting, both open and closed bugs.
If you had done that, you could've seen there were reports on that.
Never will be 250ms, 1st start is up to 8 secs, later 3-4 secs.
Someone wrote it's about fonts, maybe there's something specific or Win10.
42 sec is excessive and never heard.
Comment 4 m_a_riosv 2020-06-18 14:40:45 UTC
I have seen behaviors like that, not so long, some times at first running, after install or update, I think in relation with virus analysis in background.
Comment 5 Buovjaga 2020-10-11 11:39:28 UTC
Dan: to get back to the previous comments, does your system have an unusually large collection of fonts? What about antivirus analysis running in the background?
Comment 6 Dan Weiss 2020-10-11 16:34:32 UTC
I figured out the cause of the problem:

The Default Printer was set to a Wireless Printer that doesn't exist on the network, and that adding long delays (waiting for the printer to respond) in MANY different programs, including WordPad.

I wonder if there's a way to make Microsoft actually listen to a bug report, as your selected default printer should not be adding long delays everywhere.
Comment 7 QA Administrators 2020-10-12 04:27:12 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2020-10-12 05:39:08 UTC
Thanks for following up, let's close then.