I'm having an issue with JIRA and Excel integration.
Here's my JQL: =JIRA.JQL("project = 'ABC' AND key = '" & A2 & "'", "Status")
TheJQL is set in Excel cell B2. The query checks the status of a specific issue based on the issue key value defined in cell A2.
The data is being pulled correctly, however, when the results are imported into Excel, three extra data rows are added:
- B2 - Starting Import (Taskpane should be opened) at <date/time> by <user>
- B3 - 1 rows imported in 1 seconds
- B4 - Status
- B5- <Status Value>
As you can see, the Status value is moved to cell B5 instead of staying in B2.
How can I ensure that the status value always appears in cell B2, where my query is?
