IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
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

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            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

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

                          Created:
                          Updated:
                          Resolved:

                            Unassigned Unassigned
                            aworley Ann Worley (Inactive)
                            Affected customers:
                            1 Vote for this issue
                            Watchers:
                            2 Start watching this issue

                              Created:
                              Updated:
                              Resolved: