Issue Summary

When looking for issues in Jira or fetching issues using the Jira Cloud for Excel or Jira Cloud for Sheets, we can order by fixVersion, which will order the issues considering the fixVersion ID associated with each issue. 

The search is bringing the correct order. However, by either exporting to Excel/Sheets or using the plugin in these tools, we can see that the order is switched if the versions have the same name: if you order by fixVersion DESC, it will bring the issues in fixVersion ascending order, while fixVersion ASC will bring the issues in fixVersion descending order.  

The order is respected on versions for the same project with different names.

The problem happens when comparing versions with the same name on different projects.

Steps to Reproduce

1. On three different projects, create a version with the same name. For example: go to PROJECT1 and create a version with the name version 1, then on project PROJECT2, create a version with the same name version 1 and do the same on project PROJECT3
2. Assign issues to each of these versions
3. Use https://[your-site].atlassian.net/rest/api/3/issue/[issue-key] for one of the issues of each project to check the fixVersion ID of the issues. You should find that information like this on the response:
   
4. Look for the issues in the search (Search > View all issues): fixVersion = "[version created on step 1]" order by fixVersion ASC
   1. Check the results: they should show issues ordering by fixVersion in the order you created: PROJECT1, PROJECT2, PROJECT3.
5. Click on Apps > Open in Google Sheets or Open in Microsoft Excel and watch the results:

Expected Results

The exported file brings the exact same order from the search - PROJECT1, PROJECT2, PROJECT3 (exactly in the order of creation/ID order)

Actual Results

The exported file brings the issues in the opposite order: PROJECT3, PROJECT2, PROJECT1

Workaround

The only workaround to continue using the functionality is to switch the order by - if you want to see the results in ascending order, use ORDER BY fixVersion DESC and if you want them in descending order, use ORDER BY fixVersion ASC