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

On 3/31/2015 11:49 PM, Michael Wu wrote:
Valter Mura 於 2015/4/1 上午 04:07 寫道:

Il 25/03/2015 23:42, Richard VINCK ha scritto:
Hello at the nice people at LibreOffice! (especially you :-) )

I'm using LibreOffice version

I was very surprised to see a bug (?!) in the internal SORT function
of Calc.

Please fill the following cells with a simple letter:

Now select those 6 cells and click on the Down/Up arrow in the toolbar
(Sort), select Sort Key 1 : Z, Ascending, then click OK. Expected
result was B-P-Q-R-Y-Z, but the Z did not move at all ! =-O
This is undoubtedly a serious bug... and nobody has detected this
before? How strange.

For me, the bug is confirmed. First cell doesn't sort.

Build ID: 430m0(Build:2)
Linux Environment


It is seemed the first cell is used as a label, not data. If we add one
more cell L16, set L16=Test, and select those 7 cells ( L16 ~ L22 ) to
sort, then we will get the result B-P-Q-R-Y-Z.

Hope it helps and best regards.


The above test DOES treat the first cell in the range as a column LABEL. If you do the sort using the menu (Data > Sort), the box that opens up contains two tabs (Sort Criteria, & Options). Again, the default is to treat the top cell as a LABEL. If you do NOT HAVE any column labels, you have to go to the OPTIONS tab (every time) and UN-SELECT the "Range Contains Column Labels" box.

Technically, this does not appear to be a bug. (It appears to be intentional design.) But I believe it is a poor design. That "Range Contains Column Labels" checkbox SHOULD be on the SORT CRITERIA tab, so that the user sees it every time he performs the sort operation. Likewise, using one of the SORT icons should also open up that same box. The only difference should be that the default sort order changes depending on which icon is hit.

LO Version:
Windows 7 64-bit

-- Tim

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.