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

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

      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.

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

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

              Created:
              Updated:
              Resolved: