I have a calculated text field that is primarily used when a filter is exported from Jira to Excel for offline usage.
I have used "s.append ("< strong>")" and "s.append ("< /strong>")" and also tried it with "s.append ("< b")" and "s.append ("< /b>")". Both options do turn that portion of my calculated text bold in my webbrowser, but when I export it to Excel, it shows the tags as text.
what should I do in order to show this bold in the exported Excel?
Thanks for your quick reply.
Agreed, but the JIRA export is in the .xls format. When I open this file in for instance Notepad++ and edit the content with < strong> and < /strong>, it does show correct in Excel. So for some reason, JIRA is not including the format in the export it creates. It does however include formatting in other cells, like the headers.
I find it strange, since "\n" for a line break does work in the XLS export, but is not shown in JIRA.
Let me clarify: your questions are pushing me in the right direction I think :-) :
The text that is exported in bold to Excel by default (for instance in the header: "Displaying x issues...":
So: if we can get "<" into the export instead of "<", I think it should work.
(I only added the spaces here for visibility)
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG