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

          Form Name

            [CONFSERVER-37013] Unable to view excel file

            siddhesh added a comment -

            Hello,

             

             Same issue in confluence 6.15.9

            Any update?

            Regards,

            Siddheshwar

            siddhesh added a comment - Hello,    Same issue in confluence 6.15.9 Any update? Regards, Siddheshwar

            Linda Li added a comment -

            Hello, we have the same error in Version 6.15.1:

            Error rendering macro 'viewxls'

            com.atlassian.plugins.conversion.convert.ConversionException: com.aspose.cells.CellsException: Error for ZipFile

            Linda Li added a comment - Hello, we have the same error in Version 6.15.1: Error rendering macro 'viewxls' com.atlassian.plugins.conversion.convert.ConversionException: com.aspose.cells.CellsException: Error for ZipFile

            Allison Jurado added a comment - - edited

            EDIT: Any update on this issue? Thank you

             

            I received this error when trying to link Excel to my Confluence pag; Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.aspose.cells.CellsException: Not a numeric value in Cell B1

            If this bug is successfully resolved, I can test functionalities with the table and hopefully replicate it for other teams in my department.

            Allison Jurado added a comment - - edited EDIT: Any update on this issue? Thank you   I received this error when trying to link Excel to my Confluence pag; Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.aspose.cells.CellsException: Not a numeric value in Cell B1 If this bug is successfully resolved, I can test functionalities with the table and hopefully replicate it for other teams in my department.

            6.3.3
            Error rendering macro 'viewxls' :
            com.atlassian.plugins.conversion.convert.ConversionException:
            com.aspose.cells.CellsException: This file's format is not supported or
            you don't specify a correct format.

            Pavel Potcheptsov added a comment - 6.3.3 Error rendering macro 'viewxls' : com.atlassian.plugins.conversion.convert.ConversionException: com.aspose.cells.CellsException: This file's format is not supported or you don't specify a correct format.

            Ralf Scheller added a comment - - edited

            Hello, we have the same error in Version 6.5.1:

            WARN [ajp-nio-8009-exec-1] [xhtml.view.macro.ViewMacroMarshaller] handleMacroExecutionException Exception executing macro: viewxls, with message: com.atlassian.plugins.conversion.convert.ConversionException: java.lang.NullPointerException

             

            or another Error in logfile:

            ERROR [ajp-nio-8009-exec-1] [confluence.util.velocity.VelocityUtils] getRenderedTemplate Error occurred rendering template: templates/extra/attachments/attachmentsmacro.vm
             -- url: /display/... | page: 2555911 | traceId: 129fb57ed3eeefd5 | userName: ... | referer: https://.../index.action | action: viewpage
            org.apache.velocity.exception.ResourceNotFoundException: Unable to find resource 'template/lockpoint/lockunlockall.vm'

            Ralf Scheller added a comment - - edited Hello, we have the same error in Version 6.5.1: WARN [ajp-nio-8009-exec-1] [xhtml.view.macro.ViewMacroMarshaller] handleMacroExecutionException Exception executing macro: viewxls, with message: com.atlassian.plugins.conversion.convert.ConversionException: java.lang.NullPointerException   or another Error in logfile: ERROR [ajp-nio-8009-exec-1] [confluence.util.velocity.VelocityUtils] getRenderedTemplate Error occurred rendering template: templates/extra/attachments/attachmentsmacro.vm  -- url: /display/... | page: 2555911 | traceId: 129fb57ed3eeefd5 | userName: ... | referer: https://.../index.action | action: viewpage org.apache.velocity.exception.ResourceNotFoundException: Unable to find resource 'template/lockpoint/lockunlockall.vm'

            Hello,

            Confluence 6.0.7 also has similar issue. The error is the following:

            Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: java.lang.ClassCastException: com.aspose.cells.ny cannot be cast to java.lang.Double

            Best regards,

            Vladimir

            Vladimir Guzh added a comment - Hello, Confluence 6.0.7 also has similar issue. The error is the following: Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: java.lang.ClassCastException: com.aspose.cells.ny cannot be cast to java.lang.Double Best regards, Vladimir

            Rafael Valverde added a comment - - edited

            Hi, I have the same issue and my JIRA server version is 7.3, I will wait for the answer,  

            Regards.

            Rafael Valverde added a comment - - edited Hi, I have the same issue and my JIRA server version is 7.3, I will wait for the answer,   Regards.

            Kent added a comment -

            I too am having the same issue while using Confluence version 6.0.3.

            I have the 'Attachment' macro set up on my page showing my attached excel spreadsheets.

            When I click the 'View' button in the 'Attachment' macro of one of my excel spreadsheets, I get the error.

            What I am doing to work around this is by clicking the 'Edit in Office' button and it opens up in my Microsoft Excel for me to view.

            This is assuming the computer already has Microsoft Excel installed and the compatible browser.

            Please fix this issue as it can become a disaster during presentational meetings!

             

            Kent added a comment - I too am having the same issue while using Confluence version 6.0.3. I have the 'Attachment' macro set up on my page showing my attached excel spreadsheets. When I click the 'View' button in the 'Attachment' macro of one of my excel spreadsheets, I get the error. What I am doing to work around this is by clicking the 'Edit in Office' button and it opens up in my Microsoft Excel for me to view. This is assuming the computer already has Microsoft Excel installed and the compatible browser. Please fix this issue as it can become a disaster during presentational meetings!  

            eeas gmbh added a comment -

            any news on that topic?

             

            eeas gmbh added a comment - any news on that topic?  

            I too face the same issue.

             

             

            Anand Varkey Philips added a comment - I too face the same issue.    

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

                Created:
                Updated: