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.

            [CONFSERVER-40460] Tables are sorted incorrectly

            We also seem to be encountering this issue immediately after upgrading to 7.13.2. 
            It seems to malfunction on some tables but not all.

            Brendan Byers added a comment - We also seem to be encountering this issue immediately after upgrading to 7.13.2.  It seems to malfunction on some tables but not all.

            Can you please reopened recently i was upgraded from 7.4.7 to 7.13.2 but sorting option is not working i tried to enable but the sorting plugin does not showing option and its saying its not modifiable.

            Santhosh Kadathala added a comment - Can you please reopened recently i was upgraded from 7.4.7 to 7.13.2 but sorting option is not working i tried to enable but the sorting plugin does not showing option and its saying its not modifiable.

            Can this be re-opened? This is still a problem and I am on cloud. Thanks!

            Rianna Kosmalski added a comment - Can this be re-opened? This is still a problem and I am on cloud. Thanks!

            Atlassian Update - September 2019

            Thank you for your interest in this ticket. The Confluence Server and Data Center team released a major upgrade to the editor in 6.14. Due to the age of this ticket and/or lack of updates, we suspect that this issue is no longer relevant or was resolved as a result of the upgrade and are now closing this ticket.

            If this issue is still a problem in your Confluence instance in version 6.15 or later, please tag me in your comment and we can reopen this ticket for review.

            You can read more about the editor upgrade in the 6.14 Release Notes.

            Thanks

            Makisa Appleton | Senior Product Manager, Confluence Server and Data Center

            Makisa Appleton added a comment - Atlassian Update - September 2019 Thank you for your interest in this ticket. The Confluence Server and Data Center team released a major upgrade to the editor in 6.14. Due to the age of this ticket and/or lack of updates, we suspect that this issue is no longer relevant or was resolved as a result of the upgrade and are now closing this ticket. If this issue is still a problem in your Confluence instance in version 6.15 or later, please tag me in your comment and we can reopen this ticket for review. You can read more about the editor upgrade in the 6.14 Release Notes . Thanks Makisa Appleton | Senior Product Manager, Confluence Server and Data Center

            This is a view page bug not related to the editor, it appears to be fixed on

            • server, Confluence 6.6.0-m10
            • Pug conf cloud

            Mike Chau (Inactive) added a comment - This is a view page bug not related to the editor, it appears to be fixed on server, Confluence 6.6.0-m10 Pug conf cloud

            Heiko Schroeder added a comment - - edited

            This bug is a major issue for data handling within Confluence tables. Please provide a fix. In addition to not sorting properly combined letter/number columns, these columns can also not be rearranged by clicking the small up/down arrows in the column header (see example image attached).

            One more interesting observation: After including another cell with only numbers or only letters, the column sorts correctly again.

            Heiko Schroeder added a comment - - edited This bug is a major issue for data handling within Confluence tables. Please provide a fix. In addition to not sorting properly combined letter/number columns, these columns can also not be rearranged by clicking the small up/down arrows in the column header (see example image attached). One more interesting observation: After including another cell with only numbers or only letters, the column sorts correctly again.

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

                Created:
                Updated:
                Resolved: