Re: [libreoffice-users] LibreOffice Sort Bug ?

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 <tim@timdeaton.org> 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: 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

-- 
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