Issue 123163 - Only one Autofilter per sheet and not any longer per named database range
Summary: Only one Autofilter per sheet and not any longer per named database range
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: 4.0.1
Assignee: Oliver-Rainer Wittmann
QA Contact:
URL:
Keywords: regression
Depends on: 122862
Blocks:
  Show dependency tree
 
Reported: 2013-09-02 14:19 UTC by burnuser
Modified: 2017-05-20 10:33 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---
jsc: 4.0.1_release_blocker+

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

Note You need to log in before you can comment on or make changes to this issue.
Description burnuser 2013-09-02 14:19:19 UTC 
In OO < 4.0 there was only one Autofilter per document for unnamed cell ranges. But it was possible to have an Autofilter for each named datebase range. Also if there was more than one on a single sheet.

In OO 4.0 you can use Autofilter on each sheet, but only one per sheet. The named database range as multiple filterbase does not work any longer.
Comment 1 Oliver-Rainer Wittmann 2013-09-04 10:46:42 UTC 
I can confirm this defect.

It is a regression compared to AOO 3.4.1

It is also - as bug 122862, bug 122870 and bug 122955 - caused by the changes made for bug 12666
Comment 2 Oliver-Rainer Wittmann 2013-09-05 13:28:10 UTC 
working on a fix.

If the fix does not work, I will revert the changes from bug 12666 to get this regression fixed for AOO 4.0.1
Comment 3 jsc 2013-09-06 08:07:24 UTC 
approve showstopper request
Comment 4 burnuser 2013-09-06 08:13:43 UTC 
Please check your fix also against bug 123161 (if it is a result of the same problem ...)
And maybe have a look at the solution in LibreOffice where Autofilter works per sheet and per database range.
Comment 5 Oliver-Rainer Wittmann 2013-09-10 09:05:55 UTC 
This issue will be fixed by the changes made for bug 122862.
Comment 6 Oliver-Rainer Wittmann 2013-09-11 15:01:57 UTC 
fixed on trunk and branch AOO401 by the fix for bug 122862
Comment 7 fanyuzhen 2013-09-18 14:23:12 UTC 
It's verified fixed in build AOO401m4(Build:9713)  -  Rev. 1521921 based on the attached sample document