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

Office Excel does not display the correct results of functions in Excel files

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • 5.4
    • None

    Description

      Steps to Reproduce:

      1. Create a page In Confluence
      2. attach the sample excel file (provided in this ticket) to the page
      3. Use Office Excel to display the excel file on your page.
      4. Save the page

      Expected Results:

      Actual Results:


      Note that Total is zero.

      Findings:

      the formula:

       =COUNTIF(A1:A5:B1:B5,"test")
      

      Does not return the correct result here.

      • This works fine in Confluence 3.5.11.

      Attachments

        1. excel-conf.png
          excel-conf.png
          2 kB
        2. excel.png
          excel.png
          2 kB
        3. testbook.xlsx
          8 kB

        Issue Links

          Activity

            People

              shaffenden Steve Haffenden (Inactive)
              htoussi HosseinA
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: