Error in calculating cell while using excel macro

XMLWordPrintable

      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

            Assignee:
            Unassigned
            Reporter:
            SMS (Inactive)
            Votes:
            9 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: