as per subject. This unlike many other fields where cell addresses/ranges are to be entered.
Reproducible, Version: 5.4.2.2 (x64) Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale: es-ES (es_ES); Calc: group
CASE 1. A RANGE IS UNDEFINED I inserted by hand a cell location in the right field, the sorting list will go there, but that right filed should be a filed which alow to choose a cell from spreadsheet, not to be inserted by hand. CASE 2. A RANGE IS DEFINED I choose the range name and everything is ok. Version: 7.3.0.0.beta1+ (x64) / LibreOffice Community Build ID: 8c137ff0e201c2d0ecd1bb567496dbed8e5eced7 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ro-RO (ro_RO); UI: en-US Calc: threaded
still the case in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8843081f91e206b4749b83b186caaceaf1f8c4e3 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
> missing button What button is missing? > does not allow shrinking Shrinking of what? I will say, that the UI for "Copy sort results to" is confusing. * Why no labels for the drop-down listbox and for the textbox? * Do we need to enter a starting cell? A range to overwrite? In both cases - why do we need such a large textbox relative to the drop-down listbox? e.g. with long names of sheets? * What if I have 50 sheets? Why don't I get a combo box for sheet selection? * What does "Undefined" mean?
(In reply to Eyal Rozenberg from comment #4) > What button is missing? To select the range where to copy to (see e.g. pivot tables, and many other places) >> does not allow shrinking > Shrinking of what? That behavior comes with the button: the dialog shrinks to the range field. Sorry that my report was a bit too brief.
(In reply to Eyal Rozenberg from comment #4) > * Why no labels for the drop-down listbox and for the textbox? The label of the check box says it? > ... > * What if I have 50 sheets? Why don't I get a combo box for sheet selection? I guess - but you can test it, that the Navigator allows you to pick one (if the missing button/behavior is provided). > * What does "Undefined" mean? That box is for selecting named ranges, defined in the document.
We discussed the topic in the design meeting. Whether you enter a range or a cell address, the target is always filled with the source. The function will not limit the results like SORT(A1:A5) and cut-off at two items. Changing this behavior might be convenient in a few scenarios but would be unexpected and error-prone in most other. As for the UI we may change the dialog and add a reference (aka "shrink") button to the field that would accept only single cells. Labels should help to make the UI clear. Could be: "Start cell: [ ] <shink> from: <range>" If this sequence takes too much space, we could go with just "At" or use labels more sparingly or place controls in two lines.
(In reply to Heiko Tietze from comment #7) > Whether you enter a range or a cell address, the target is always filled > with the source. The function will not limit the results like SORT(A1:A5) Correct. Same applies for Pivot Tables (checked that one) and I guess all other occurrences. > As for the UI we may change the dialog and add a reference (aka "shrink") > button to the field that would accept only single cells. Labels should help > to make the UI clear. Could be: > > "Start cell: [ ] <shink> from: <range>" In Pivot Tables the label is "Selection"; "Cell address" would be an option too? (by the way wondering what happens in CTL.. but guessing that also for these situation, having one cell address as target is cleaner.)