Hello there,
I see this ticket set to Resolved and a fix being announced for relase 6.1.1. Well, we are using release 6.1.7 and I see no fix. Status icons are still exported in the Excel export. What exactly is the announced fix? Is it a setting somewhere? I cannot find anything. Please provide the details of the fix or I would appreciate if you reopened the ticket.

When will JIRA 6.1.1 be available?

Hi all,
probably you already know that, but the problem arises also with Excel exports from downloaded version.
Infact the status icon wasn't included in the previous versions.
Marco

To all watching the issue, I have good news to share

A fix for this problem should be arriving in JIRA 6.1.1

Regards,

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

This is a major issue and is a time waster. The images are not needed in an Excel export.

I agree with Karie.
This is not a minor issue and our automated reports too doesn't work properly.
Susan's solution is temporary, but still we have to wait enormous amounts of times to download simple Excel file, and then clean the unwanted images, and then present the report. All these steps are not called for and we need an effective solution or simply rollback to the previous functionality as images are not a value addition definitely.

Seems that this is not minor if it deters users from utilizing excel exports; if the latter, then we would have a major issue because we utilize excel exports to create pivot reports for various analysis as well as additional communications. If it takes significantly longer, then users complain and won't do it. A workaround with 5 steps is not acceptable. Surprised this got through QA given the exponential increase in file size generated.

I tried Susanne's workaround and it worked well (Thanks Susanne).

However, it still adds 5 extra steps, so it is still a nuisance.

Hi Susan,
Thanks for the Excel technique. Its amazing and works.
But the bottomline is that huge time taken to download the issues in Excel format. This needs to be fixed somehow.

Another issue I noted and raised separately is: order of fields in Jira filter is not preserved. There is some change in this functionality. Every time you need to log off and log on to Jira to affect these changes. Any observers on this issue?

Regards,
Srikrishna

I've updated the workaround in the description, thanks John and Adrijus.

adrijus.jakulevicius@addendum.lt john.thompson It'll depend on your text editor... some can do regular expression searches (I use TextMate on Mac OS X), and a regular expression search for:

<img(.*)>

does the trick.

Thanks Susanne. I have also been doing that once the spreadsheet opens - trouble is that it takes about 15 minutes to initially open (depending on the number of issues in the spreadsheet of course).

I found a workaround for myself. With the spreadsheet open in Excel, press F5 and you will get a Go To menu. Click Special, then click Objects and then OK. All of the images will then be highlighted and you can just press the delete key to get rid of them. This may not work for everyone's purposes but it does for mine.

Sorry Nick - as Adrijus says this doesn't work.

We need a proper resolution for this issue. Can you please give us an ETA for fixing this?

Hi,
this is not workaround, because each record contain icon depending on issue status:
...images/icons/statuses/open.png
...images/icons/statuses/inprogress.png

Please try to export 3.000 recors and open it in excel.

As a temporary workaround until this bug is fixed, you can open the exported Excel file in a text editor and do a search for all of these lines:

<img src="https://jira-base-url/images/icon-jira-logo.png" width="57" height="30" border="0" alt="Filter name">

And replace them with just empty space.

Hi,

Same experience for us, we use the export to excel function for better making an overview and presentation, and to import them into different systems, and now this does not work anymore, because of this sudden change from your side.

please revert back to the old model for the export to excel without the images e.g. please!

Best regards

Rasmus H. G. Johnsen
Platform Operations
Bestseller A/S

Excel export does not work the same way as before. Earlier for each filter you can save the column configuration. Now this facility seems missing. Added to that I saw same columns exported twice - which is clearly a bug. Please comment if you have any work-arounds for this.

Same problem seen here. This is very painful as I use the export to excel facility regularly (at least daily) so the extra 15 minutes or so to open the exported spreadsheet adds up to a lot of unproductive time. Please fix this urgently.

Same is experienced by us. Icons are visible after Atlasian's maintenance on last week. Before that we never used to get the icons on status column. An 800kb file earlier now costs me 18MB and opens nearly after 30 minutes or hangs sometime.
This behavior is weird and effects all our testing and development effort.

Hi,
New jira version exports issues with icons in Status column.
Excel opens about 100 times longer compare to excel without icons.
PLEASE REMOVE ICONS.
It is impossible to view excel with more than 4000 rows.

Hi

Please can we request an urgent fix for the above since it does affect all export of excel reports.

It slows the time it takes to open the report as well as the file size is large.

Can you escalate the priority since affects any report that is exported to excel.

The status field is an important measurement that is a requirement for many reports.

Regards

Showkat