https://issues.apache.org/ooo/show_bug.cgi?id=122862
Bug ID: 122862
Issue Type: DEFECT
Summary: Advanced filter uses wrong Data Area
Product: Calc
Version: AOO 4.0.0
Hardware: PC
OS: Windows 7
Status: CONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Steps how to reproduce Reproducible with "AOO 4.0.0-Dev – German UI / German
locale [AOO400m3(Build:9702) - Rev. 1503709 (2013-07-17) ]" on German German
WIN7 Home Premium (64bit)", Common 4.0-dev User Profile:
1. Open attached sample document from AOO Start Center
2. Click cell A2 ("Product")
> Cell cursor appears around A2
3. Menu 'Data -> Filter -> Advanced Filter'
A1:F15 becomes selected
4. Continue in Advanced Filter Dialog 'Read Filter Criteria from-> "AnyWhere1"'
<ok>
Expected: Filter works, some rows in data area hiden
Actual: Error Message "The range does not contain a valid query"
Additional Info:
a) The reason for the problem is that range A1:F15 becomes selected instead of
A2:F15, what is defined in 'Data -> Define Area -> FilterArea'
b) Correct FilterArea A2:F15 will be selected if In step 3 you use 'Autofilter
-> Standard Filter' Dropdwon
c) so everything will work fin if in Step 2 you select range A2:F15
d) The problem here might be some leftover from
"Bug 40300 - Wrong automatic area selection in auto-filter "? I doubt
because of "e"
e) That still worked fine with OOo 1.1.5 ... 3.1.1 ... AOO 3.4.1
Already Reproducible with server installation of "AOO 4.0.0-Dev –
English UI / German locale [AOO400m1(Build:9700) -
Rev. 1457992 - Rev.1457606]" on German WIN7 Home Premium (64bit)",
own separate user profile (First AOO 4.0-Dev version available on my PC)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
