Community
Q&A
Jira
Questions
Can import location for Jira add-in Excel be changed from A1?

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

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?

2 answers

2 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

2 votes

Answer accepted

@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 :)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Answer accepted

Hi @Jakub Suchý

No this is not possible.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Jira

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

STANDARD

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

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

2 answers

2 accepted

Comments for this post are closed

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

TAGS

Community showcase

Atlassian Community Events