Hi, Am 26.03.2015 um 01:57 schrieb Richard VINCK:
> For logical and safety reasons, and for compatibility with Microsoft > Excel, I suggest that: > * The Sort Option "Range contains column labels" be_unticked by > default. Your suggestion does *not* establish compatibility with Microsoft Excel. Excel tries to *guess* whether the first row of your selection has to be sorted or not, by checking for significant differences between the first row and the subsequent rows in data type and/or formatting. Try yourself in Excel: Z 1 3 A 2 will disappoint your expectations, as well. ;-) > It is good that LibreOffice has this option, but a beginner don't > know that option and will sort what he/she has selected, and it is > frustrating to see that the first column is not sorted at all, > thinking it's a bug (like I did). 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. :-/ Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: [email protected] 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
