Can import location for Jira add-in Excel be changed from A1?

Question

I'm using Jira Cloud add-in for Excel. The imported data is always placed starting at cell A1. Is there a way to configure the import location so that data is imported starting from another cell (e.g. A6) and refreshed there as well?

Marc -Devoteam- · Accepted Answer

Hi @Jakub Suchý

No this is not possible.

The import takes A1 as first if this is empty, then the import will fail.

Duc Thang TRAN · Accepted Answer

@Jakub Suchý

You can use function excel jira.jql on cell A6

For exemple :

=JIRA.JQL("project = Myproject ORDER BY created DESC","issuetype,priority,duedate",6000)

Hope this help :)