<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 - Autofilter can't be easily/obviously updated"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=133492">133492</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Autofilter can't be easily/obviously updated
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>6.4.3.2 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </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>tin@new-life.org.au
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
When using autofilter, in older versions, the filter could be reapplied/re-run
across updated data by simply opening the filter dropdown on any already
filtered column, and simply clicking OK without changing any options. This is
something I was doing fairly regularly with larger lists where the freshly
updated data could be filtered out to reduce wasted screen space.

At some stage, this has been changed so that nothing is updated unless at least
one filter setting is changed. Presumably this is to optimise the filtering so
it doesn't get re-run on unchanged data... However it also does not get re-run
if the data set has been modified, and there is no obvious way to re-run the
filter without making a change, clicking OK, re-opening the dropdown and
changing it back.

Steps to Reproduce:
1.Create/load table of data that is suitable for filtering.
2.Enable autofilter
3.Filter out some data using the autofilter
4.Edit the document in such a way that the changes should be filtered out by
the existing filter
5.Open autofilter dropdown dialog from top row and click OK

Actual Results:
Nothing happens.

Expected Results:
Filter should re-run and filter out any expected filtered rows.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.3.2
Build ID: 1:6.4.3-0ubuntu0.20.04.1
CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: kf5; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes</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>