Issue Summary

When exporting form data to XLSX, if the search results have more than 50 rows, the issue keys will only show at 50 row intervals. The other rows will have the issue data, but not have the issue keys. An example export showing this is attached to this ticket.

Steps to Reproduce

There are a few different ways to export form data, such as exporting from issue search.

Another way is to export from the service project settings:

1. Navigate to a service project > Project settings
2. Click on Forms from the left-hand side navigation bar
3. Click the 3 dot menu next to the form > Export in XLSX
4. Open the file once downloaded

Expected Results

All the rows will show the issue keys

Actual Results

The results will be split and not have the issue keys between 50 row intervals.

Workaround

It is possible to avoid this issue by limiting your export to 50 issues at a time (and them combining the exported files). You can limit searches by narrowing the timeframe of your search (for example limit your search to tickets created within a certain week) or limiting the results based on the issue keys (for example, return only tickets where the issuekey > "KEY-100" and issuekey <= "KEY-150").

Here are the steps:

1. Run a basic search or advanced search using the tips above to limit the search results to 50 issues or fewer.
2. Export form data
3. Repeat steps 1 and 2 for all the issues that you want to export (ensuring you only export up to 50 issues in each export)
4. Combine the exported XLSX files into one file