|
Jeff,
Sorry about the hassle here, this was broken as part of the fix for This has been refixed for 3.4.3 Cheers Mark C Thanks, Mark. Could you post the fixed file for Current and All views?
Would like to patch our 3.4.2 if possible. Jeff I believe that Neal's version should work fine, but attached is the version that will be released with JIRA 3.4.3.
I've tested it locally and it seems to work fine Appreciate your help, again, Mark. I just tried your jsp, and it did
not work for me. I tried Neal's, and it works fine. It looks like yours still has the mso-data-placement: in the old location as well as split out. You may want to take a peek and just leave one of them attached to the ticket. Again, thank you! Jeff,
Thanks for the report. Both ways work for us here locally, so I suspect different versions of Excel may react slightly differenty. I've only added the mso-data-placement:same-cell to the BR for 3.5 FYI we're using Excel 2003 (11.5612.5606) Cheers, Mark C FYI, I am using Excel 2003 (11.6355.6408) SP1. Odd that it works for you but not for Jeff. Maybe it's better to have the br portion before the page portion?
By the way, Jeff, I have made some other improvements to my Excel output. I've customized it so I don't have to manually remove the header/footer (which spans cells and prevents column re-ordering), the image (which I never really saw the need for), and customized footer (e.g. JIRA Issue List page x of y), etc. Let me know if you want help customizing it for your site. I also wrote an Excel macro to remove the hyperlinks from the issue key column (to send files to clients), and customized it to not include the Tools column (if you are using the Toolkit) if it was in the navigator. Thanks for the additional comments from both of you. I am using the same version of excel as Mark, on a Win XP SP2 laptop. I also have excel links enabled to open in new windows instead of in IE. Maybe that could be the difference as well.
Jeff,
Sorry to be a pain but can you also try this version Cheers Mark C |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 |
|
Bug
Resolved
Critical
Excel All still splits Description across multiple rows
The problem you're having is because the correct code is:
(lines 28-42):
<style> br { mso-data-placement: same-cell; } @page { mso-page-orientation:landscape; margin:.25in .25in .5in .25in; mso-header-margin:.5in; mso-footer-margin:.25in; mso-footer-data:"&R&P of &N"; mso-horizontal-page-align:center; mso-vertical-page-align:center; } </style>instead of
<style> @page { mso-page-orientation:landscape; margin:.25in .25in .5in .25in; mso-header-margin:.5in; mso-footer-margin:.25in; mso-footer-data:"&R&P of &N"; mso-horizontal-page-align:center; mso-vertical-page-align:center; mso-data-placement: same-cell; } </style>I've also attached a file which worked for me in 3.4.1 test standalone. I'm not yet live on 3.4, but it worked in my test (I didn't even have to restart JIRA). Upload the file to replace the one in secure\views\navigator\navigator-excel-current.jsp
Cheers!