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

Excel Macro fails to display chart when worksheet name specified

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • None
    • 8.5.10, 8.5.11
    • Macros - Other Macros
    • None

      Issue Summary

      When adding an Excel file with a chart to the Office Excel macro and specifying the Worksheet Name parameter, the chart doesn't display, instead, a broken image icon appears.

      Note: Similar behaviour is observed for the images on the worksheet.

      This is reproducible on Data Center: yes
      version - v8.5.11

      Pre-condition:

      Sample Excel file - Book.xlsx

      Steps to Reproduce:

      • Create a page, attach an Excel file with multiple Charts in it , and then save the page.
      • Edit the page and insert Office Excel Macro.
      • While inserting the file, enter the Worksheet Name parameter based on the sheet name of the Excel file.
      • Insert the second sheet, this time don't enter the worksheet name.
      • Save and Update.

      Expected Results

      The Excel content and the Charts are displayed.

      Actual Results

      The Excel content are displayed as expected. However the charts are not displayed for the macro that have Worksheet name entered.
      The Charts are displayed for macros that have no worksheet name entered.

      Screenshot from the Local Testing below.

      Workaround

      Currently, there is no known workaround for this behaviour. A workaround will be added here when available.


      NOTE:
      I did come across CONFSERVER-96032. However, I think the Actual result is slightly different. The Preview of the file was not displayed in CONFSERVER-96032, while in this scenario, the content is displayed and chart is not.

        1. Book.xlsx
          19 kB
          Sandeep Sahadevan
        2. Screenshot 2024-07-04 at 15.28.54.png
          101 kB
          Sandeep Sahadevan

              Unassigned Unassigned
              e2a594875e14 Sandeep Sahadevan
              Votes:
              3 Vote for this issue
              Watchers:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: