[Libreoffice-bugs] [Bug 127651] New: LibreOffice calc fails to properly perform a simple sort

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127651

            Bug ID: 127651
           Summary: LibreOffice calc fails to properly perform a simple
                    sort
           Product: LibreOffice
           Version: 6.0.1.1 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tedwaugh at gmail.com

Description:
I have noticed this problem several times now. I have a small spreadsheet
database for authors books and dates. When I perform a sort using column B as
the primary sort and column C as the secondary sort the sort output does not
put all the column C data in its correct order.

Steps to Reproduce:
1. On the data provided select the block to be sorted
2. Ensure that the parameters for sorting are correct (able to select column B,
the column C
3. Enter OK

Actual Results:
After Sorting ? (I also tried ‘natural sorting’-- no better)                    
Supposedly sorted on column B then column C both low to high.                   
Cornwell, Patricia      Andy Brazil     2001    Isle of the Dogs
Cornwell, Patricia      Andy Brazil     1998    Southern Cross
Cornwell, Patricia      Kay Scarpetta   2005    Predator
Cornwell, Patricia      Kay Scarpetta   1990    Post Mortem
Cornwell, Patricia      Kay Scarpetta   1992    All that Remains
Cornwell, Patricia      Kay Scarpetta   1995    From Potter Field
Cornwell, Patricia      Kay Scarpetta   1996    Cause of Death
Cornwell, Patricia      Kay Scarpetta   1997    Unnatural Exposure
Cornwell, Patricia      Kay Scarpetta   1998    Point of Origin
Cornwell, Patricia      Kay Scarpetta   1999    Black Notice
Cornwell, Patricia      Kay Scarpetta   2007    Book of the Dead
Cornwell, Patricia      Kay Scarpetta   2010    Port Mortuary
Cornwell, Patricia      Win Garano      2006    At Risk
Cornwell, Patricia      Win Garano      2008    The Front


Expected Results:
Cornwell, Patricia      Andy Brazil     1998    Southern Cross
Cornwell, Patricia      Andy Brazil     2001    Isle of the Dogs
Cornwell, Patricia      Kay Scarpetta   1990    Post Mortem
Cornwell, Patricia      Kay Scarpetta   1992    All that Remains
Cornwell, Patricia      Kay Scarpetta   1995    From Potter Field
Cornwell, Patricia      Kay Scarpetta   1996    Cause of Death
Cornwell, Patricia      Kay Scarpetta   1997    Unnatural Exposure
Cornwell, Patricia      Kay Scarpetta   1998    Point of Origin
Cornwell, Patricia      Kay Scarpetta   1999    Black Notice
Cornwell, Patricia      Kay Scarpetta   2005    Predator
Cornwell, Patricia      Kay Scarpetta   2007    Book of the Dead
Cornwell, Patricia      Kay Scarpetta   2010    Port Mortuary
Cornwell, Patricia      Win Garano      2006    At Risk
Cornwell, Patricia      Win Garano      2008    The Front



Reproducible: Always


User Profile Reset: No



Additional Info:
The second line should have been first 2001 > 1998
The third line (2005) should have been between 1999 and 2007

Version: 6.0.1.1
Build ID: 1:6.0.1-1~bpo9+1
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190920/623bfd78/attachment.html>