JIRA.JQL() Function in Excel

[Alanis_ Hans]

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?

[Jehan Bhathena]

Hi @Alanis_ Hans 

I'm not quite sure of the integration you've mentioned, perhaps you can share a link to this integration reference, based on that we maybe able to answer your query better.

[Nir Sarusy]

As I also have the same problem, I would try to explain the problem:

We're using the Jira Cloud Plugin for Excel.

This plugin adds, among other ways, the option to use JQL in form of  Excel formula

( JIRA.JQL() ).

What @Alanis_ Hans  described is that when he placed the formula on cell B2, and the formula references to a value in cell A2, obviously, he expects that the result will appear in cell B2, as a "regular" Excel formula (the cell which contains the formula displays the formula result's value),

BUT because of the prompts " Starting Import (Taskpane should be opened) at <date/time> by <user" and other prompts that the plugin writes, the desired value appears in column B5.

I looked for a setting in the plugin that will hide the unnecessary prompts, but could find such.
My explanation came out too long, sorry for that...