JIRA
  1. JIRA
  2. JRA-7741

Publish a how-to on customising Excel output

    Details

    • Type: Task Task
    • Status: Resolved (View Workflow)
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.4 Beta 1
    • Component/s: None
    • Labels:
      None

      Description

      From Neal Applebaum:

      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.

        Issue Links

          Activity

          Hide
          Anton Mazkovoi [Atlassian] added a comment -

          We should create a confluence HOW-TO for this. Just like we have tutorials for making custom fields, reports, etc.

          Show
          Anton Mazkovoi [Atlassian] added a comment - We should create a confluence HOW-TO for this. Just like we have tutorials for making custom fields, reports, etc.
          Hide
          Sam Chang [Atlassian] added a comment -
          Show
          Sam Chang [Atlassian] added a comment - link to the "how to customise JIRA excel" http://confluence.atlassian.com/display/JIRA/Customising+JIRA+Excel+Output
          Hide
          Neal Applebaum added a comment -

          Well, that was quite a cryptic link to a non-programmer.. but I appreciate it.
          With a little work, it got me exactly what I needed. I used information from there as well as what i found on the net:
          http://www.tcphp.org/meetings/code-to-generate-excel-documents
          to customize my .jsp file. I am attaching it to this issue.
          It has been customized to:
          1) remove logo
          2) remove opening lines 1-6
          3) remove Generated by summary
          4) place issues with line breaks in component (or description) field within the same cell
          5) print in landscape mode
          6) show gridlines when printing
          7) set left/right margins to .25 inches
          8) set top margin to .25 inches
          9) set bottom margin to .75 inches
          10) create a footer showing title "JIRA Issue List", page count, date/time stamp
          11) sets alignment of all cells to be vertically at the top
          12) sets alignment of all cells to be left aligned (with word wrap enabled... I think)
          13) sets Worksheet name to "JIRA Issue List"

          Show
          Neal Applebaum added a comment - Well, that was quite a cryptic link to a non-programmer.. but I appreciate it. With a little work, it got me exactly what I needed. I used information from there as well as what i found on the net: http://www.tcphp.org/meetings/code-to-generate-excel-documents to customize my .jsp file. I am attaching it to this issue. It has been customized to: 1) remove logo 2) remove opening lines 1-6 3) remove Generated by summary 4) place issues with line breaks in component (or description) field within the same cell 5) print in landscape mode 6) show gridlines when printing 7) set left/right margins to .25 inches 8) set top margin to .25 inches 9) set bottom margin to .75 inches 10) create a footer showing title "JIRA Issue List", page count, date/time stamp 11) sets alignment of all cells to be vertically at the top 12) sets alignment of all cells to be left aligned (with word wrap enabled... I think) 13) sets Worksheet name to "JIRA Issue List"

            People

            • Assignee:
              Sam Chang [Atlassian]
              Reporter:
              Anton Mazkovoi [Atlassian]
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: