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
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:
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:
Unfortunately, the chapter of the manual, that specifically deals
with sorting, does not mention this rule. :-/
LibreOffice - Die Freiheit nehm' ich mir!
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy