Bug 38548 - Auto Filter can be applied only for one sheet
Summary: Auto Filter can be applied only for one sheet
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-21 23:19 UTC by Lior Kaplan
Modified: 2012-06-15 00:59 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Lior Kaplan 2011-06-21 23:19:27 UTC 
I have a spreadsheet file with two sheets.

I applied an Auto Filter for the first sheet, and went to the 2nd and did the same. When I got back to the first sheet I found out that the Auto Filter disappeared.

I played with it some more, reaching the conclusion that the filter can be applied on only one sheet in a given time.

I believe that he wanted behavior is to have Auto Filter for each sheet separately.

Tested with LibreOffice 3.3.3 on Debian unstable (tag libreoffice-3.3.3.1).
Comment 1 vitriol 2011-06-21 23:32:56 UTC 
This functionality should be implemented in version 3.4.x. Please, try it.
I close this bug for now.
Comment 2 Markus Mohrhard 2011-06-22 03:25:38 UTC 
As vitriol metioned this is only implemented in 3.4, but there is a workaround.

Go to Data->Define Range and create a named database range. Select this range and go to Data->Filter->Autofilter. This filter is attached to the named range and not the unnamed range and will not be overriden by a different filter.