Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-13457

Export to Excel formats Key field as Date

    XMLWordPrintable

Details

    Description

      When we export an issue list to Excel, the Key column gets formatted as type General, unless Excel thinks it should be something else. This is causing problems with a project here whose key is "DEC". Now that we have issue numbers in the 1900's, these are showing up in Excel as dates in December 19xx. For example, issue# DEC-1935 shows up as the date "Dec-35". We can reformat them, but we shouldn't have to do this every time. It would be better if JIRA forced the Key column to be formatted as text, so Excel doesn't try to get too smart and reformat it as something else.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              e242ca755d20 Marilyn Daum
              Votes:
              8 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: