NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      Summary

      When a table contains a combination of numbers and letters, sorting does not properly alphabetize the columns.

      Steps to Reproduce

      1. Create a table with the following data:
        Column 1 Column 2
        a abc
        b aab
        3 acb
        abc bbc
        jha bac
        2bcd bbb
        1zja bca
        aaks bcb
      2. Save table
      3. Click Column 1 to sort

      Expected Results

      The table will be sorted in correct alphabetical order.

      Actual Results

      Table is sorted as follows (Column 1):

      1
      1zja
      2
      2bcd
      3
      abc
      jha
      aaks

      Notice jha is between abc and aaks. I would expect it would sort aaks, abc, jha.

      Notes

      See screenshot attached.

      Workaround

      No workaround available.

        1. table_sort_example.png
          5 kB
          Heiko Schroeder
        2. Table_sort_issue.png
          15 kB
          J van Leeuwen

            [CONFSERVER-40460] Tables are sorted incorrectly

            Makisa Appleton made changes -
            Resolution New: Obsolete [ 11 ]
            Status Original: Gathering Impact [ 12072 ] New: Closed [ 6 ]
            Makisa Appleton made changes -
            Fix Version/s New: 6.14.0 [ 83892 ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 3
            SET Analytics Bot made changes -
            UIS Original: 3 New: 2
            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2876691 ] New: CONFSERVER Bug Workflow v4 [ 3004315 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2804297 ] New: JAC Bug Workflow v3 [ 2876691 ]
            SET Analytics Bot made changes -
            UIS Original: 0 New: 3
            SET Analytics Bot made changes -
            UIS Original: 3 New: 0
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2735840 ] New: JAC Bug Workflow v2 [ 2804297 ]
            SET Analytics Bot made changes -
            UIS Original: 0 New: 3

              Unassigned Unassigned
              jbennett@atlassian.com J van Leeuwen
              Affected customers:
              7 This affects my team
              Watchers:
              15 Start watching this issue

                Created:
                Updated:
                Resolved: