Apache OpenOffice (AOO) Bugzilla – Issue 123240
'Advanced filter criteria' range name of applied filter should stay in selector
Last modified: 2014-01-28 07:55:33 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
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?
Created attachment 81523 [details] Sample Document
Created attachment 81524 [details] Disappeared setting in AdvancedFilter dialog
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 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).
Hijacked bug. Reporting to Internet police.