Is there a way to make the Excel output default the page setup to Landscape, rather than Portrait mode? I would think the vast majority of users would be OK with that.
- is incorporated by
-
JRASERVER-7741 Publish a how-to on customising Excel output
- Closed
[JRASERVER-7489] Excel output should set Landscape mode
Neal,
We want to include this in 3.4 and hence want to leave this open until we implement this.
Cheers,
Nick
I've been able to improve Excel by customizing. You can close this support issue.
Neal,
I agree. I have created JRA-7741 to track this. We will see if we can get this done for 3.4
Anton
I think it would be helpful if Atlassian could publish some guide to customizing the Excel output, along the lines of what you put above. For example, for every Excel output I have to:
1) remove the logo
2) remove the opening lines (1-6)
3) remove the closing Generated by summary
4) Change all cells to vertical alignment - top
5) Change all cells to autofit row
6) Change page setup for paper size, margins, custom footer
etc.
Not everyone will want the same defaults, I understand, but it would help if I could customize my own installation the way our site wants it. Now, I've figured out how to accomplish items 1-3 by simply removing some code from navigator-excel-current.jsp (lines 50-69, 105). If I could somehow have the other preferences automatically be the default in the Excel file, that would be great. I think there are many users who rely on printed or electronic spreadsheets for status meetings.
Cheers.
Wow - great research!
I don't think I will do this... but if you think it's an improvement to JIRA I would suggest you implement those same chanegs in your code base. Cheers.
There is a way to set it but you will need to edit the following files:
./atlassian-jira/secure/views/navigator/navigator-excel.jsp
./atlassian-jira/secure/views/navigator/navigator-excel-current.jsp
You will need to edit them so that the top of the produced html file looks like:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<title>JIRA Issue Navigator for Excel (All)</title>
<META HTTP-EQUIV="Content-Type" Content="application/vnd.ms-excel; charset=utf-8">
<style>
@page
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>general_report</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
Cheers,
Nick
OK then. It's a setting that can be set, but probably just per user.
http://support.microsoft.com/?kbid=213257#XSLTH3135121123120121120120
Jeff Turner
added a comment - Isn't landscape/portrait mode a printing option, not a regular spreadsheet view option? If so, I don't think JIRA can do much to influence this.
Jeff Turner
added a comment - Isn't landscape/portrait mode a printing option, not a regular spreadsheet view option? If so, I don't think JIRA can do much to influence this.
Added this header to the jsp that generates the excel file. This works for excel, the default print type is landscape. This does not seem to work for OpenOffice, but since we don't explicitly support that it is not a big deal.