• Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • 5.5.3, 5.7, 5.8-m13
    • None

      Steps to reproduce:

      1. Create a table in 3x3 in Excel or Open Office Calc
      2. Copy this table.
      3. Paste into a Confluence page.
      4. You'll see that there isn't an option to sort the tables there.

      Workaround:

      • create a new table from scratch
      • copy all cells of the faulty table (which was most likely just pasted from MS Office to the Confluence page) by clicking first in the first (top left) cell, then shift-clicking in the last (bottom right) cell and copying the whole (CTRL-C or contextual menu)
      • paste the clipboard into the first cell of the newly created table
      • delete the "old" table
      • save the page

      Source Editor:

      1. The first table is pasted from Excel, the second one was created via workaround:
        <table>
          <colgroup>
            <col/>
            <col/>
          </colgroup>
          <tbody>
            <tr>
              <td>Number</td>
              <td>Customer</td>
            </tr>
            <tr>
              <td>1</td>
              <td>
                <a href="http://Atlassian.com">Atlassian.com</a>
              </td>
            </tr>
            <tr>
              <td>2</td>
              <td>
                <a href="http://Bodybuilding.com">Bodybuilding.com</a>
              </td>
            </tr>
            <tr>
              <td>3</td>
              <td>
                <a href="http://Youtube.com">Youtube.com</a>
              </td>
            </tr>
          </tbody>
        </table>
        
        
        
        
        <table>
          <tbody>
            <tr>
              <th>Number</th>
              <th>Customer</th>
            </tr>
            <tr>
              <td>1</td>
              <td>
                <a href="http://Atlassian.com">Atlassian.com</a>
              </td>
            </tr>
            <tr>
              <td>2</td>
              <td>
                <a href="http://Bodybuilding.com">Bodybuilding.com</a>
              </td>
            </tr>
            <tr>
              <td>3</td>
              <td>
                <a href="http://Youtube.com">Youtube.com</a>
              </td>
            </tr>
          </tbody>
        </table>
        
        

            [CONFSERVER-36458] Table has no Sort function when pasted from MS Office

            Hi wzanchet

            Thanks for taking the time to raise this issue. From the description that you've provided this looks to be a duplicate of CONF-29121. As I believe this is a duplicate I'm going to close this issue out.

            Regards
            Steve Haffenden
            Confluence Bugmaster

            Steve Haffenden (Inactive) added a comment - Hi wzanchet Thanks for taking the time to raise this issue. From the description that you've provided this looks to be a duplicate of CONF-29121 . As I believe this is a duplicate I'm going to close this issue out. Regards Steve Haffenden Confluence Bugmaster

            I frequently have to coach our hard-core Microsoft fans so that they would migrate their Excel spreadsheets into Confluence tables when they don't need complex calculations. Copy-pasting is a simple enough way to do it, however if they need to tiptoe by using a workaround whenever they want to transfer their Excel data into a "clean" Confluence table, this is certainly going to cool down their enthusiasm towards Confluence...

            Normand Brousseau added a comment - I frequently have to coach our hard-core Microsoft fans so that they would migrate their Excel spreadsheets into Confluence tables when they don't need complex calculations. Copy-pasting is a simple enough way to do it, however if they need to tiptoe by using a workaround whenever they want to transfer their Excel data into a "clean" Confluence table, this is certainly going to cool down their enthusiasm towards Confluence...

              shaffenden Steve Haffenden (Inactive)
              wzanchet William Zanchet (Inactive)
              Affected customers:
              1 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: