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

This widget could not be displayed.

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

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

281 views 5 0
Join discussion

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