Re: [libreoffice-users] LibreOffice Sort Bug ?

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: users+unsubscribe@global.libreoffice.org
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