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

        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: