Description: Spreadsheet with lotto results. 'Find' a number e.g. 28. All cells with 28 are shown as well as a 'Search results' dialog. Untick 'Show this Dialog' and close the dialog. Back into the 'Find' box, enter a different number and click 'Find All'. Calc now hangs and needs to be closed (Force Quit). It is repeatable. Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.1 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: en-NZ (en_NZ.UTF-8); UI-Language: en-US Calc: threaded Steps to Reproduce: 1. search for cell content 2. untick dialog for show this dialog 3. search again Actual Results: hanging Expected Results: Unresponsive Reproducible: Always User Profile Reset: Yes Additional Info: display new highlighted cells for search results also happens in safe mode OpenGL: OpenGL vendor string: Intel OpenGL renderer string: Mesa Intel(R) HD Graphics 630 (KBL GT2) OpenGL core profile version string: 4.6 (Core Profile) Mesa 21.0.3 OpenGL core profile shading language version string: 4.60 OpenGL core profile context flags: (none) OpenGL core profile profile mask: core profile OpenGL core profile extensions: OpenGL version string: 4.6 (Compatibility Profile) Mesa 21.0.3 OpenGL shading language version string: 4.60 OpenGL context flags: (none) OpenGL profile mask: compatibility profile OpenGL extensions: OpenGL ES profile version string: OpenGL ES 3.2 Mesa 21.0.3 OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.20 OpenGL ES profile extensions:
Turns out that clicking a cell for example before trying a second search, seems to clear something and the second search works fine. So only the sequence I outlined causes a hangup. I'm happy with my workaround for now: search - click somewhere - search again, works search, search again doesn't work.
No problem in Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: e06ba31a037ea3ff192c9a00db6152179eb298a6 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL Could you please install LibreOffice 7.1.6 from an official site https://libreoffice.org/download and try repeat your problem?
Request from maintainer: Could you please install LibreOffice 7.1.6 from an official site https://libreoffice.org/download and try repeat your problem? My reply: I run Linux Mint 20.2 and rely on PPA's to update software. The current version of Calc in Mint is 6.4.7.2! Quite old. The Mint Software Installer also suggests 6.4.7. for LibreOffice. Looks like this is a case of 'PPA too slow' and I'll take it up with Mint.
[Automated Action] NeedInfo-To-Unconfirmed
You can give a try at: https://www.osradar.com/microsoft-libre-office-ubuntu-linux/ to upgrade LO.
Installed from Flatpak. Now running 7.2.2.2. Bug's gone...... Thank you.
So let's close this one, I think it's a Mint's LO build problem only
Bug is still there: Version: 7.2.2.2 / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-NZ (en_NZ.UTF-8); UI: en-US Flatpak Calc: threaded Does not happen with all spreadsheets, but is repeatable with this one: https://assets.mylotto.co.nz/assets/uploads/423829ee-4265-11ec-900f-90817b0e0c2d.xlsx Do a 'Find a number' 3 or 4 times and Calc hangs. After the 'unresponsive' message it closes. Then try to start Calc again and the progress bar remains blank. It completely hangs and the process needs to be killed. A subsequent attempt to 'recover' after opening (and a system restart) also hangs Calc.