Description: When freezing the first row and also enabling auto-filter for the first row, if we try to filter on the first column values and if any of the other column values is text, then the filter dialog and Calc hangs while CPU usage becomes 100%. Steps to Reproduce: 1. Create a simple .xlsx file with 1 sheet. 2. The sheet contains a set of headings in the first row and values in other rows, below each heading. The values are a mix of numbers and text. 3. Freeze the first row and then enable auto-filter for the first row. The sequence should not matter. 4. Try to filter all the rows of data based on a simple filter criteria, "first column value = x" using the auto-filter dialog. Actual Results: Calc hangs and does not filter the data based on the criteria. Calc starts to consume 100% CPU. Expected Results: The rows should have been filtered based on the criteria, "first column value = x". Calc should not hang or consume 100% CPU. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: This seems somewhat related to bug 120385. When creating the example file, I noted that if the values in all other columns are numbers, then Calc performs correctly and doesn't hang. But if the value in 1 (or more) column(s) is text, then it hangs. Since I'm running Fedora 29, I'm also using Wayland by default. Information from "Help - About LibreOffice": Version: 6.1.2.1 Build ID: 6.1.2.1-3.fc29 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group threaded
Created attachment 146881 [details] Example file to reproduce the bug
I can't reproduce it in Version: 6.3.0.0.alpha0+ Build ID: 1977291fc08de7425db469e21bd2ad385e722707 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 nor in Version: 6.1.4.2 Build ID: 1:6.1.4-0ubuntu0.16.04.1~lo2 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
>Since I'm running Fedora 29, I'm also using Wayland by default. Caolan, can you look at this?
Its an accessibility bug. Calc grid is effectively infinite and we get tricked into searching all the grid cells *** This bug has been marked as a duplicate of bug 121855 ***
kaustuv.saha@gmail.com, you should update your LibreOffice to 6.1.5
I'm unable to reproduce the earlier behaviour with the latest version of LibreOffice that I have now (6.1.5.2). Thanks!