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

A text field starting with a minus or plus sign causes problems in Excel

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • None
    • Import / Export [Deprecated]
    • None

      If you have a text field like 'description' starting with an minus '-' or plus '+' sign, formatting in Excel no longer works.

      This is because Jira believes that the fields refer to a number e.g. '-6' but instead sees '-x'. As a result it throws the error "Number Stored as Text" in the next column.

      This error will then turn off all formatting in the later Excel cells and you will start to see some strange data. For example, date fields will not be formatted.

              Unassigned Unassigned
              brian@atlassian.com BrianH
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: