Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-7741

Publish a how-to on customising Excel output

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Fixed
    • 3.4 Beta 1
    • None
    • None
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      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.

        1. navigator-excel-current.jsp
          4 kB

            [JRASERVER-7741] Publish a how-to on customising Excel output

            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"

            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"

            Sam Chang [Atlassian] added a comment -

            link to the "how to customise JIRA excel"
            http://confluence.atlassian.com/display/JIRA/Customising+JIRA+Excel+Output

            Sam Chang [Atlassian] added a comment - link to the "how to customise JIRA excel" http://confluence.atlassian.com/display/JIRA/Customising+JIRA+Excel+Output

            AntonA added a comment -

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

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

              Unassigned Unassigned
              anton@atlassian.com AntonA
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: