<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILTER + VIEWING (Freeze first row): Calc hangs and uses 100% CPU"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121595">121595</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILTER + VIEWING (Freeze first row): Calc hangs and uses 100% CPU
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.2.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kaustuv.saha@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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 <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc freezes with auto-filter and row/column freeze (Wayland only)"
href="show_bug.cgi?id=120385">bug 120385</a>. 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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>