Uploaded image for project: 'Xporter for Jira'
  1. Xporter for Jira
  2. XPORTER-4118

Excel formula is not working, when a referenced cell is empty in the template

    XporterXMLWordPrintable

Details

    • UNCOVERED

    Description

      Excel formula is not working, when a referenced cell is empty in the template.
      It is necessary to implement a condition to verify first if the cell is empty or not.

      Example:

      • =Template!A2&" - "&Template!B2 - Doesn't work
      • =SE(Template!B2="";"";Template!A2&" - "&Template!B2) - Works

      Steps to reproduce:

      The generated file won't be able to be opened by Excel.

      The file will be successfully generated with all the necessary data.

      Note: In version 6.9.12 it was working fine.

      Attachments

        Activity

          People

            rmbr Rui Rodrigues
            pmax Paulo Aleixo
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: