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: [email protected]
          Reporter: [email protected]
                CC: [email protected]

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.

Reply via email to