Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-27711

Table border lost when copy & paste from Excel to Confluence and set heading row

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

      Table border lost when copy & paste from Excel to Confluence. It is broken in preview mode while in edit mode, the table will looks fine.

      In Chrome:

      In Firefox:

      Workaround:

      1. Copy table from Excel and paste it
      2. Create a table in Confluence editor
      3. Copy the values from the Excel table earlier
      4. Paste it in the newly created table in Confluence editor

        1. table_chrome.png
          table_chrome.png
          4 kB
        2. table_firefox.png
          table_firefox.png
          4 kB
        3. Screen Shot 2014-07-16 at 11.49.17 am.png
          Screen Shot 2014-07-16 at 11.49.17 am.png
          23 kB

            [CONFSERVER-27711] Table border lost when copy & paste from Excel to Confluence and set heading row

            Version 5.0, this is definitely not fixed. Tables pasted in from google sheets show the borders in edit mode but disappear when published or previewed

            DoD Support added a comment - Version 5.0, this is definitely not fixed. Tables pasted in from google sheets show the borders in edit mode but disappear when published or previewed

            We are getting same issue in version 5.8.18.

            alpesh chotalia added a comment - We are getting same issue in version 5.8.18.

            We're using Confluence 5.8.10 and are experiencing the same behaviour of borders not showing after copy & paste from one Confluence page to another. When changing the zoom level (increase or decrease, doesn't matter) the border appears, but on default zoom (100%) it doesn't show.
            Could this Issue please be reviewed again, as apparently it hasn't been completely fixed?

            Firefox, Win 7
            (Problem does not occur when using IE)

            Paul Trauner added a comment - We're using Confluence 5.8.10 and are experiencing the same behaviour of borders not showing after copy & paste from one Confluence page to another. When changing the zoom level (increase or decrease, doesn't matter) the border appears, but on default zoom (100%) it doesn't show. Could this Issue please be reviewed again, as apparently it hasn't been completely fixed? Firefox, Win 7 (Problem does not occur when using IE)

            TonyH added a comment - - edited

            I experience this when creating a table using the editor - it appears to generally be the right border of the 3rd table column that doesn't appear, no matter how big table I create. This said, it also seems to be random at times.
            Confluence 5.8.13, Firefox 44.0.2, Win 7.

            TonyH added a comment - - edited I experience this when creating a table using the editor - it appears to generally be the right border of the 3rd table column that doesn't appear, no matter how big table I create. This said, it also seems to be random at times. Confluence 5.8.13, Firefox 44.0.2, Win 7.

            Happening here too. I want a fix too.

            Melanie Albrecht added a comment - Happening here too. I want a fix too.

            Pavel Chernikov added a comment - - edited

            @Atlassian - this is a major bug in Confluence. This issue has been opened 2.5 years ago. Inability to import from Excel is hindering our ability to utilize Confluence effectively. The workaround is not for an average user. Being a software developer myself, I can't imagine this being extremely difficult to identify and fix.

            Pavel Chernikov added a comment - - edited @Atlassian - this is a major bug in Confluence. This issue has been opened 2.5 years ago. Inability to import from Excel is hindering our ability to utilize Confluence effectively. The workaround is not for an average user. Being a software developer myself, I can't imagine this being extremely difficult to identify and fix.

            I am currently porting a lot of excel-based data to confluence pages (confluence version. 5.5.6) and I am also working around this by removing the <colgroup> via the source editor.

            Also in some cases there is cell-specific formatting which I cannot remove in excel (tried to remove the border, copied the excel table to another sheet, but no success) and which is also copied to the confluence table, but on a cell-level (e.g. <td style="border:0px;">) and there seems no way to remove it except via the source editor.

            Mario Steinhoff added a comment - I am currently porting a lot of excel-based data to confluence pages (confluence version. 5.5.6) and I am also working around this by removing the <colgroup> via the source editor. Also in some cases there is cell-specific formatting which I cannot remove in excel (tried to remove the border, copied the excel table to another sheet, but no success) and which is also copied to the confluence table, but on a cell-level (e.g. <td style="border:0px;">) and there seems no way to remove it except via the source editor.

            For the record: The issue was present before 5.0 already (tested in 4.3.7). It's quite an annoyance indeed if you are porting stuff from google docs to Confluence. Might be considered a blocking issue to use Confluence for a team who is evaluating Confluence. Hope this gets fixed at some point.

            Stefan Hett added a comment - For the record: The issue was present before 5.0 already (tested in 4.3.7). It's quite an annoyance indeed if you are porting stuff from google docs to Confluence. Might be considered a blocking issue to use Confluence for a team who is evaluating Confluence. Hope this gets fixed at some point.

            Darren K added a comment - - edited

            It is NOT just when you import ...

            I click on the Create button to create a new page.
            I then click on the insert table icon and select 4 columns and 2 rows... what is displayed is a new table with 3 columns and 2 rows!

            I key in information into the cells or cut and past text from another Confluence table and randomly 2 rows are merged into 1 row (ie. no border line between them), on some tables a column border is not displayed. If I create a new row below the merged row and cut and past the text from one of the merged rows above, the merged row now has 2 line with the second one being blank. Backspacing on the blank line does not remove it, clicking on it and then clicking on the delete row icon removes the line but then brings the text from the row below back into the merged row with 2 lines again.

            I created a course outline with about 22 small tables in it, all with 4 columns and varying from 2 rows (ie. header + 1 row) to 10 rows long. At least half of the tables are stuffed, either by displaying text that was keyed into separate rows in one row, or not displaying the border line on the bottom of the bottom row, or not displaying the left border line of the third column across, etc.

            Creating a new table and copying/pasting from the old table does not fix the problems, it just replicates the same problems.

            Sometimes what is displayed on the Edit screen is different to what is displayed on the Preview screen or Saved screen.

            I've screwed around for hours trying to fix this to no avail.

            The TABLE function is simply unusable.

            UPDATE ..... Please ignore this post, it seems to be a Mozilla Firefox problem as the page and tables are behaving normally in Internet Explorer.

            Darren K added a comment - - edited It is NOT just when you import ... I click on the Create button to create a new page. I then click on the insert table icon and select 4 columns and 2 rows... what is displayed is a new table with 3 columns and 2 rows! I key in information into the cells or cut and past text from another Confluence table and randomly 2 rows are merged into 1 row (ie. no border line between them), on some tables a column border is not displayed. If I create a new row below the merged row and cut and past the text from one of the merged rows above, the merged row now has 2 line with the second one being blank. Backspacing on the blank line does not remove it, clicking on it and then clicking on the delete row icon removes the line but then brings the text from the row below back into the merged row with 2 lines again. I created a course outline with about 22 small tables in it, all with 4 columns and varying from 2 rows (ie. header + 1 row) to 10 rows long. At least half of the tables are stuffed, either by displaying text that was keyed into separate rows in one row, or not displaying the border line on the bottom of the bottom row, or not displaying the left border line of the third column across, etc. Creating a new table and copying/pasting from the old table does not fix the problems, it just replicates the same problems. Sometimes what is displayed on the Edit screen is different to what is displayed on the Preview screen or Saved screen. I've screwed around for hours trying to fix this to no avail. The TABLE function is simply unusable. UPDATE ..... Please ignore this post, it seems to be a Mozilla Firefox problem as the page and tables are behaving normally in Internet Explorer.

            This happens for me and everyone I've ever worked with for the last three years, 100s of people. Pasting from anywhere other than confluence results in tables that have no gridlines. Please fix.

            Randy Schultz added a comment - This happens for me and everyone I've ever worked with for the last three years, 100s of people. Pasting from anywhere other than confluence results in tables that have no gridlines. Please fix.

              nhoang Hoang Nha (Inactive)
              mfahd Fahd
              Affected customers:
              44 This affects my team
              Watchers:
              42 Start watching this issue

                Created:
                Updated:
                Resolved: