[#JRA-7315] Linked issue list in XLS export isn't created properly

JIRA

Linked issue list in XLS export isn't created properly

Created: 13/Jul/05 03:41 PM Updated: 18/Oct/06 08:47 PM

Component/s:

Issue navigator

Affects Version/s:

3.2.1

Fix Version/s:

None

Time Tracking:

Not Specified

Issue Links:

Reference

This issue relates to:

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

Participants:	Jay Proulx, Nick Menere [Atlassian] and Scott Farquhar [Atlassian]
Since last comment:	91 weeks, 3 days ago
Resolution Date:	18/Oct/06 08:47 PM
Labels:

Description

« Hide

When doing an export to excel, the Issue Links column only displays HREF's for single links.

e.g.
~~JRA-6070~~ will render properly (the appropriate link to the issue is added)

~~JRA-6070~~, ~~JRA-6070~~, ~~JRA-6070~~ will not (no links)

All

Comments

Work Log

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Jay Proulx - 13/Jul/05 04:25 PM

Sorry, this one isn't in the right component, and I'm referring to the IssueNavigator.jsp page.

[ Permlink | « Hide ]

Nick Menere [Atlassian] - 13/Jul/05 07:29 PM

Thanks for reporting Jay.

As far as I can tell this seems to be an excel issue. When I save the file to disk and look for the keys they are enclosed in an href. If I open the file in excel I do not see the links and if I save the file from excel it saves the field value as only the key text. If I open this .xls file in open office then it renders the html correctly. I have tried to find some information about this on the web, but have not found anything as of yet. I will keep looking and if we can find a workaround we will include the fix in a future version of Jira. Sorry I don't have a workaround on offer at the moment.

Cheers,
Nick

[ Permlink | « Hide ]

Jay Proulx - 13/Jul/05 08:18 PM

Not a problem at all! I will let you know if I come up with anything.

I create .xls files by forcing an attachment, type application/ms-excel named whatever.xls and just write html to it and let excel sort it out. Are you doing it the same way?

[ Permlink | « Hide ]

Jay Proulx - 13/Jul/05 08:22 PM

Ahh, I see what you mean. Just to test I created 2 links in Word and pasted them into excel, but no link showed up. Copying 1 link and pasting it into excel preserved the link.

I would have to assume that Excel links the cell and not the content. I'll keep my eyes open for you.

[ Permlink | « Hide ]

Nick Menere [Atlassian] - 13/Jul/05 08:39 PM

Cheers Jay.

[ Permlink | « Hide ]

Scott Farquhar [Atlassian] - 18/Oct/06 08:47 PM

As this is a problem with Excel, I'm closing this issue.