After going through bug 150936 the user pointed out to the fact that the Advanced filter does not use the selected cell range by default, which would be very handy. Steps to reproduce 1) Create a new ODS file and populate a column with values (f.i. range A1:A10) 2) Select the range A1:A10 3) Go to Data - More filters - Advanced filter 4) Notice that the "Read filter criteria from" field is empty; to apply a filter to range A1:A10 the user will have to select it again Expected result The "Read filter criteria from" should have the selected range "A1:A10" in it by default (similar to what the solver currently does with the "Target Cell") System info Version: 7.3.5.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.5-0ubuntu0.22.04.1 Calc: threaded
What if the "criteria" is not the entire range, but a specific value in some specific cell (that may or may not be part of the range to be filtered)? For example, say the list is in A2:A11, and the criteria to filter that range is in C2. What I am trying to say is that the name of the box, "Read Filter Criteria From" seems already confusing. A user could wonder: is this field/box aimed at the entire range to be filtered, or is the criteria by which to filter a certain range? The request to pre-fill the box with the selected range is entirely reasonable (as the default range for the field). I'm just adding that the field / dialog seems unclear and partly not working as users would expect (as shown in the original bug 150936).
While there are many use cases that make it necessary to change the parameters, I see no harm in using a selection on start. Btw, if I define a range it's neither listed in this dialog nor using the name instead of the actual range is accepted. What is this dropdown about at all?
We discussed the topic in the design meeting, and there is no objection to prefill the input controls. Regarding the label we may change it to a more common string like "Select Range" but it's questionable if this renaming makes anything more clear for users.