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+unsubscr...@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