Issue 117332

Summary:	Applying autofilter in one sheet affects other sheets
Product:	Calc	Reporter:	danielpolansky <dan.polansky>
Component:	editing	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Normal
Priority:	P3	CC:	issues, rb.henschel
Version:	OOo 3.3 RC10	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	Windows Vista
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.