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. Content_Formatting.xls
          33 kB
          Kok Yan Yong
        2. Content_Formatting.xlsx
          30 kB
          Kok Yan Yong
        3. excel_file.png
          3 kB
          TeckEn
        4. excel_macro.png
          2 kB
          TeckEn
        5. excelmacro.png
          271 kB
          Kok Yan Yong
        6. notworking.PNG
          19 kB
          TeckEn
        7. preview.png
          184 kB
          Kok Yan Yong
        8. Test1.png
          263 kB
          Kok Yan Yong
        9. Test2.png
          96 kB
          Kok Yan Yong
        10. working.PNG
          21 kB
          TeckEn

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

                Created:
                Updated: