Hi :) So changing it is a "Feature request" and it might be handy if you, or whoever posts it in the bug-reporting system, gives us a clickable link so that we can maybe show that the change would be quite popular.
Feels like you are getting somewhere with this! The next bit might have a looong lead-time or lag but it'd be nice to start on that next step. Does anyone have time to post such a report? Regards from Tom :) On 1 April 2015 at 07:45, Tim Deaton <[email protected]> wrote: > 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 4.4.1.2 >>>> >>>> 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=P >>>> >>>> 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. >>> >>> LibreOffice 4.3.3.2 >>> Build ID: 430m0(Build:2) >>> Linux Environment >>> >>> >>> Ciao >>> >>> 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. >> >> >> Michael >> >> 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: 4.3.5.2 > Windows 7 64-bit > > -- Tim > > > -- > 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 > -- 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
