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

Confluence View File macro failed to load with legacy Edit in Office enabled.

      Issue Summary

      View File macro for Office files (tested with .xlsx) loading indefinitely:

      Steps to Reproduce

      1. Install or upgrade Confluence to version 7.9.x
      2. Follow the steps to Enable Edit in Office as a dark feature.

      Expected Results

      View File Macro load Office files correctly.

      Actual Results

      View File macro for Office files (tested with .xlsx) loading indefinitely.

      Workaround 1

      1. Remove enable.legacy.edit.in.office from Confluence dark feature:
        • <confluence-url>/admin/darkfeatures.action
      2. Use Companion Apps to edit files.

      Workaround 2

      • Attach the file directly into the page using the Confluence file previewer to generate the thumbnail.

      Workaround 3

      This requires downgrading the Office Connector plugin which may not be compatible with newer versions of Confluence and is not supported. However, this has been tested and it works with up to Confluence 7.9.3 so far:

      1. Stop Confluence
      2. Copy/Download the OfficeConnector-11.4.0.jar from an older version of Confluence (i.e. 7.8.0)
      3. Place it in the confluence_install/confluence/WEB-INF/atlassian-bundled-plugins/ folder.
      4. From the same folder, move the OfficeConnector-11.3.2.jar to another folder as backup.
      5. Start Confluence

      If using Docker a volume like such will suffice:

      /docker/confluence/OfficeConnector-11.2.1.jar:/opt/atlassian/confluence/confluence/WEB-INF/atlassian-bundled-plugins/OfficeConnector-11.3.2.jar


      Notes

      View File Macro loads PDF files correctly.

        1. OfficeConnector-11.4.0.jar
          14.57 MB
        2. vfloading.png
          vfloading.png
          33 kB

          Form Name

            [CONFSERVER-60622] Confluence View File macro failed to load with legacy Edit in Office enabled.

            A fix for this issue is available to Server and Data Center customers in Confluence 7.11.0
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Whitehead added a comment - A fix for this issue is available to Server and Data Center customers in Confluence 7.11.0 Upgrade now or check out the Release Notes to see what other issues are resolved.

            A fix for this issue is available to Server and Data Center customers in Confluence 7.10.2
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Whitehead added a comment - A fix for this issue is available to Server and Data Center customers in Confluence 7.10.2 Upgrade now or check out the Release Notes to see what other issues are resolved.

            Hello everyone, we are also affected by this problem on our Confluence 7.9.0 server instance. I have installed the 'OfficeConnector-11.4.0.jar' package. Office docx documents are now displayed again. But Office xlsx documents are still affected by the problem. We are planning a complete Conlfuence Update for January 20th and hope that the problem will then be fixed for all Office files. With best regards Henrik Kingerske

            Henrik Kingerske added a comment - Hello everyone, we are also affected by this problem on our Confluence 7.9.0 server instance. I have installed the 'OfficeConnector-11.4.0.jar' package. Office docx documents are now displayed again. But Office xlsx documents are still affected by the problem. We are planning a complete Conlfuence Update for January 20th and hope that the problem will then be fixed for all Office files. With best regards Henrik Kingerske

            Jeffrey Thornsen added a comment - - edited

            (2021-01-07) No problem, I already submitted a support request and referenced this issue.  If a separate bug report is needed for issues with Anonymous access, we can go that route (I originally tried to simply create a new bug myself but it redirected me to the Support Portal, I guess regular users can't simply submit issues into jira.atlassian.com)

            Edit (2021-01-13) See CONFSERVER-60857 for related bug about Anonymous access

            Jeffrey Thornsen added a comment - - edited (2021-01-07) No problem, I already submitted a support request and referenced this issue.  If a separate bug report is needed for issues with Anonymous access, we can go that route (I originally tried to simply create a new bug myself but it redirected me to the Support Portal, I guess regular users can't simply submit issues into jira.atlassian.com) Edit (2021-01-13) See CONFSERVER-60857 for related bug about Anonymous access

            Hi jeffrey.thornsen
            Thank you for highlighting the issue with anonymous users. This is definitely news to me, however it's unlikely that's it's directly related to the legacy edit in office feature which this current issue encapsulates. I would hypothesis that the issue you are describing is strictly permissions related and would be coming from deeper in our backend services.
            My best advice would be to reach out to support for help with triage, and opening a new Jira issue specifically for the use case you've described.

            Regards,
            James Whitehead

            James Whitehead added a comment - Hi jeffrey.thornsen Thank you for highlighting the issue with anonymous users. This is definitely news to me, however it's unlikely that's it's directly related to the legacy edit in office feature which this current issue encapsulates. I would hypothesis that the issue you are describing is strictly permissions related and would be coming from deeper in our backend services. My best advice would be to reach out to support for help with triage, and opening a new Jira issue specifically for the use case you've described. Regards, James Whitehead

            Hi blaisbr I would not recommend installing version 11.3.2 as that is the version of the plugin where this problem lies. I would recommend upgrading your instance to Confluence version 7.10.1 which was released yesterday, and then installing version 11.4.0 of this plugin which is the JAR attached to this issue. Due to backend changes that were made as part of this piece of work, I don't believe that this new version is compatible with Confluence 7.8.

            Regards,
            James Whitehead

            James Whitehead added a comment - Hi blaisbr I would not recommend installing version 11.3.2 as that is the version of the plugin where this problem lies. I would recommend upgrading your instance to Confluence version 7.10.1 which was released yesterday, and then installing version 11.4.0 of this plugin which is the JAR attached to this issue. Due to backend changes that were made as part of this piece of work, I don't believe that this new version is compatible with Confluence 7.8. Regards, James Whitehead

            Jeffrey Thornsen added a comment - - edited

            Hello,

            I would like to additionally report a similar symptom which might be related to the same root cause.  After upgrading to Confluence 7.10.0 (which comes with OfficeConnector-11.3.2.jar), all View File macros for Excel, Powerpoint, etc. fail to load for Anonymous users, even if the space/page is set up for Anonymous access.

            We get the exact same symptoms as reported here, even when the legacy Edit in Office Dark Feature is not enabled.  The macro appears on the page (without any errors) and just spins forever with the Loading image.

            As soon as users log in, the macro loads without issue.  The macro is non-functional for anonymous users.  We need this macro to work for Anonymous users in our instance.

             

            I tried downgrading the OfficeConnector JAR file to my old version (OfficeConnector-11.0.7.jar from Confluence 7.4.0 in my case) and the old functionality was restored for Anonymous users.

            I then tried the OfficeConnector-11.4.0.jar attached here, and with this version of the macro, the macro finishes loading almost instantly but just shows this message instead (for Anonymous users):

            "We can't preview this file. You'll have to download the file to view it."

            Jeffrey Thornsen added a comment - - edited Hello, I would like to additionally report a similar symptom which might be related to the same root cause.  After upgrading to Confluence 7.10.0 (which comes with OfficeConnector-11.3.2.jar), all View File macros for Excel, Powerpoint, etc. fail to load for Anonymous users , even if the space/page is set up for Anonymous access. We get the exact same symptoms as reported here, even when the legacy Edit in Office Dark Feature is not enabled.  The macro appears on the page (without any errors) and just spins forever with the Loading image. As soon as users log in, the macro loads without issue.  The macro is non-functional for anonymous users.  We need this macro to work for Anonymous users in our instance.   I tried downgrading the OfficeConnector JAR file to my old version (OfficeConnector-11.0.7.jar from Confluence 7.4.0 in my case) and the old functionality was restored for Anonymous users. I then tried the OfficeConnector-11.4.0.jar attached here, and with this version of the macro, the macro finishes loading almost instantly but just shows this message instead (for Anonymous users): "We can't preview this file. You'll have to download the file to view it."

            DIGIT CITnet added a comment - - edited

            Hi James,

            thanks for the new version.

            I have installed it on our ACC Confluence and indeed, the xls files are now rendered as before. However, after clicking on Edit in Office, the file is downloaded instead of opening in Excel to edit it.

            Also, is it possible to download OfficeConnector-11.2.1.jar from somewhere? We don't have anymore Confluence version 7.8.0

            Thanks,

            DIGIT CITnet added a comment - - edited Hi James, thanks for the new version. I have installed it on our ACC Confluence and indeed, the xls files are now rendered as before. However, after clicking on Edit in Office, the file is downloaded instead of opening in Excel to edit it. Also, is it possible to download OfficeConnector-11.2.1.jar from somewhere? We don't have anymore Confluence version 7.8.0 Thanks,

            James Whitehead added a comment - - edited

            Hi all,

            I'm the engineer that worked on the new asynchronous loading feature for this macro. Firstly, let me apologise for causing this issue. We simply missed the legacy edit in office mode in our testing, hence I was completely unaware that I had caused a regression.

            I've now fixed this and released a new version of the Office-Connector for you to use. I've attached the JAR for version 11.4.0 to this issue. You may install this new version through UPM for the time being. This new version will come bundled in Confluence 7.11.0.

            Regards,
            James Whitehead

            James Whitehead added a comment - - edited Hi all, I'm the engineer that worked on the new asynchronous loading feature for this macro. Firstly, let me apologise for causing this issue. We simply missed the legacy edit in office mode in our testing, hence I was completely unaware that I had caused a regression. I've now fixed this and released a new version of the Office-Connector for you to use. I've attached the JAR for version 11.4.0 to this issue. You may install this new version through UPM for the time being. This new version will come bundled in Confluence 7.11.0. Regards, James Whitehead

            The workaround is not really working because when you disable legacy edit (you can do this in the gui by the way), users cannot edit the office files anymore but get a message that they have to install the companion app. 

            Chantal Rosmuller added a comment - The workaround is not really working because when you disable legacy edit (you can do this in the gui by the way), users cannot edit the office files anymore but get a message that they have to install the companion app. 

              jwhitehead@atlassian.com James Whitehead
              dazmi Dayana
              Affected customers:
              12 This affects my team
              Watchers:
              32 Start watching this issue

                Created:
                Updated:
                Resolved: