Feel like this is a recent bug/issue I saw in the last few days (or week).

• Apply an Auto Filter to data.

• Select a few filter criteria on some columns. - and then here the data gets filtered/subset based on the filter criteria.

• Go to Data->Auto Filter->Reset Filter - all the data rows reappear, however the same filter criteria appear to be active on the columns filtered previously.

  • Click the columns, and see that the criteria is still active. But remember, all the data is now showing.

• Go to another column and try to apply a new filter - can't do that because that column's filter criteria are filtered based on the previously applied criteria.

• So to reset filter - go to each column manually and select All filter criteria.

Hope I explained it clearly.

Did I accidentally flip some setting or switch? Or has anyone else noticed this as well?

EDIT: Kind related to this, I notice my Auto Filter gets really slow above 1000 rows or so of data. Anything I can change? I'm on Ubuntu 18.04, LibreOffice version 6.3.0.4

Why is it like Libre office is sluggish in scrolling through huge sheets of data
i have a data of my college {i cannot share because of confidential details}

I downloaded a sample sheet to do so Libreoffice lags as shown in the video but only office does not
dont comment the file format cause my college data is in .ods format
This was the same issue with collabora office and it is somthing from my end i dont understand
please help
**i use linux mint intel i3 2100 12 GB Ram and i have Libre office 7.5.9 installed in the system**
{out of the context question why my simple screen recorder is stuck at light theme even tho i have dark theme enabled throughout the video}