This option is working as it should, only problem is that if I want to have filter on more then 1 sheet last applied filter get deleted.
I use it for finding anomalities in company transactions and filter transactions by worker, but when I apply filter to another store filter on last store gets removed and if I want to check something there again I have to re-apply filter.
Reproducible with "LibreOffice 3.3.0 RC4 - WIN7 Home Premium (64bit) German UI [OOO330m19 (build 6 / tag 220.127.116.11)]".
I can use the Standard Filter in a document and modify latest settings several times to get the result I want to see; every time I reopen the filter dialog with menu 'Data > Filter > Standard Filter' I see my latest filter criteria and can do modifications I need. But when I have used a standard filter in an other sheet in between, display of filter criteria will have been lost after I will have returned to the sheet where I used a filter the first time.
Hello, (sorry for my English, I'm spanish speaker)
A workarround for this issue, is to assign a database range name:
Data > Define Range
Then, the filter remains active even if other filter on the document.
However this behavior must be improved.
Not reproducible on LO 18.104.22.168 (Win7 32bit). Perhaps it's been fixed.