• Icon: Suggestion Suggestion
    • Resolution: Won't Fix
    • None
    • None
    • Any JIRA 6+
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      When in Issue Navigator, adding field Last Comment, having color in last comment and selecting Export -> Excel (Current fields), this will export text with markup that excel can't interpret.

       
      Text in JIRA comment: "test comment"
       
      Actual text in exported excel:

      test {color:#FF0000}comment{color}

      Expected text in Excel:

      • Either plain text: test comment
      • Or colored one: test comment

       


      Additional pictures

      Issue screenshot

      Issue Navigator screenshot

      Excel screenshot

            [JSWSERVER-16701] Export to Excel from Issue Navigator wrongly exports colors

            Gosia Kowalska made changes -
            Resolution New: Won't Fix [ 2 ]
            Status Original: Gathering Interest [ 11772 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3070250 ] New: JAC Suggestion Workflow 3 [ 3662753 ]
            Kamil Kolonko made changes -
            Component/s Original: Jira 7.10 EAP [ 51994 ]
            Component/s Original: Jira 7.11 EAP [ 52493 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2747121 ] New: JAC Suggestion Workflow [ 3070250 ]
            Mira Hedl made changes -
            Labels New: excel excel-export export jira
            Mira Hedl made changes -
            Component/s New: Jira 7.10 EAP [ 51994 ]
            Component/s New: Jira 7.11 EAP [ 52493 ]
            Affects Version/s New: 7.10.2 [ 80291 ]
            Affects Version/s New: 7.6.7 [ 79815 ]
            Affects Version/s New: 7.2.15 [ 79814 ]
            Affects Version/s New: 7.11.0 [ 79902 ]
            Affects Version/s New: 7.8.4 [ 79692 ]
            Affects Version/s New: 7.7.4 [ 79890 ]
            Affects Version/s New: 7.9.2 [ 79096 ]
            Affects Version/s New: 7.3.9 [ 77899 ]
            Affects Version/s New: 7.5.4 [ 75441 ]
            Affects Version/s New: 7.4.6 [ 75399 ]
            Description Original: When in Issue Navigator, adding field *Last Comment*, having color in last comment and selecting {{Export -> Excel (Current fields)}}, this will export text with markup that excel can't interpret.

             
            ----
            Additional info...
            h2. Issue screenshot:
            !image-2018-07-23-17-47-31-968.png! Issue Navigator screenshot:


            h2. !image-2018-07-23-17-47-11-602.png! Excel screenshot: 

            !image-2018-07-23-17-46-37-234.png!
            New: When in Issue Navigator, adding field *Last Comment*, having color in last comment and selecting {{Export -> Excel (Current fields)}}, this will export text with markup that excel can't interpret.

             
            Text in JIRA comment: "test {color:#FF0000}comment{color}"
             
            Actual text in exported excel: {code}test {color:#FF0000}comment{color}{code}

            Expected text in Excel:
             - Either plain text: {{test comment}}
             - Or colored one: {{test {color:#FF0000}comment{color}}}


             
            ----
            Additional pictures
            h4. [Issue screenshot|https://image.ibb.co/j8e3By/in_issue.png]
            h4. [Issue Navigator screenshot|https://image.ibb.co/cJwiBy/in_issue_navigator.png]
            h4. [Excel screenshot|https://image.ibb.co/g40X4J/in_excel.png]
            Environment New: Any JIRA 6+
            Mira Hedl made changes -
            Description Original: When in Issue Navigator, adding field *Last Comment*, having color in last comment and selecting {{Export -> Excel (Current fields)}}, this will export text with markup that excel can't interpret.

             
            ----
            Additional info...
            h2. Issue screenshot:
            h2. !image-2018-07-23-17-37-28-649.png! Issue Navigator screenshot:

             
            h2. Excel screenshot: 
            New: When in Issue Navigator, adding field *Last Comment*, having color in last comment and selecting {{Export -> Excel (Current fields)}}, this will export text with markup that excel can't interpret.

             
            ----
            Additional info...
            h2. Issue screenshot:
            !image-2018-07-23-17-47-31-968.png! Issue Navigator screenshot:


            h2. !image-2018-07-23-17-47-11-602.png! Excel screenshot: 

            !image-2018-07-23-17-46-37-234.png!
            Mira Hedl created issue -

              Unassigned Unassigned
              9e4421da4eab Mira Hedl
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: