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

In Confluence, Adding a function in excel sheet causes it, stops it from being rendered in Office Excel Macro

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 9.2.6
    • Macros - Other Macros
    • None

      Problem

      In Confluence, if a excel sheet containing a function such as the below is used:

      =TRIM(CONCATENATE(TEXTAFTER(Sheet1!$A2,"test_")))
      

      And if this excel is viewed via Confluence page using Office Excel macro, entire sheet is not rendered. Instead we see "We can't preview this file.." error

      Environment

      Confluence 9.2.6

      Steps to Reproduce

      1. Create a page in Confluence 9.2.x
      2. Upload the attached: .Test_Excel_Sheet.xlsx
      3. Open an Offie Excel macro and add the above uploaded excel file into the macro
      4. Save the page.

      Expected Results

      The excel file should be rendered on the page including the functions.

      Actual Results

      We experience the below error:

      Workaround

      None at this point. Removing the column containing the function and  uploading the excel again causes the file to be rendered.

      Notes

              Unassigned Unassigned
              sganeshan@atlassian.com Sathya Ganeshan
              Votes:
              4 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated: