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

Issue fields of type text such as description exported to excel are treated as numeric if their first character starts with a dash "-".

    XMLWordPrintable

Details

    • 4
    • Severity 2 - Major
    • Hide
      Atlassian Update – 04 December 2017

      Hi everyone,

      We have recently reviewed this issue and the overall interest in the problem. As the issue hasn't collect votes, watchers, comments, or support cases from many customers during its lifetime, it's very low on our priority list, and will not be fixed in the foreseeable future. That's why we've decided to resolve it as Time Out.

      Although we're aware the issue is still important to those of you who were involved in the conversations around it, we want to be clear in managing your expectations. The Jira team is focusing on issues that have broad impact and high value, reflected by the number of comments, votes, support cases, and customers interested. Please consult the Atlassian Bugfix Policy for more details.

      We understand how disappointing this decision may be, but we hope you'll appreciate our transparent approach and communication.

      Atlassian will continue to watch this issue for further updates, so please feel free to share your thoughts in the comments.

      Thank you,
      Ignat Alexeyenko
      Jira Bugmaster

      Show
      Atlassian Update – 04 December 2017 Hi everyone, We have recently reviewed this issue and the overall interest in the problem. As the issue hasn't collect votes, watchers, comments, or support cases from many customers during its lifetime, it's very low on our priority list, and will not be fixed in the foreseeable future. That's why we've decided to resolve it as Time Out . Although we're aware the issue is still important to those of you who were involved in the conversations around it, we want to be clear in managing your expectations. The Jira team is focusing on issues that have broad impact and high value, reflected by the number of comments, votes, support cases, and customers interested. Please consult the Atlassian Bugfix Policy for more details. We understand how disappointing this decision may be, but we hope you'll appreciate our transparent approach and communication. Atlassian will continue to watch this issue for further updates, so please feel free to share your thoughts in the comments. Thank you, Ignat Alexeyenko Jira Bugmaster

    Description

      Steps to reproduce
      When you have some issue fields that contains text starting with a dash "-" and then export the issue to excel, They will be treated as numeric types. Whenever you try to make amends on them and hit the "Enter" key, it behaves in an awkward manner. File test.xls illustrates this phenomena on "description field".

      Workaround:
      A workaround to this is to add a non breakable space if the description contains a dash character.
      edit the file WEB-INF\classes\templates\jira\issue\field\description-columnview.vm to be as thus:

      #if ($description)
  #if (${displayParams.excel_view})
    #if ($description.contains("-"))
        
    #end
    $textutils.br($textutils.htmlEncode($description, false))
  #else
    $rendererManager.getRenderedContent($fieldLayoutItem, $issue)
  #end
#end

      Attachments

        1. Fixed.xls
          23 kB
        2. Test.xls
          23 kB

        Activity

          People

            Unassigned Unassigned
            smaiyaki Sultan Maiyaki (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: