Minor version update

This version fixes two classloading problems in the default Groovy scripts.

Bugfixes

• Replacing default imports with explicit imports.

IMPORTANT: if you are using custom Groovy scripts, please read the release notes carefully!

See the full release notes →

This version introduces Java 17 support, Groovy 4 support and various fixes.

Improvements

• Java 17 support.
• Groovy 4 support.

Security fixes

• Updated dependency: Apache Groovy.
• Updated dependency: Apache POI.
• Updated dependency: Apache XMLBeans.

See the full release notes →

This version is a compatibility release for the Jira 9.3 line.

Important: this version is not compatible with Java 17 yet! Java 17 compatibility will come with the next version.

See the full release notes →

This version is a significant maintenance release that fixes the non-critical bugs discovered recently. Also, it comes with several new Excel export options and useful improvements.

Improvements

• New configuration variable allows excluding Jira Service Management internal comments from the Excel exports. (export sample)
• New Excel export options export the fields plus the issue links in separate columns grouped by link type and direction. (export sample)
• 6 new "repeating field" Excel export options allow creating pivot tables, pivot charts and other reports from worklogs, Tempo worklogs and change histories. (export sample)
• (and a lot more!)

Bugfixes

• Fixed: Exporting extremely long field values fails with "IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters".
• Fixed: When errors occur during exporting from Jira 9.1.0 or newer, the Excel file displays "StackOverflowError" and hides the original problem.
• (and a lot more!)

See the full release notes →

This version is a compatibility release for the Jira 9 line.

See the full release notes →

In this release, we fixed minor inconsistencies in the default Excel templates. There are no changes in functionality.

New in this release

• Excel template consistency improvements

See the full release notes →

This version is a maintenance release that fixes a single problem caused by an API change made by Atlassian.

Bugfixes

• Fixed: Expressions relying on the "issue.getCustomField(String id)" method cannot be evaluated in Jira 8.19. (These expressions may appear in Excel templates and in Groovy scripts. Although only a single default script relies on this, see the next item, it may also be used in custom Excel templates and scripts.)
• Fixed: The default script insight-tool.groovy results in "groovy.lang.MissingMethodException: No signature of method: com.atlassian.jira.mail.TemplateIssue.getCustomField() is applicable for argument types".

See the full release notes →

In this major version, we optimized the internals of the Excel file generator for faster exports that require less memory even in case of very large exports. This version also comes with a few important bugfixes.

New in this release

• Major performance and memory use improvements

Bugfixes

• Fixed: In formulas, a cell reference doesn't get updated unless there is a space in front of punctuation/operators. (The formula parser has been fixed to recognize the case of a new cell reference following a comma, a right parenthesis, or a double-quote character.)
• Fixed: ".xlsm" templates are exported with the ".xlsx" extension from saved filters.
• Fixed: Jira Service Desk (4.6.1 or newer) queue screen header layout gets broken by the "Export" button.
• Fixed: "SLA Successful?" field is broken in the "workflow-report.xlsx" template.

See the full release notes →

Bugfixes

• Fixed: "java.lang.ExceptionInInitializerError" and "org.apache.xerces.stax.XMLEventFactoryImpl cannot be cast to javax.xml.stream.XMLEventFactory" exceptions are thrown after upgrading to Jira 8.13.4.

See the full release notes →

This version is a compatibility release for Xray 4.0 and newer versions.

It is backward compatible with earlier Xray versions, therefore you're encouraged to upgrade even if you use those.

New in this release

• Compatibility with Xray 4.0 and newer versions.

See the full release notes →

This version is a compatibility release for the Jira 8.13 line.

Bugfixes

• Fixed: "Could not instantiate global transform class org.spockframework.compiler.SpockTransform" exception is thrown at each Groovy script execution when ScriptRunner 6.11.0 is also installed.

See the full release notes →

This version is a compatibility release for the Jira 8.12 line.

Bugfixes

• Fixed: Some ScriptRunner-managed script custom fields are exported in unexpected format.
• Fixed: Some fields are exported in unexpected format using the "structure.xlsx" template.
• Fixed: Jira dashboard screens are sometimes lagging when the app is installed.

See the full release notes →

Bugfixes

• Fixed: Excel views become available in the "Export" menu of the Tempo Timesheets screens only after resizing the browser window.

See the full release notes →

This version comes with a vastly improved classloading approach for Groovy scripts.

New in this release

• Improved classloading.

Improvements

• The new context object ClassHelper provides helper methods to access components provided by other apps. It simplifies writing integration-type Groovy scripts.

See the full release notes →

This version is a maintenance release for the latest Tempo version.

Bugfixes

• Fixed: Excel views are not available in the "Export" menu of the Tempo Timesheets screens when using Tempo 10.16.0 or newer.

See the full release notes →

New in this release

• Support for Git Integration.

Improvements

• The new Groovy script "git-integration-tool.groovy" provides general helper methods for working with Git commits managed by the Git Integration app. These can be useful for any custom Excel template that wants to export Git information.
• You can export the Jira Service Desk "Satisfaction" field values using either the score-only or the score-plus-customer-comment format depending on a new configuration option.

Bugfixes

• Fixed: Exporting structures using the "structure.xlsx" template breaks for issue summaries containing pipe characters ("|").

See the full release notes →

This version introduces a new integration with Structure, the hyper-popular Jira app to manage complex issue hierarchies.

New in this release

• Support for Structure.

Improvements

• supports conditional execution of scripts using the "test" attribute.
• "structure-tool.groovy" provides general helper methods for working with issue hierarchies managed by Structure.
• "$xlsViewContext" identifies the "export context" (the screen) which the document generation was initiated from.

Notable changes

• 7 Excel views are visible by default in the Structure screen.

Bugfixes

• Fixed: Xray "Manual Test Steps" custom field is exported with blank "Data" and "Expected Result" information when those are undefined.
• Fixed: Xray "Test Execution Status" custom field is exported as JSON for non-matching issues.
• Fixed: Xray "Test Run Executed By" column is blank when using Jira 8 and compatible Xray versions.
• Fixed: Jira Misc Custom Fields "Transition Callers" fields are not exported.

See the full release notes →

New in this release

• Support for Xray.
• Support for Jira Misc Custom Fields (JMCF).
• Support for project exports.

Improvements

• The scripts "xray-tool.groovy" and "zephyr-tool.groovy" differentiate Zephyr tests vs. Xray tests on the existence of product-specific custom fields, to avoid collisions.
• Values of Profields Duration type custom fields are exported as hours (e.g. 90 minutes is exported as 1.5).
• Values of ScriptRunner custom fields configured with the Duration Searcher are exported as hours (e.g. 90 minutes is exported as 1.5).

See the full release notes →

This major version introduces internal API changes that are not visible for the end-user, but make automations more robust under the hood.

Starting from this major version, we reworked certain low-level technical details to make automations more robust. According to our testing, wiring and classloading problems should not occur anymore!

See the full release notes →

This version is a compatibility release for Jira 8.6.1.

★IMPORTANT★ If you are using Jira 8.5.2 or Jira 8.6.0 (both are broken!), don't forget to upgrade your Jira version (otherwise the app won't work)!

Improvements

• Support for Jira Service Desk 4.6.0.

Bugfixes

• Fixed: "Contexts" checkboxes are misaligned when editing Excel views.

See the full release notes →

This version is a compatibility release for Tempo Timesheets 10.10.

New in this release

• Compatibility with Tempo Timesheets 10.10.

See the full release notes →

This version is a compatibility release for Tempo Timesheets 10.7.

New in this release

• Compatibility with Tempo Timesheets 10.7.

See the full release notes →

New in this release

• Support for ScriptRunner (script custom fields).
• Support for Color Custom Fields.

Improvements

• The new configuration option EXCLUDED_CUSTOM_FIELD_TYPE_KEYS in "issue-navigator.groovy" allows excluding custom fields by type from "issue-navigator.xlsx" based exports and its variants.
• The new configuration option EXCLUDED_CUSTOM_FIELD_IDS in "issue-navigator.groovy" allows excluding custom fields by ID from "issue-navigator.xlsx" based exports and its variants.
• Exporting multiple Service Desk SLA fields is significantly faster (e.g. 3.5x faster for 200 issues and 4 SLA fields per issue).

Bugfixes

• Fixed: When exporting Zephyr test executions, a confusing 406 HTTP message is exported for tests without executions.
• Fixed: Zephyr exports fail due to the missing (newly introduced) "isUI" request parameter.

See the full release notes + upgrade guide →

New in this release

• Support for the Profields custom field types.

See the full release notes →

New in this release

• Support for the Portfolio for Jira custom field types.

Bugfixes

• Fixed: An automation rule does not use the filter's column configuration if the JQL is like "Filter = 123" (instead of "filter = 123").

See the full release notes →

This version is a compatibility release for the Jira 8 line.

See the full release notes →

As you probably know, Better Excel Exporter already supports Jira Data Center deployments (i.e. clustered Jira). To be precise, those are supported since app version 1.3.0 (released in Jan 2016).

In 2018, Atlassian re-launched its Data Center program and introduced new testing criteria for "Data Center approved apps". This version is the official release for the revised program, tested to live up to the rigorous demands of Data Center environments.

New in this release

• Better Excel Exporter is a Data Center approved app!

See the full release notes →

This version fixes two classloading problems in the default Groovy scripts.

Bugfixes

• Replacing default imports with explicit imports.

IMPORTANT: if you are using custom Groovy scripts, please read the release notes carefully!

See the full release notes →

This version introduces Java 17 support, Groovy 4 support and various fixes.

Improvements

• Java 17 support.
• Groovy 4 support.

Security fixes

• Updated dependency: Apache Groovy.
• Updated dependency: Apache POI.
• Updated dependency: Apache XMLBeans.

See the full release notes →

This version is a compatibility release for the Jira 9.3 line.

Important: this version is not compatible with Java 17 yet! Java 17 compatibility will come with the next version.

See the full release notes →

This version is a significant maintenance release that fixes the non-critical bugs discovered recently. Also, it comes with several new Excel export options and useful improvements.

Improvements

• New configuration variable allows excluding Jira Service Management internal comments from the Excel exports. (export sample)
• New Excel export options export the fields plus the issue links in separate columns grouped by link type and direction. (export sample)
• 6 new "repeating field" Excel export options allow creating pivot tables, pivot charts and other reports from worklogs, Tempo worklogs and change histories. (export sample)
• (and a lot more!)

Bugfixes

• Fixed: Exporting extremely long field values fails with "IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters".
• Fixed: When errors occur during exporting from Jira 9.1.0 or newer, the Excel file displays "StackOverflowError" and hides the original problem.
• (and a lot more!)

See the full release notes →

This version is a compatibility release for the Jira 9 line.

See the full release notes →

In this release, we fixed minor inconsistencies in the default Excel templates. There are no changes in functionality.

New in this release

• Excel template consistency improvements

See the full release notes →

This version is a maintenance release that fixes a single problem caused by an API change made by Atlassian.

Bugfixes

• Fixed: Expressions relying on the "issue.getCustomField(String id)" method cannot be evaluated in Jira 8.19. (These expressions may appear in Excel templates and in Groovy scripts. Although only a single default script relies on this, see the next item, it may also be used in custom Excel templates and scripts.)
• Fixed: The default script insight-tool.groovy results in "groovy.lang.MissingMethodException: No signature of method: com.atlassian.jira.mail.TemplateIssue.getCustomField() is applicable for argument types".

See the full release notes →

In this major version, we optimized the internals of the Excel file generator for faster exports that require less memory even in case of very large exports. This version also comes with a few important bugfixes.

New in this release

• Major performance and memory use improvements

Bugfixes

• Fixed: In formulas, a cell reference doesn't get updated unless there is a space in front of punctuation/operators. (The formula parser has been fixed to recognize the case of a new cell reference following a comma, a right parenthesis, or a double-quote character.)
• Fixed: ".xlsm" templates are exported with the ".xlsx" extension from saved filters.
• Fixed: Jira Service Desk (4.6.1 or newer) queue screen header layout gets broken by the "Export" button.
• Fixed: "SLA Successful?" field is broken in the "workflow-report.xlsx" template.

See the full release notes →

Bugfixes

• Fixed: "java.lang.ExceptionInInitializerError" and "org.apache.xerces.stax.XMLEventFactoryImpl cannot be cast to javax.xml.stream.XMLEventFactory" exceptions are thrown after upgrading to Jira 8.13.4.

See the full release notes →

This version is a compatibility release for Xray 4.0 and newer versions.

It is backward compatible with earlier Xray versions, therefore you're encouraged to upgrade even if you use those.

New in this release

• Compatibility with Xray 4.0 and newer versions.

See the full release notes →

This version is a compatibility release for the Jira 8.13 line.

Bugfixes

• Fixed: "Could not instantiate global transform class org.spockframework.compiler.SpockTransform" exception is thrown at each Groovy script execution when ScriptRunner 6.11.0 is also installed.

See the full release notes →

This version is a compatibility release for the Jira 8.12 line.

Bugfixes

• Fixed: Some ScriptRunner-managed script custom fields are exported in unexpected format.
• Fixed: Some fields are exported in unexpected format using the "structure.xlsx" template.
• Fixed: Jira dashboard screens are sometimes lagging when the app is installed.

See the full release notes →

Bugfixes

• Fixed: Excel views become available in the "Export" menu of the Tempo Timesheets screens only after resizing the browser window.

See the full release notes →

This version comes with a vastly improved classloading approach for Groovy scripts.

New in this release

• Improved classloading.

Improvements

• The new context object ClassHelper provides helper methods to access components provided by other apps. It simplifies writing integration-type Groovy scripts.

See the full release notes →

This version is a maintenance release for the latest Tempo version.

Bugfixes

• Fixed: Excel views are not available in the "Export" menu of the Tempo Timesheets screens when using Tempo 10.16.0 or newer.

See the full release notes →

New in this release

• Support for Git Integration.

Improvements

• The new Groovy script "git-integration-tool.groovy" provides general helper methods for working with Git commits managed by the Git Integration app. These can be useful for any custom Excel template that wants to export Git information.
• You can export the Jira Service Desk "Satisfaction" field values using either the score-only or the score-plus-customer-comment format depending on a new configuration option.

Bugfixes

• Fixed: Exporting structures using the "structure.xlsx" template breaks for issue summaries containing pipe characters ("|").

See the full release notes →

This version introduces a new integration with Structure, the hyper-popular Jira app to manage complex issue hierarchies.

New in this release

• Support for Structure.

Improvements

• supports conditional execution of scripts using the "test" attribute.
• "structure-tool.groovy" provides general helper methods for working with issue hierarchies managed by Structure.
• "$xlsViewContext" identifies the "export context" (the screen) which the document generation was initiated from.

Notable changes

• 7 Excel views are visible by default in the Structure screen.

Bugfixes

• Fixed: Xray "Manual Test Steps" custom field is exported with blank "Data" and "Expected Result" information when those are undefined.
• Fixed: Xray "Test Execution Status" custom field is exported as JSON for non-matching issues.
• Fixed: Xray "Test Run Executed By" column is blank when using Jira 8 and compatible Xray versions.
• Fixed: Jira Misc Custom Fields "Transition Callers" fields are not exported.

See the full release notes →

New in this release

• Support for Xray.
• Support for Jira Misc Custom Fields (JMCF).
• Support for project exports.

Improvements

• The scripts "xray-tool.groovy" and "zephyr-tool.groovy" differentiate Zephyr tests vs. Xray tests on the existence of product-specific custom fields, to avoid collisions.
• Values of Profields Duration type custom fields are exported as hours (e.g. 90 minutes is exported as 1.5).
• Values of ScriptRunner custom fields configured with the Duration Searcher are exported as hours (e.g. 90 minutes is exported as 1.5).

See the full release notes →

This major version introduces internal API changes that are not visible for the end-user, but make automations more robust under the hood.

Starting from this major version, we reworked certain low-level technical details to make automations more robust. According to our testing, wiring and classloading problems should not occur anymore!

See the full release notes →

This version is a compatibility release for Jira 8.6.1.

★IMPORTANT★ If you are using Jira 8.5.2 or Jira 8.6.0 (both are broken!), don't forget to upgrade your Jira version (otherwise the app won't work)!

Improvements

• Support for Jira Service Desk 4.6.0.

Bugfixes

• Fixed: "Contexts" checkboxes are misaligned when editing Excel views.

See the full release notes →

This version is a compatibility release for Tempo Timesheets 10.10.

New in this release

• Compatibility with Tempo Timesheets 10.10.

See the full release notes →

This version is a compatibility release for Tempo Timesheets 10.7.

New in this release

• Compatibility with Tempo Timesheets 10.7.

See the full release notes →

New in this release

• Support for ScriptRunner (script custom fields).
• Support for Color Custom Fields.

Improvements

• The new configuration option EXCLUDED_CUSTOM_FIELD_TYPE_KEYS in "issue-navigator.groovy" allows excluding custom fields by type from "issue-navigator.xlsx" based exports and its variants.
• The new configuration option EXCLUDED_CUSTOM_FIELD_IDS in "issue-navigator.groovy" allows excluding custom fields by ID from "issue-navigator.xlsx" based exports and its variants.
• Exporting multiple Service Desk SLA fields is significantly faster (e.g. 3.5x faster for 200 issues and 4 SLA fields per issue).

Bugfixes

• Fixed: When exporting Zephyr test executions, a confusing 406 HTTP message is exported for tests without executions.
• Fixed: Zephyr exports fail due to the missing (newly introduced) "isUI" request parameter.

See the full release notes + upgrade guide →

New in this release

• Support for the Profields custom field types.

See the full release notes →

New in this release

• Support for the Portfolio for Jira custom field types.

Bugfixes

• Fixed: An automation rule does not use the filter's column configuration if the JQL is like "Filter = 123" (instead of "filter = 123").

See the full release notes →

This version is a compatibility release for the Jira 8 line.

See the full release notes →

As you probably know, Better Excel Exporter already supports Jira Data Center deployments (i.e. clustered Jira). To be precise, those are supported since app version 1.3.0 (released in Jan 2016).

In 2018, Atlassian re-launched its Data Center program and introduced new testing criteria for "Data Center approved apps". This version is the official release for the revised program, tested to live up to the rigorous demands of Data Center environments.

New in this release

• Better Excel Exporter is a Data Center approved app!

See the full release notes →

Bugfixes

• Fixed: Excel views are not available on screens of Tempo Timesheets 9

See the full release notes →

Bugfixes

• Fixed: Zephyr test steps are not rendered with "issue-navigator-with-zephyr-test-steps.xlsx" template
• Fixed: Zephyr test step results are not rendered with "issue-navigator-with-zephyr-test-step-results.xlsx" template
• Fixed: default column configuration is exported when saved filter is modified in Issue Navigator

See the full release notes →

New in this release

• "Better Excel Plugin for Jira" is now called "Better Excel Exporter for Jira"!
• Improved support for Jira Service Desk custom fields
• Support for the Development Summary custom field type (branches, commits, pull requests)
• More error-tolerant export of "non-officially-supported" custom field types
• Limit for concurrent Excel renderings

Notable changes

• "All fields" type Excel views are not activated for the Issue Navigator context, by default. (You can, of course, turn those on any time.)

Improvements

• Support for the Insight custom field type "Insight Object/s".

Bugfixes

• Fixed: SLA values are exported as blank cells from more recent Jira Service Desk versions
• Fixed: pivot tables are not rendered with the template zephyr-report.xlsx due to a broken named range reference

See the full release notes + upgrade guide →

This version is a compatibility release for the Jira 7.11 line.

Notable changes

• $componentManager was removed from the rendering context. Read the full release notes to learn what it means for custom templates and scripts.

See the full release notes →

Bugfixes

• Fixed: "Export" menu in Jira Software boards cannot be opened due to a Javascript error in Jira 7.10.0+.
• Fixed: "Export" menu is not visible on Service Desk queue screen with Jira Service Desk 3.10.0+.

See the full release notes →

Bugfixes

• Fixed: "Sum values" may be unset for some pivot tables (resulting in blank pivot tables in some templates)

See the full release notes →

New in this release

• Support for Tempo period- and user filters
• Faster export of Tempo worklogs via pre-loading
• Support for Time to SLA
• Support for user properties

Improvements

• Formatting is consistently set to "dd/mmm/yyyy" for date and "dd/mmm/yyyy hh:mm" for date-time values in all templates shipped with the app.

Bugfixes

• Fixed: JIRA Service Desk SLA field values are not exported with more recent Service Desk versions.

See the full release notes →

This version is a compatibility release for the Jira 7.6 line.

Support for Zephyr

Zephyr is the most popular test management solution for the Jira platform. From this Better Excel Plugin version, you can export Zephyr tests, test steps, test executions and test step results to Excel. Four templates are provided out of the box that solve the most typical Excel exporting and reporting use cases (and as always, can be customized!). See some sample exports from Zephyr and learn more about this integration.

Improvements

• Default titles and default filenames are generated according to a slightly revised logic: "issue key" (for single issues), "search request name" (for saved filters with a name), "Excel view name (Jira title)" in this order of precedence.

Bugfixes

• Fixed: character encoding in Tempo worklog comments (that use international characters) may break when exporting from Jira instances hosted on Windows
• Fixed: "Reporter" column is empty with the "created-vs-resolved-report.xlsx" or "insight-report.xlsx" templates

See the full release notes →

This version is a compatibility release for the Jira 7.5 line.

Major performance improvements

We reworked the resource intensive operations in the add-on code and in the default templates for faster and more stable Excel exports.

New "Performance Tuning" page

We compiled a page about what to do and what to avoid when developing custom templates for large scale of data.

Improvements

• New tag parameter can specify the cell padding to avoid "######" cells and unwanted text wrapping (both caused by narrow columns).
• New tag parameters can drastically speed up auto-sizing by limiting the cell region to test for optimal column width and optimal row height.
• New tag parameter makes it faster to render horizontal iterations.
• Blank cell coloring helps to verify if your templates are clean and tidy.
• Cell-level logging can generate super-detailed logs for trouble-shooting (you will rarely need it, but it's there now).

Read the full release notes and follow the upgrade guide

The nFeed add-on integrates external data sources (SQL databases, LDAP, Active Directory, REST APIs, Salesforce, CSV files, etc.) to Jira. From this version, Better Excel Plugin