If you have made autofilter for a spreadsheet, then after change data in area of the filter, you open the filter, but do not change filtering value, then nothing happens. The filter should always be updating when pressing ok.
You have to change filtering value and then change back to the value to have the filter reactivated.
Pressing ok should always filter according to values.
User Profile Reset: No
OpenGL enabled: Yes
This is how other software are working as an example Google sheets.
missing info about version you used, thus not sure answer, but looks as a dup of #130770, #131095, #131612, which are solved for 7.0 ver.
steps as described work ok (updating filtering without need to touch filter definition) with:
Version: 22.214.171.124.alpha1 (x64)
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI: en-US
setting resolved, pls. reopen if i'm wrong,
*** This bug has been marked as a duplicate of bug 130770 ***