Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.