Resolution: Won't Fix
NOTE: This bug report is for JIRA Cloud. Using JIRA Server? See the corresponding bug report.
Thank you for commenting and watching this post over the last few weeks. We have read your comments and recognise the inconvenience that this bug may have caused since its initial occurrence.
What went wrong?
JIRA’s feature for exporting issues as an Excel file (.xls) works by creating an HTML file and saving it with an .xls suffix. Up until recently, this solution worked. However, a recent Microsoft Office security update (Microsoft Security Bulletin MS16-088 - Critical) now prevents these files from being opened if the user has a high security setting in place, as the change of the file extension is considered to be a security vulnerability.
What are we doing about this?
We don't believe that our HTML-based Excel export option is the best solution anymore, however we appreciate that many of you have built processes around it and its immediate removal may disrupt your daily operations. The HTML-based Excel export option will, for now, remain in JIRA Cloud.
This feature will be removed for Server in JIRA 7.2.
We will announce this prior to the removal. In the meantime, The exported .html file will also still be readable in Excel, if you have configured your environment appropriately (e.g. Plan Trusted Locations settings for Office 2010).
Recently, a new CSV-based Excel export option was released to JIRA Cloud, and will be in JIRA Server 7.2.
Will we develop a native Excel export option?
We are unlikely to provide a native Excel export in the foreseeable future. Having said that, there are many add-ons in the Atlassian Marketplace that provide this functionality.
Thanks for your patience and understanding.
JIRA Product Management
After a Microsoft update (described below) export Excel sheets can not be done. Excel opens up to a gray window.
*************** Security Update for Microsoft Excel 2010 (KB3115322) 64-Bit Edition Installation date: 7/13/2016 10:28 PM Installation status: Successful Update type: Important A security vulnerability exists in Microsoft Excel 2010 64-Bit Edition that could allow arbitrary code to run when a maliciously modified file is opened. This update resolves that vulnerability. More information: http://support.microsoft.com/kb/3115322 Help and Support: http://support.microsoft.com/?LN=en-us ***************
Windows update did an excel change for security issues.
When the MS update is applied the warning about invalid format is not present and it opens to the blank Excel window.
When the update is rolled back, the export works once again. A warning message "Invalid Extension.jpg" is thrown and the export opens up successfully.
Cloud - JIRA v1000.148.3
Microsoft Excel 2010
Microsoft Excel 2016 version 16.0.7070.2026
Steps to Reproduce
- Export issues to Excel
- Open in Excel with the update applied
xls is loaded successfully without warning or blank pages.
Excel shows a gray page with update applied.
- Use other xls viewer applications.
- According to a customer, the security upgrade of Excel has a selected default that prevents the spreadsheet from loading the data. The following steps to uncheck the said default setting described at the attachment below solved 100% the issue for him:
Enable Excel Extracts from JIRA.docx
(Please, see attachment)
JSWCLOUD-14867 "View in Excel" feature on "Backlog" of Agile boards leads to a 404 error page
JRACLOUD-8580 CSV Export from the issue navigator
- is blocked by
JRACLOUD-45102 Linked Issues should be a Hyper Link in the Excel spreadsheet imported from JIRA
JRACLOUD-59382 Create hyperlinks for linked issues when outputting with Excel
- is duplicated by
JRACLOUD-66846 Provide a feature to export JIRA reports to excel
- Gathering Interest
- is related to
JRACLOUD-68954 Missing export HTML option
JRACLOUD-32352 Excel Export Is Broken With Office 2010 or 2013 / LibreOffice / Numbers
JRASERVER-61891 Search results exported to Excel result in empty sheets due to Microsoft security update
- relates to
JRACLOUD-61244 Export to Excel CSV Current Fields Does Not Show Same Order as WebUI
JRACLOUD-62115 Feedback on the new "Export to CSV" functionality
- Gathering Interest