https://bugs.documentfoundation.org/show_bug.cgi?id=113247
--- Comment #8 from Cor Nouws <[email protected]> --- (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.) -- You are receiving this mail because: You are the assignee for the bug.
