Bug 33633

Summary:	DATA / FILTER / STANDARD FILTER criteria should not be lost after having used standard filter in an other sheet
Product:	LibreOffice	Reporter:	Mikeyy - L10n HR <mihovil>
Component:	Spreadsheet	Assignee:	Katarina Behrens <bubli>
Status:	RESOLVED WORKSFORME	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	LibreOffice
Version:	3.3.0 release
Hardware:	Other
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:

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 3.3.0.4)]".

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.

Enhancement!

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 4.0.4.1 (Win7 32bit). Perhaps it's been fixed.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.