Hi,

we are using Jira Project Management Software (v7.3.6#73017-sha1:51437cf), and we still have this issue.

No export to HTML.

Exporting to CSV or XLS still has the date mixup...

eg.:

please help....

Hi scmsupp,

CSV export is available in JIRA Software 7.2.0. See all features in the release notes.

Cheers,
Ignat.

We use JIRA 7.0.10 but there´s no Export to Excel (HTML) just an Export to Excel option. Also there is neither Export to CSV or Export to HTML options either. In what version of JIRA are these available?

I don't think this helps those of us still using JIRA 6.4.x. Will we be getting this support?

Hello,

Just to add some more context:

• The export to Excel (HTML) functionality has always been exporting an html file having .xls extension.

• Now that this functionality has been renamed to Export to HTML, in order to have it working as before, you just have to rename the exported file and change the file extension from .html to .xls.

I hope this helps

Cheers,
Dario

Hi all,

Thank you to everyone who has given the time to watch, vote and comment on this issue. We have recently changed how JIRA exports data from the issue navigation screen.

JIRA no longer supports exporting an Excel file, which renders this bug obsolete. Instead, we now export the HTML report (an identical export, without a .xls suffix) which when opened by Excel, should provide an equivalent result. We recommend migrating to the CSV export for any long term usage of this feature.

I understand this is an extra step for many of you and could be seen as an inconvenience. However, we believe this is a more consistent solution than maintaining interoperability between multiple Excel-like products.

Thank you for your understanding and patience.

Kerrod Williams
JIRA Product Management

Mirroring current concerns, the export is bad. The output is a .csv without any formatting. In addition the selected columns of the export do not match in the export. The logo, exported timestamp etc are all lost. The export was one of key drivers to choose JIRA..

Hello

I did an export as HTML, copy and pasted to an excel file. The formatting and hyperlinks appeared. It's an extra step but better than CSV.

Joe

The export function was always HTML format leaving it up to the excel application to convert the tables (in HTML) to rows/columns.

And to your question in comment, the short answer is no!

Export is truly bad now. It comes down as csv and I have to do a whole bunch of formatting. The selected columns don't match in the export. The logo, exported timestamp etc are all lost. The export was one of key drivers to choose JIRA..

Looks like Atlassian have decided to change the Excel export to a HTML report rather than fixing the Excel export.
Do they ever listen to what their customers want?

Hello,

The problem I am having is that I no longer see the option to export to Excel xls. I can only export to Excel CSV.

I lose formatting and hyperlinks.

thanks

Kerem's solution above works good with Excel 2013.

Thanks!

Please see:

• https://jira.atlassian.com/browse/JRA-61891 - Exports search results to Excel result in empty sheets due to Microsoft update

Thank you Kerem One thing I would add for those of us who do not know Excel too well Go to FILE -> Options --> Trust Center (I had no menu for "Options" lol)
But that worked for us!!! Thanks

I'm afraid that the above comment does not fix this issue for me, as I'm using Libre Office.

Hi all,
To fix the issue please do the following:
Open Excel. Go to Options --> Trust Center --> Trust Center Settings --> Protected View --> Uncheck "Enable Protected View for files originating from the Internet" check box.

Taken from: http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-kb3115322-opening-downloaded-files/19b8ab42-d0c4-402d-aa79-ad86e191fcc9?auth=1

I have to agree, A paid for plugin is not a fix to broken functionality.

Please stop suggesting that a paid plugin (that doesn't work for the cloud version) is a solution or alternative.

As an alternative of the built-in function, Better Excel Plugin will export your issues to real XLSX files. Not only it avoids this problem, it take the best use of the Excel features:

This is also not working on excel 2013. For that version it looks like you will need to remove (KB3115262). Note this requires a reboot.

After removing the patch from Windows 7 Pro "Security Update for Microsoft Excel 2010 (KB3115322) 32-Bit Edition" I can now open the exported ".xls" files from JIRA. These files are really html file that use the MS code in execl to translate in to the BIFF xls file format.

I have not dug in to the patch to find out why MS has stopped this feature.

Thanks for the update Ron.  Will try this.  Let us know how this works out for you.

Keith, if you look at JRA-38174 you will see that this problem started showing up after applying a Microsoft patch. We are seeing the same thing on Office 2010 now, where it was working great for us.

We will be looking to back out the last few patches to see if we can get this to work again. But it looks like something Microsoft has done, not JIRA.

RonW

Updated: Looks like Patch:

Security Update for Microsoft Excel 2010 (KB3115322) 32-Bit Edition

Installation date: ‎7/‎14/‎2016 3:02 AM

Installation status: Successful

Update type: Important

A security vulnerability exists in Microsoft Excel 2010 32-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

I will attempt to back out this patch to see if I can restore the functionality

Something has changed as this was working until yesterday.  Can we get an ETA for a fix?

Yes it does this for us as well. Just started, it was working before is this a new issue?

The "Excel" export file opens blank for Office/Excel 2013 and for Office/Excel 2016.

The root-cause issue was only created at 19/Mar/2012 3:52 PM, give those Atlassian guys a break!

Meanwhile please look into the description of the (and I quote) "legendary support" from Atlassian. https://www.atlassian.com/licensing/purchase-licensing#softwaremaintenance

Isn't it :o(

Can we get any kind of indication on when (or even whether) this will be fixed from someone at Atlassian?

Sad that this is being ignored.

This verified bug affects 75% of the users and is opened for 3,5 years now (I think this issue should be marked as a duplicate, JRA-27567 is the actual problem), but it is still unassigned.

The problem is getting bigger and bigger as more people upgrade from Office 2007 and alternatives (Numbers, Google Docs, LibreOffice or OpenOffice) are getting more popular.

It's only been broken a few years and it's not a sexy UI 'improvement' so don't expect miracles...

Any ideas on timescales for this one? I need to be able to send these reports to my client, and really could do without a conversion process added in to the mix.

Pretty embarrassing at this point. Exporting to XLS (real XLS) is a basic requirement for any tool. Sort it out, guys.

+1 this is really bad.
I want to download and store some filtered Issue into a xls file and include it with my standard Report.
But because the format is f*cked up i have to open each report and save as "real" xls before beeing able to use them as include.

Thought I'd share this workaround to get results into Numbers in OSX. Might work for other setups too.

1. Export to excel
2. Rename downloaded file from .xls to .html
3. Open file in Safari (it renders a perfectly decent html table)
4. Select all text in the main table
5. Paste into empty Numbers table
6. Boom.

And even it was available, a paid plugin can never be a solution for a bug.

"This add-on is not available for Cloud."
No solution for me.

As an improved replacement for the built-in Excel export feature, Better Excel Plugin exports real XLSX format files.

Besides Microsoft Excel, the exported files are compatible with Google Spreadsheets, Open Office (incl. LibreOffice) and Numbers.

Also, there are major advantages of using the native file format for spreadsheets vs. using an HTML table having .xls file extension. See the comparison here.

I don't understand why the developers made this crappy export in the first place. A CSV-export is more useful and easier to develop as well. I really don't understand why this issue takes this long.

The actual problem (the export is HTML, not XLS of CSV: JRA-27567) is more than 3 years old.

So it's been a verified bug for 2 full years. Any risk of it being fixed this decade?
I go through the steps that Michele described countless times a week.

I have MS Office Excel 2010 v 14.0 and JIRA v. 6.2.1. Opening and saving an HTML file with an .xls extension works OK with older versions of Excel (the file is converted automatically in Excel 2003), but is cumbersome with 2010 and higher. Sample file is attached: ORC 1.1.1 (VEIC JIRA).xls. Here is my experience:

• Open Excel 2010
• Run a JIRA search, then click 'Export' > 'Excel (Current fields)'
• The file will be saved with an .xls extension
• Double-click on the file. Excel icon is now blinking on the Taskbar
• Switch to Excel to view message: "The file you are trying to open, filename, is in a different format than that specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
• Click 'Yes' and the file opens
• Click 'Save'
• Message appears: "filename may contain features that are not compatible with Web Page. Do you want to keep the workbook in this format?..."
• Click 'No'
• Change "Save as type" from Web Page (.htm, .html) to Excel Workbook (.xlsx)
• Type a filename and click 'Save'

(Note: I open Excel 2010 first because I also have Excel 2003 on my machine and the file will open in 2003 by default if Excel is not running.)

There are 3 issues that seem to be related. Please vote and ask your colleagues to vote. I like the CSV option best.

• JRA-8580 (CSV Export from the issue navigator) - New Feature, 63 votes
• JRA-27567 (Export to Excel in real xls, not in HTML) - New Feature, 18 votes
• JRA-32352 (Excel Export Is Broken With Office 2010 or 2013 / LibreOffice 4.2 / Numbers) - Bug, 10 votes

I have the same problem described by Haddon above. Running JIRA version 6.2.3 and Office 2010.

I don't actually care about Excel/Numbers/LibreOffice support: my requirement is to be able to get a list of issues out of Jira in a portable structured format that I can use elsewhere (e.g. to send just a list of titles in an email, paste into a slide, etc.).

Rather than chasing proprietary file formats, my recommendation is to remove "Excel Export" and replace it with an ultra-simple "CSV Export".

Hi martinez.de.la.symbioz,

This is an issue we would still like to fix. However, at the moment it is not in our short-term backlog as we are currently working through higher priority issues in other areas of JIRA.

Please do watch this issue as I will update its status as soon as new information is available.

Regards,

Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].

Hi.
Any update of this issue?
This issue is reported for more than 1 year!!!

I have this problem a lot also; it's embarrassing when I show this to clients. I'll send a sample excel file if you want, if you give me an address to send it to (not public).

I'm running Windows 7 SP1 and Office 2013, and every time I try to open the results of an "export filter results to excel", I get the error "The file format and extension of 'JIRA.xls' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?". It renders fine when you click "next".

All of the Windows users here have been upgraded to 2013, but the Mac users are still on the previous version and do not get the error.

In our case, the problem is that what JIRA exports as an .xls file is actually HTML and not an expected Excel format.

ohernandez@atlassian.com, it is the same Excel file that can be exported from any JIRA instance.