The Published Sheets screen for the add-on allows Jira administrators to monitor and maintain all of the exports created by the add-on. Administrators can perform the following actions from the Published Sheets screen:
To access the Published Sheets screen, navigate to the Jira add-ons administration section in your Jira instance, and on the left side you will find the Published Sheets link under a Excel Online Integration heading. Click this link to access the Published Sheets screen.
The Published Sheets screen shows a table listing every Excel Sheet created by the add-on, one per row, in descending order by created date. The list is split into multiple pages if enough exports have been created. You can also jump directly to a sheet on any page by selecting the sheet from the Select Sheet drop down at the top of the screen.
Each row in the table includes the following information:
- The sheet name and a link to the sheet
- The date and time when the sheet was created
- The name of the user who owns the sheet
- The ID of the search filter used for the list of Jira issues in the sheet (if applicable)
- The date and time when the sheet was last updated
- The sheet's update schedule (if applicable)
- The Actions button, to perform additional actions on a sheet
From the Published Sheets screen, Jira administrators can perform the following actions on the sheets:
View a Sheet
To view a sheet listed on the Published Sheets screen, simply click on the name of the sheet you want to view. The sheet will be displayed in a new window/tab in your web browser.
Change a Sheet's Owner
To change a sheet's Jira owner from the Published Sheets screen, click on the owner drop down and choose a new owner from the user picker. Changes to sheet owners take effect immediately. Note: This action is changing the Jira owner of the sheet, not the Microsoft Account owner. This controls which user can see the sheet on the Export screen in the Update Existing Sheet drop down.
Change a Sheet's Update Schedule
To change a sheet's update schedule from the Published Sheets screen, select a new schedule option from the drop down in the Update Schedule column. Changes to sheet update schedules take effect immediately.
If a sheet is missing information necessary to determine or set it's update schedule, an information icon (
) will appear in this column instead of a drop down. In this situation the sheet may have to be recreated from the Export screen.
Update a Sheet
Sometimes it is necessary to refresh all of the Jira issue data in a sheet. To do this from the Published Sheets screen, simply click the Actions button for the sheet you wish to update, then choose Update Now from the Actions menu. Updating all issue data in a sheet sometimes takes a while, so please be patient. Once the process is complete, a success dialog will appear on the screen, and the sheet's Last Updated column value will change to reflect the recent update.
Delete a Sheet
The Published Sheets screen allows a Jira administrator to easily delete a sheet without having to find the sheet in your organization's Microsoft site. Simply click the Actions button for the sheet you wish to remove, then choose Delete from the Actions menu, and confirm your request. Deleted sheets cannot be recovered, so be absolutely sure you want to delete the sheet before continuing.
