We recently upgraded to Office 2010 and our group policy blocks the opening of XML files due to security concerns. Since JIRA exports as XML but tags as xls, it appears to Save as a spreadsheet but is really an XML file. Is there a file to modify the output default settings?
Actually the downloaded file from Jira is not XML rather html. So if you okay with a bit of mouse clicks, you can do the below workaround to open in Excel 2010.
Rename the downloaded .xls as .html. Open the file in Internet Explorer. Right click the displayed table and say, 'Export to Excel'. You should have the data now in Excel (You will lose the formatting and the HTML links to issues).
Um, it has to be xml, or it's not an xml output and can't be read. If you look carefully at the files that are downloaded, you'll actually find they're named as office files already.
I'm not aware of anything that would generate the files as though they had been saved by Office 2010, so I'm afraid you'll probably have to write it for yourself. I don't know how "open" a format it is. The point of xml is that it's commonly readable, and not allowing the opening of xml files on modern computers is basically a bit silly (it's certainly pointless as a security measure)
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork? We've compiled a list here, along 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