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

Details

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

    Description

      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.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-12759 Excel export should escape the certain arithmetic operators

          • Low - Low priority issues
          • Gathering Impact
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-9765 Word export incorrectly renders resolved links

          • Low - Low priority issues
          • Closed

          Suggestion - JRASERVER-10404 Make 'views' of content (single issue and search request) pluggable, and rewrite default implementations in velocity

          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: