Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-29446

Rules of Conditional Formatting Does Not Render Properly in Office Excel Macro

XMLWordPrintable

    • 6
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      NOTE: This suggestion is for Confluence Cloud. Using Confluence Server? See the corresponding suggestion.

      There are some rules of conditional formatting not respect by the excel connector. More information at the following screenshots:

      Steps to Reproduce

      1. Create a Confluence page. (Let's name it "Excel Test" page)
      2. Upload both Content_Formatting.xls file and Content_Formatting.xlsx file into the Excel Test page.
      3. Insert both of the files using the Files and Images macro via "+" sign.
      4. Insert both of the files using the Office Excel macro via "+" sign > Other macros.
      5. Observe the previews.

      Expected Behaviour

      All of the four macros should be rendered properly.

      Actual Behaviour

      1. Preview for Files and Images macro is inconsistent.
      2. Preview for Office Excel macro is broken.

      Excel File in Microsoft Excel:

      Excel Macro rendered in Confluence page:

      Rules that not working in Confluence:

      Rules that working in Confluence:

        1. working.PNG
          working.PNG
          21 kB
        2. Test2.png
          Test2.png
          96 kB
        3. Test1.png
          Test1.png
          263 kB
        4. preview.png
          preview.png
          184 kB
        5. notworking.PNG
          notworking.PNG
          19 kB
        6. excelmacro.png
          excelmacro.png
          271 kB
        7. excel_macro.png
          excel_macro.png
          2 kB
        8. excel_file.png
          excel_file.png
          3 kB
        9. Content_Formatting.xlsx
          30 kB
        10. Content_Formatting.xls
          33 kB

              Unassigned Unassigned
              yen@atlassian.com TeckEn (Inactive)
              Votes:
              15 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated: