-
Suggestion
-
Resolution: Won't Fix
-
None
-
None
-
Any JIRA 6+
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
Resolution | New: Won't Fix [ 2 ] | |
Status | Original: Gathering Interest [ 11772 ] | New: Closed [ 6 ] |
Workflow | Original: JAC Suggestion Workflow [ 3070250 ] | New: JAC Suggestion Workflow 3 [ 3662753 ] |
Component/s | Original: Jira 7.10 EAP [ 51994 ] | |
Component/s | Original: Jira 7.11 EAP [ 52493 ] |
Workflow | Original: Confluence Workflow - Public Facing v4 [ 2747121 ] | New: JAC Suggestion Workflow [ 3070250 ] |
Labels | New: excel excel-export export jira |
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+ |
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! |