Issue 117332 - Applying autofilter in one sheet affects other sheets
Summary: Applying autofilter in one sheet affects other sheets
Status: CLOSED DUPLICATE of issue 12666
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.3 RC10
Hardware: PC Windows Vista
: P3 Normal (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2011-03-11 11:02 UTC by danielpolansky
Modified: 2012-06-13 12:25 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description danielpolansky 2011-03-11 11:02:06 UTC
Applying the autofilter to one sheet removes the autofilter from another sheet.

Steps to reproduce:
1. Create a new workbook
2. In sheet 1 of the workbook, enter some data, like "a\tb\n1\t1" (\t for next cell, \n for next row)
3. In sheet 2 of the workbook, enter some data, like "c\td\n1\t1"
4. In sheet 1, apply autofilter from menu Data > Filter > Autofilter (or the like; I do not have an English version)
5. In sheet 2, apply autofilter from menu Data > Filter > Autofilter
6. Switch over to sheet 1
7. Observation: the autofilter that was in sheet 1 is gone, as it should not

OOo version: OOO330m20 (build:9567)
OS version: Windows Vista

--Dan Polansky
Comment 1 Regina Henschel 2011-03-11 13:46:49 UTC
Target milestone OOo3.3 is impossible, because OOo3.3 is already released.

You can have only one anonymous autofilter range. So for using more than one autofilter, you have to name the data range on which the autofilter works.

*** This issue has been marked as a duplicate of issue 12666 ***
Comment 2 Regina Henschel 2011-03-11 13:58:00 UTC
closing, duplicate
Comment 3 Oliver-Rainer Wittmann 2012-06-13 12:25:17 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.