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

Unable to view excel file

XMLWordPrintable

      Steps to Replicate

      1. Open Excel
      2. Create a new Spreadsheet
      3. Add "A" in L1C2 cell, "B" in L1C3 cell
      4. Add "1" in L2C2 cell, "2" in L2C3 cell
      5. Select from L1C2 to L2C3 cell, go to Conditional Format, other conditional format, then # select the first rule format the cells according to their value.
      6. Save the Excel file
      7. Add as attachment this file to the Confluence page
      8. Edit the page, insert Another macro Office Excel
      9. Edit the Macro and chose the attached Excel file
      10. Save the page
      Observed Behavior

      User will be seeing the following error:

      Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.aspose.cells.CellsException: Not a numeric value in Cell B1
      Expected Behavior

      User should be able to view the excel file without any issue

        1. Email-Notification.png
          Email-Notification.png
          33 kB
        2. excelss.avi
          5.11 MB

            [CONFSERVER-37013] Unable to view excel file

            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 3 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 3
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            Nam Ho made changes -
            Component/s New: Macros - Other Macros [ 42868 ]
            Component/s Original: Editor - Page / Comment Editor [ 40706 ]
            Nam Ho made changes -
            Labels Original: Macros-Viewfile-macro-(Office-Connector) affects-server editor editor-macros excel office-connector New: Macros-Viewfile-macro-(Office-Connector) affects-server editor-macros excel office-connector
            SET Analytics Bot made changes -
            UIS Original: 4 New: 2

              Unassigned Unassigned
              sraj Suren Raj
              Affected customers:
              27 This affects my team
              Watchers:
              27 Start watching this issue

                Created:
                Updated: