The workaround worked for us as well, and solved a major user complain without having to go through the entire installation, export, import process. Much thanks.

I have a workaround that fixes it in our install - edit the above file in the deployment directory, and wrap the last line, the one with the offending div, in a conditional (pulled from the content above it) to only output the DIV if the display is NOT Excel:

Greg, you are a star! that worked as expected (after a Jira restart) thanks got me out of a real hole there..

• we nearly stopped out Jira 3->4 rollout this weekend because of this. Now I can go ahead, phew...

Hi,

What is the eta for 4.2.2?

Early January

Cheers,
Peter

After some digging, I can narrow the problem down to a change in the XML used for the "Summary" navigator column specifically. Remove that column from your Issue Navigator display, and the Views > "Excel (current fields)" download looks right in Excel - one row per issue, no vertically merged cells.

You are not outputting actual Excel binaries, but XML with the ".xls" file extension and Excel MIME type in the HTTP response headers and the Excel XML namespace in the content.

That content looks like this for Summary column cells:

                                   <td class="nav summary"  ><p>
                send email (without password) to new user even if it is from LDAP
    </p>
<div class="ie7minWidth"></div>
</td>

Remove the DIV (which appears to be a hack for proper display inside IE7 only?), and the row is processed as expected by Excel, with no merged cells.

I've not been able to adjust the CSS to have Excel process that cell as a single row without causing the whole row to consist of vertically merged cells.

This HTML comes from WEB-INF/classes/templates/jira/issue/field/summary-columnview.vm in the JIRA WAR file or standalone document root.

I have a workaround that fixes it in our install - edit the above file in the deployment directory, and wrap the last line, the one with the offending div, in a conditional (pulled from the content above it) to only output the DIV if the display is NOT Excel:

OLD
{{ <div class="ie7minWidth"></div>}}

NEW

#if ( ! ${displayParams.excel_view})
    <div class="ie7minWidth"></div>
#end

Hello!

What is the eta for 4.2.2?

Thank you! (didn't see a fix version for it)

This will be fixed in JIRA 4.2.2

We have noticed this too, new with the 4.2.1 upgrade. In addition, column A is always prepended with the issue number, so instead of "Bug" it now reads "DOCS-198 Bug", which makes sorting extra challenging. I have worked around this by changing my default navigator to have an always-blank field in the first column.

It's quite annoying, as I use Excel exports regularly. Please fix this soon!