Issue Summary

Via the Excel or Google Sheets plugin, it is possible to export properties for fields, besides the value of the field itself.

For example: by selecting status transition, it is possible to also select transition date, id, and authorEmail, among other properties. Selecting Log Work, it is possible to also select timeSpentSeconds, comment, and created, among others. Selecting comment, it is possible to also select updated, created, author, and text, among others.

Whenever such an attribute to the field is selected, if there is more than one value associated with the issue (so if there is more than one status transition, more than one log work, more than one comment, and so on), Excel duplicates the whole issue line for each attribute.

This behavior may sometimes lead to timeouts, mainly when selecting many issues at a time, since more data needs to be retrieved and added to the sheet.
Additionally, this leads to confusion since even if an issue limit is set (for example, 5000 issues), more than 5000 rows may be retrieved as each issue may have duplicated lines.

The suggestion would be to change this behavior so that instead of duplicating the rule, the different values are separated by commas or semicolons, as already happens for labels, comments, work logs, and other multiple values fields. 

Steps to Reproduce

• In your site, pick an issue and transition it a few times
• Open Sheets or Excel and use the plugin to retrieve that issue, making sure to select one of the following fields: transition.from, transition.to

Actual Results

The export will duplicate the row with the issue, bringing one row for each transition performed

ExportUsingExcel.mp4

For example:

Suggestion

The export could bring one row with the issue, adding the different values to the same column, separated by commas or semicolons:

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available.