Description: If you open a large spreadsheet containing thousands of rows and use ctrl+f to search for a text string that does not exist in the file, Librecalc freezes until it's searched the entire document, preventing even the search from being cancelled. Steps to Reproduce: 1. Open large spreadsheet containing at least 3000 rows. 2. Press ctrl+f and search for random text that isn't in the file. 3. Notice the entire window freezes and you can't even cancel the search for several seconds, sometimes up to a few minutes depending on the speed of your system. Actual Results: Search freezes entire window. Expected Results: Search should run in the background and not block the UI and be cancellable by the user. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.6 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
I have tested with a 50000 rows sheet, and not issue with Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL On one side, 6.4 it's EOL, so no new revisions. Please try with a newer version. https://www.libreoffice.org/download/download-libreoffice/ Or if the issue is only with one file, please attach it here after depersonalizing it.
I just installed 7.4.2.3 from the PPA and the problem still exists. Search does seem a little bit faster though, so maybe if you're on a fast machine, you don't notice the issue as much? Try testing with a file containing 100,000 rows. The search still blocks the UI. Whether it blocks it for a few seconds or a minute, that feels like a significant problem that only becomes bigger as the filesize scales up. Version: 7.4.2.3 / LibreOffice Community Build ID: 40(Build:3) CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.4.2~rc3-0ubuntu0.20.04.1~lo1 Calc: threaded
Also, confirm you're trying these reproduction steps. 1. Press ctrl+f 2. Enter long random text, e.g. "sdlfksjklfjsdlfewilfuoiefsjlffl" 3. Press enter to begin the search. 4. *Immediately* press the "x" next to the search field to cancel the search. 5. Note that you can't cancel the search until the search completes, as the UI is frozen.
NOT reproducible with Spreadsheet from https://www.filemail.com/d/exdbkshezqcosfo and Installation of Version:7.4.2.3 (x64) Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE | Calc: threaded | ElementaryTheme | My normal User Profile on AMD Ryzen 5 3600 6-Core Processor 3.60 GHz 16GB RAM, SSD 1. Launch LibO 2. Open attachment from FileMail 3. <ctrl+f> for find 4. Type "sdlfksjklfjsdlfewilfuoiefsjlffl" info search string line (or alternatively for second attempt es-ES (es_ES); UI: en-US Calc: CL) 5. <Enter> » Search starts, terminates after 2 seconds or so and search string input line gets red background for "not found" 👌 third attempt: 31. redo (1) ... (5) 36. Click terminate-search-X left from input line as fast as you can » Search terminates after 2 seconds or so and search string input line gets red background for "not found" 👌 Additional info ---------------- a) Linux related? b) Related to User Profile c) Related to Addons or similar? @reporter, please b1) Try with newly created user profile c1) Try in safe mode d) Tell Computer details