Re: [libreoffice-users] FEATURE REQUEST -- for the Sort options in Calc

At 15:22 28/03/2015 +0100, Stefan Weigel wrote:
> When sorting, it's not recommended to select a range, rather than a 
> single cell. Calc (or Excel) will select the range to be sorted by 
> its own. Selecting a specific range before sorting is only helpful 
> for very special cases, when automatic selection fails.
>
> FYI: RTFM and study the rule "For sorting, filtering, or using the 
> Pivot Table, always select only one cell." on page no. 4 of this 
> official manual:
> https://wiki.documentfoundation.org/images/6/69/CG4108-PivotTables.pdf
>
> Unfortunately, the chapter of the manual, that specifically deals 
> with sorting, does not mention this rule. :-/

Interestingly, Chapter 2 does include a couple of useful comments. 
The basic sort instructions do indeed say "Select the cells to be 
sorted" - with no suggestion that you can just put the cursor into a 
single cell and leave Calc to guess the range to be sorted. But 
later, under "Quick sort" (using buttons: what the original enquiry 
was about), it makes the important proviso "*If the columns in your 
spreadsheet have a header with a text format*, you can use a quick 
sort" (my emphasis), as well as saying "Select a cell or a cell range 
to be sorted."

Brian Barker  


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted