Bug 125623 - EDITING: drop down list causes Calc to freeze
Summary: EDITING: drop down list causes Calc to freeze
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-01 15:09 UTC by jranderson1990
Modified: 2020-04-01 07:39 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet used that caused the problem. Problematic sheet named Output (85.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-06-01 15:09 UTC, jranderson1990
Details
Trivial ODS reproducing the problem (8.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-09-01 18:49 UTC, Jan Kratochvil
Details
Screenshot of the locked up state (125.01 KB, image/png)
2019-09-01 18:53 UTC, Jan Kratochvil
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jranderson1990 2019-06-01 15:09:45 UTC
Created attachment 151832 [details]
Spreadsheet used that caused the problem. Problematic sheet named Output

When editing the attached spreadsheet, LibreOffice Calc will sometimes lock up. The nature of the lockup is that the entire window manager becomes unresponsive to mouse clicks (though alt+tab into a terminal still works) until the soffice.bin process is killed. 

Steps to reproduce:
1. Open spreadsheet.
2. Navigate to 'Output' sheet
3. Edit the data validation for one of the drop downs (right-click on the cell -> Data validation, and edit the source line) -or- select a value from one of the drop downs. 
  3a. Drop downs can be found in cells B3, C3, F14-21.

Sometimes the lockup immediately occurred, and other times it happened only after I had made a few edits.

Testing against Gnumeric shows the lockup does not occur there, but Gnumeric has other limitations that keeps it from being a true workaround (mostly with respect to it not correctly handling the formulas). 

OS: Ubuntu 18.04
Versions affected: 6.0.3.2, 6.2.4, 6.3.0 alpha
Comment 1 Xisco Faulí 2019-06-06 16:27:18 UTC
I can't reproduce it in

Version: 6.4.0.0.alpha0+
Build ID: 0d6ec494f83fb26524bf3a5fc7af27c225293e87
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

Could you please paste the info from Help - about LibreOffice ?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' once the information has been provided
Comment 2 jranderson1990 2019-06-06 17:24:07 UTC
From Libreoffice 6.2:

Version: 6.2.4.2
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: CL


From Libreoffice 6.3 alpha:

Version: 6.3.0.0.alpha1
Build ID: 547edd20e527fb02900f6174973770d26306e2e7
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: CL
Comment 3 raal 2019-08-13 15:39:57 UTC
I cannot confirm with Version: 6.4.0.0.alpha0+
Build ID: 2812610f4f39ed5892da08864893c758325d1d39
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Comment 4 Jan Kratochvil 2019-09-01 18:49:34 UTC
Created attachment 153798 [details]
Trivial ODS reproducing the problem

Reproducible for me on Fedora 30 x86_64 both MATE and Workstation (=Gnome 3):
libreoffice-calc-6.2.6.2-2.fc30.x86_64

It takes some time (2 minutes) clicking randomly opening and closing the drop-down box, selecting entries, clicking away and again.
Comment 5 Jan Kratochvil 2019-09-01 18:53:45 UTC
Created attachment 153799 [details]
Screenshot of the locked up state

With the mouse locked up I can edit the cell (cursor is in the spreadsheel at "editinghere", not in the top input box with the same text).
On Fedora MATE hitting Escape twice unlocks the mouse (although then I still cannot click menu of Calc, despite I can open the File menu by alt+F).
(First Escape hit resets the cell value.)
On Fedora Workstation (Gnome 3) the Escape key had no effect.
Comment 6 Jean-Baptiste Faure 2020-03-31 20:23:36 UTC
Not reproducible for me with

Version : 6.4.4.0.0+
Build ID : d8a6757a46898a334a3e8bad8cb77dcd19482939
Threads CPU : 4; OS : Linux 4.15; UI Render : par défaut; VCL: gtk3; 
Ubuntu_18.04_x86-64
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

Best regards. JBF
Comment 7 Jan Kratochvil 2020-03-31 21:15:57 UTC
Tried to reproduce it now but I have it unreproducible now, tested:
libreoffice-calc-6.2.8.2-2.fc30.x86_64
libreoffice-calc-6.3.5.2-3.fc31.x86_64
Comment 8 Jean-Baptiste Faure 2020-04-01 07:39:11 UTC
(In reply to Jan Kratochvil from comment #7)
> Tried to reproduce it now but I have it unreproducible now, tested:
> libreoffice-calc-6.2.8.2-2.fc30.x86_64
> libreoffice-calc-6.3.5.2-3.fc31.x86_64

OK, thank you for these new test. So closing as WorksForMe. Please, feel free to reopen if you disagree.

Best regards. JBF