Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-74758

Not able to sort table column with mixed alpha and numeric values

XMLWordPrintable

      Issue Summary

      Sorting a table column with mixed alpha and numeric values doesn't work properly, the sort doesn't return the expected results.

      Steps to Reproduce

      1. Create a Confluence page
      2. Insert a Table
      3. Populate a column with mixed alpha and numeric values
        Example entered like this:
        Version
        2021R5
        2021R6
        2022R2
        2022R3
        2021R5
        2022R1
        2022R3
        2022R2
        2022R3
      4. Publish the page
      5. Sort the column (A-Z, Z-A)
        Sorted Z to A: 
        Version
         
        2022R2
        2022R3
        2022R1
        2022R3
        2022R2
        2022R3
        2021R5
        2021R6
        2021R5

        Sorted A to Z:

        Version
         
        2021R5
        2021R6
        2021R5
        2022R2
        2022R3
        2022R1
        2022R3
        2022R2
        2022R3

      Expected Results

      The column is sorted alphabetically and numerically considering all of the characters in the string.

      Actual Results

      The column appears to be sorted in a rather random way.

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available.

              Unassigned Unassigned
              1931a746bb69 Tina Bolton
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: