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

Excel Spreadsheet is not displayed on a page which includes HTML macro

    • Icon: Bug Bug
    • Resolution: Answered
    • Icon: Low Low
    • None
    • 6.6.1, 6.7.0
    • Macros - Other Macros
    • None

      Summary

      If an HTML macro is added to a page which contains an embedded spreadsheet through either insert>files and images or via adding the Offfice Excel macro, that spreadsheet will not appear on the rendered page. The HTML macro will appear.

      Environment

      Confluence 6.6.1 and 6.7 were tested

      Steps to Reproduce

      1. Enable the HTML macro plugin modules
      2. Add an HTML macro with some code inside, like:
        <HTML>
         <HEAD>
         <TITLE>
         A Small Hello 
         </TITLE>
         </HEAD>
        <BODY>
         <H1>Hi</H1>
         <P>This is very minimal "hello world" HTML document.</P> 
        </BODY>
        </HTML>
        
      3. Attach an Excel spreadsheet
      4. Add the spreadsheet to the page using the Office Excel macro or Insert>files and images
      5. Save the page

      Expected Results

      The HTML and the Spreadsheet would be displayed on the page

      Actual Results

      Only the HTML is displayed.

      Notes

      If the HTML macro is removed, the spreadsheets show up right away. I attempted a workaround by putting the spreadsheet on another page and trying the except/excerpt include macros but again the spreadsheet would only render in the absence of the HTML macro.
      storage format of example:

      <p><ac:structured-macro ac:name="view-file" ac:schema-version="1" ac:macro-id="a6bd6c24-0cb4-4845-b61c-24b32a340614"><ac:parameter ac:name="name"><ri:attachment ri:filename="Workbook2.xlsx" /></ac:parameter><ac:parameter ac:name="height">250</ac:parameter></ac:structured-macro></p><ac:structured-macro ac:name="html" ac:schema-version="1" ac:macro-id="6c3ba0eb-bf2c-43d0-a17f-6a22ac7c4719"><ac:plain-text-body><![CDATA[<HTML>
         <HEAD>
            <TITLE>
               A Small Hello 
            </TITLE>
         </HEAD>
      <BODY>
         
      <H1>Hi</H1>
         
      <P>This is very minimal "hello world" HTML document.</P> 
      </BODY>
      </HTML>]]></ac:plain-text-body></ac:structured-macro>
      <p><br /></p>
      <p><br /></p>
      <p><br /></p>
      <p><ac:structured-macro ac:name="viewxls" ac:schema-version="1" ac:macro-id="1a3deea5-85bf-4606-b26f-be6e63ba1629"><ac:parameter ac:name="name"><ri:attachment ri:filename="Workbook2.xlsx" /></ac:parameter></ac:structured-macro></p>
      <p><br /></p>
      <p class="auto-cursor-target"><br /></p>
      

      Workaround

      No workaround has been discovered

            [CONFSERVER-54914] Excel Spreadsheet is not displayed on a page which includes HTML macro

            anoop.kulapparayilbaby1753140364, this bug report is described as being about the HTML Macro, as opposed to the HTML Include Macro. Have you already troubleshooted the HTML Include Macro issue with our support team? In order to understand what problem you might be running into, we would need to know the content of the HTML page that is being included. There are a number of related issues with HTML Macro and HTML Include Macro. These macros could be executing JavaScript which can cause various problems on the page. See for example CONFSERVER-38200, or CONFSERVER-38874, or CONFSERVER-42823. It would be best to contact our Support Team at https://support.atlassian.com/contact in order to understand the problem better, and the team might also be able to offer a workaround for your case.

            Alex Yakovlev (Inactive) added a comment - anoop.kulapparayilbaby1753140364 , this bug report is described as being about the HTML Macro, as opposed to the HTML Include Macro. Have you already troubleshooted the HTML Include Macro issue with our support team? In order to understand what problem you might be running into, we would need to know the content of the HTML page that is being included. There are a number of related issues with HTML Macro and HTML Include Macro. These macros could be executing JavaScript which can cause various problems on the page. See for example  CONFSERVER-38200 , or  CONFSERVER-38874 , or CONFSERVER-42823 . It would be best to contact our Support Team at https://support.atlassian.com/contact  in order to understand the problem better, and the team might also be able to offer a workaround for your case.

            @Alex Yakovlev , I dont know whether you understand what I mean by "HTML Include" macro, there are two different macros just "HTML" and "HTML Include" . Actually I want to include an html url on my page, for that I am using "HTML Include" macro, there is no code for HTML include, its just a url field only.

            Anoop K Baby added a comment - @Alex Yakovlev , I dont know whether you understand what I mean by "HTML Include" macro, there are two different macros just "HTML" and "HTML Include" . Actually I want to include an html url on my page, for that I am using "HTML Include" macro, there is no code for HTML include, its just a url field only.

            anoop.kulapparayilbaby1753140364 What is the content of HTML macro you are using? Please anonymise or use example url's if necessary.

            Alex Yakovlev (Inactive) added a comment - anoop.kulapparayilbaby1753140364 What is the content of HTML macro you are using? Please anonymise or use example url's if necessary.

            @Alex Yakolev , this is not the same issue.

            Steps to Reproduce :

            1. Try to add an excel sheet using Excel Macro
            2. Then try the "HTML Include" macro to include a html url. Please note, I am not trying to include the html code, I want to include the html url. It will show only the content from the html url which I included, will not show the content from the excel sheet.

            Anoop K Baby added a comment - @Alex Yakolev , this is not the same issue. Steps to Reproduce : 1. Try to add an excel sheet using Excel Macro 2. Then try the "HTML Include" macro to include a html url. Please note, I am not trying to include the html code, I want to include the html url. It will show only the content from the html url which I included, will not show the content from the excel sheet.

            This appears to be the same issue as CONFSERVER-54107. The same solution should apply.

            The HTML Macro content contains <html>, <head> and <body> tags. This is causing the page to render incorrectly. Those tags should not be included in the body of an HTML macro. Only the real HTML content should be included.

            Alex Yakovlev (Inactive) added a comment - This appears to be the same issue as CONFSERVER-54107 . The same solution should apply. The HTML Macro content contains <html>, <head> and <body> tags. This is causing the page to render incorrectly. Those tags should not be included in the body of an HTML macro. Only the real HTML content should be included.

              Unassigned Unassigned
              aworley Ann Worley (Inactive)
              Affected customers:
              1 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: