How can I customize the spreadsheet format when exporting a list of items to Excel?

[Ismael Masso Arroyo]

I'm trying to generate an Excel report of JIRA items filtered and extracted from Issues Filter area. Fields and Excel file are generated ok but the format is not as I expected. 

 - Logged work time appears in Seconds which is unmanageable.

 - Columns and Rows format are not very presentable.

How can it be customized?

Thanks

[Nic Brough [Adaptavist]]

Code.

You'll need to hack the code that generates the XML output to include your formatting and calculation from seconds to whatever-you-want.

Oops, sorry, only just noticed the "cloud" tag.  That also means you can't make the code changes you need to make.  You can only make code changes on Server version.

[Ismael Masso Arroyo]

I see... Thanks for your reply Nic!

[Ferenc Kiss [Midori]]

Use the Better Excel Plugin.

You can customize the Excel reportsby creating actual Excel files in Excel. No need to write a single line code, unless you want to run Groovy during the export, which opens another horizon for possibilities.

[Nic Brough [Adaptavist]]

Not available for Cloud