You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/05/19 23:14:34 UTC

[Bug 122348] New: Calc sort order incorrect for dotted decimal keys

https://issues.apache.org/ooo/show_bug.cgi?id=122348

            Bug ID: 122348
        Issue Type: DEFECT
           Summary: Calc sort order incorrect for dotted decimal keys
    Classification: Application
           Product: Calc
           Version: AOO 3.4.1
          Hardware: All
                OS: Windows Vista
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: dbrown@nasnch.org
                CC: issues@openoffice.apache.org

Created attachment 80711
  --> https://issues.apache.org/ooo/attachment.cgi?id=80711&action=edit
ODS sheet displaying improper sort order

Sorting rows does not produce expected result when sort key is in dotted
decimal format (e.g. 1.1.2, 1.3.4, etc.)

To reproduce error, sort following rows in Calc on Column A:

Column A   Column B
1.1.2    This should be line 1                                                  
1.2.20    This should be line 2                                                 
2    This should be line 3                                                      
2.7    This should be line 4                                                    
3.1.1    This should be line 5                                                  
3.1.4.1    This should be line 6                                                

Expected result is same as above. Actual sort result is shown below.

Column A    Column B
2.7    This should be line 4
1.1.2    This should be line 1
1.2.20    This should be line 2
2    This should be line 3
3.1.1    This should be line 5
3.1.4.1    This should be line 6

Result is the same whether sort key is formatted as 'text' or 'number'

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 122348] Calc sort order incorrect for dotted decimal keys

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122348

Edwin Sharp <el...@mail-page.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |elish@mail-page.com
             Latest|---                         |AOO 4.0.0
    Confirmation on|                            |
         Resolution|---                         |IRREPRODUCIBLE

--- Comment #1 from Edwin Sharp <el...@mail-page.com> ---
Sort ascending and descending performs OK.

Rev. 1479897 Win 7

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.