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

Error in calculating cell while using excel macro

    XMLWordPrintable

Details

    Description

      Client used the following query in a cell of his excel file:

      =IF(DAY(JulSun1)=1;"";IF(AND(YEAR(JulSun1+2)=CalendarYear;MONTH(JulSun1+2)=7);JulSun1+2;""))

      When inserting as an attachment using the Excel Macro, the following error is generated:

      Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.aspose.cells.CellsException: null Error in calculating cell B5 in Worksheet Jul

      Another customer at this comment has a similar error.

      Testing in Office Connector 3.0.3 on Confluence 4.1.3 and 4.1.4

      Attachments

        Activity

          People

            Unassigned Unassigned
            smackie@atlassian.com Shannon S
            Votes:
            9 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: