Issue 123240

Summary: 'Advanced filter criteria' range name of applied filter should stay in selector
Product: Calc Reporter: fanyuzhen
Component: uiAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact: fanyuzhen
Severity: Trivial    
Priority: P5 (lowest) CC: issues, liushenf, rainerbielefeld_ooo_qa
Version: 3.4.0Keywords: needmoreinfo
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Sample Document
none
Disappeared setting in AdvancedFilter dialog none

Description fanyuzhen 2013-09-12 03:35:50 UTC
Steps:
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' 
    A2:F15 becomes selected
4. Continue in Advanced Filter Dialog 'Read Filter Criteria from-> "AnyWhere1"' 
   <ok>
   > Filter works, some rows in data area hidden
5. Open Advanced Filter Dialog by click menu 'Data -> Filter -> Advanced Filter'
   Expected: "AnyWhere1" displays as value showed in dropdown (please see AdvancedFilter dialog_r1521070.png attached)
   Actual: "- undefined -" displays as value showed in dropdown
Comment 1 Rainer Bielefeld 2013-09-12 04:56:33 UTC
Some additional info
-------------------
a) This one is a spin off from "Bug 122862 - Advanced filter uses wrong Data Area",
Comment 
<https://issues.apache.org/ooo/show_bug.cgi?id=122862#c23>
Comments 18 ,28

b) Not a new issue, this never was different in AOO / OOo, so I change Version.

c) You can test that with Attachment 81177 [details]  for Bug 122862

d) Screenshot: Attachment 81518 [details] for Bug 122862

e) I think we are not talking about a DEFECT here, but may be it's an
   enhancement request
	
f) I disagree with CONFIRMED because of following reasons and switch back to 
   UNCONFIRMED fo now
f1) IMHO this request here misunderstands intention of the "Read filter 
    criteria from" selector. It simple helps to fill the cells range pane
    at it's right with a correct filter criteria range
f2) If that field really should show the last applied filter many rules would be
    required
f2a) Manual chnages in cells range field should make disappear the area name
     (that's already implemented)
f2b) Criteria selector contents should switch back to "undefined" if 
     filter has not been applied with selected range, but should be 
     kept if the filter has been applied
f2c) Criteria selector contents should switch back to "undefined" if 
     other filter has been applied afterwards
f2d) How should be shown if contents in Filter definition has changed after
     filter has been applied?
f2e) May be many other things have to be considered

g) so the question is whether that ever can work in a reliable way and whether costs for a modification are acceptable for (may be) very small benefit.

@fanyuzhen:
Can you contribute some ideas concerning "real life benefit" of the requested behavior?
Comment 2 fanyuzhen 2013-09-12 06:16:34 UTC
Created attachment 81523 [details]
Sample Document
Comment 3 fanyuzhen 2013-09-12 06:21:13 UTC
Created attachment 81524 [details]
Disappeared setting in AdvancedFilter dialog
Comment 4 Rainer Bielefeld 2013-09-12 08:26:20 UTC
Comment on attachment 81523 [details]
Sample Document

No new information in this clone of existing Attachment 81177 [details] for Bug 122862, so I make this one obsolete.

@fanyuzhen@gmail.com:
Please do not flood Bugzilla with clones of existing attachments, for details please see <http://wiki.openoffice.org/wiki/BUGZILLA/FAQ#How_to_use_attached_sample_documents_for_multiple_Bug_Reports>
Comment 5 Rainer Bielefeld 2013-09-12 08:31:02 UTC
Comment on attachment 81524 [details]
Disappeared setting in AdvancedFilter dialog

No new information in this clone of existing Attachment 81518 [details] for Bug 122862 (cited in original report), so I make this one obsolete.

@fanyuzhen:
Please answer to questions (but do not repeat already known information).
Comment 6 Edwin Sharp 2014-01-14 14:00:10 UTC
Hijacked bug.
Reporting to Internet police.