Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-39139

viewxls macro can't rendered spreadsheet with formula perfectly

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Medium
    • Resolution: Won't Fix
    • None
    • None
    • None
    • Confluence 4.3 & Office Connector plugin 2.1.7. Also, affecting Office Connector plugins bundled in Confluence 4.2.1 and 4.2.6.

    Description

      When embedding an Excel file containing formula in Confluence page using viewxls macro, the field formula is calculated differently and displayed a wrong Total value.

      The original value in Excel file looks like this:

      This is the result when the Excel file is embedded in Confluence page:

      Noticed that the Total value was wrong and not correctly calculated as compared to the original Excel file.

      Attachments

        1. wrong.JPG
          wrong.JPG
          56 kB
        2. correct.JPG
          correct.JPG
          41 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              hsuhailah Hanis Suhailah (Inactive)
              Votes:
              6 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: