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

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

    XMLWordPrintable

Details

    • 1
    • 6
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? 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:

      Attachments

        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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: