<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Autofilter performance against undefined column headers regressed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133804">bug 133804</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Autofilter performance regressed from 9 seconds to 27 seconds
</td>
<td>Autofilter performance against undefined column headers regressed
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Autofilter performance against undefined column headers regressed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133804#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Autofilter performance against undefined column headers regressed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133804">bug 133804</a>
from <span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span></b>
<pre>(In reply to Telesto from <a href="show_bug.cgi?id=133804#c8">comment #8</a>)
<span class="quote">> (In reply to Xisco Faulí from <a href="show_bug.cgi?id=133804#c7">comment #7</a>)
> > (In reply to Telesto from <a href="show_bug.cgi?id=133804#c6">comment #6</a>)
> > > NEW file
> > > 1. Open the attached file
> > > 2. Column H uncheck 23359 -> Wait
> > > 3. Click Drop down column D -> Wait again
> >
>
> Step 2: 19 seconds -> previously 4.1: 0,5 second
> Step 3: 17 seconds -> previously 4.1: 0,5 second</span >
OK, see some delay...
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 59939d2490726336546c7ad05082d23031074e12
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Seems happier (as in NO delay) if I simply populate the 1st row with column
labels, and apply the 'AutoFiler' against the row with the lables--rather than
the first row with data.
Then Inserting rows above the now column labeled row does not degrade--so issue
seems to be with the autofilter applied to selected data rows without column
headers.
LO has some sense of this status, as with AutoFilter set simply removing the
rows with column header will prompt:
The range does not contain column headers.
Do you want the first line to be used as column header?
So, add the column headers back into the sample file and retest.
And, why would lack of column headers make the filter action so much slower?</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>