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

XMLWordPrintable

    • 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)
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: