Bug 33633 - DATA / FILTER / STANDARD FILTER criteria should not be lost after having used standard filter in an other sheet
Summary: DATA / FILTER / STANDARD FILTER criteria should not be lost after having used...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: Other Windows (All)
: medium enhancement
Assignee: Katarina Behrens
Depends on:
Reported: 2011-01-27 21:33 UTC by Mikeyy - L10n HR
Modified: 2013-06-09 15:46 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Mikeyy - L10n HR 2011-01-27 21:33:24 UTC
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.
Comment 1 Rainer Bielefeld Retired 2011-01-27 22:47:07 UTC
Reproducible with "LibreOffice 3.3.0 RC4 - WIN7  Home Premium (64bit) German UI  [OOO330m19 (build 6 / tag]".

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.

Comment 2 ifanlo 2011-02-04 09:44:46 UTC
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.
Comment 3 ign_christian 2013-06-09 15:46:16 UTC
Not reproducible on LO (Win7 32bit). Perhaps it's been fixed.