On 3/31/2015 11:49 PM, Michael Wu wrote:
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.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 184.108.40.206 I was very surprised to see a bug (?!) in the internal SORT function of Calc. Please fill the following cells with a simple letter: L17=Z L18=B L19=Y L20=R L21=Q L22=PNow 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 ! =-OThis is undoubtedly a serious bug... and nobody has detected this before? How strange.For me, the bug is confirmed. First cell doesn't sort. LibreOffice 220.127.116.11 Build ID: 430m0(Build:2) Linux Environment CiaoIt 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. Michael
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: 18.104.22.168 Windows 7 64-bit -- Tim -- To unsubscribe e-mail to: email@example.com 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