Export Issues to Excel are Read-Only with the "Excel Connector for JIRA" version 1.1.0

I'm actually testing a plugin "Excel Connector for JIRA" from Transition Technologies S.A.

I contacted them and they said that the problem is on my side because they can't reproduce it.

When I export Issues from JIRA 5.1 to Excel, my excel file is automatically in [Read-Only] and [Protected View]. Even if all my settings in the "Excel Trust Center" are set to allow everything it doesn't work. As soon as I sync data between Excel and JIRA my workbook is back to "Protected View".

Is there a way to set JIRA to sent it in full rights mode ??

Thanks.

2 answers

1 accepted

Hi John,

This is not an existing file. Il's a file generated by JIRA when issues are exported to Excel. Even after saving a file the read only flag is not ON.

To give you more details. Let say I export issues in Excel and unprotect the workbook, as soon as I sync data with the plugin the read only is back on. That's why I'm positive that the solution must come from JIRA and not Excel. Everything as been done on Excel side to avoid that situation.

Thanks

0 vote

Hi Jeff,

Can you disable the read-only excel in your environment first befre test in JIRA?

  1. Make sure that the file is not open in Excel.
  2. On the Windows Start menu, point to Programs, point to Accessories, and then click Windows Explorer.
  3. In the Exploring window, open the drive or folder that contains the file.
  4. Click the file name.
  5. On the File menu, click Properties.
  6. Click the General tab.
  7. Clear the Read-only check box.

Good luck.

Regards,

John Chin

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

Meet the AUG leaders of Northern Virginia

@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....

118 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you