Excel-like Tables for Jira
Excel-like Tables for Jira
Breadcrumbs

Jira Issues Sheet

Overview

7458a684-1770-4673-a8f5-4f1879a6473f.png

This feature imports Jira issues into the specialized sheet, Jira Issues Sheet for it.

So, it allows you to make use of the contents for a data source.

To create the sheet, in any sheet, press 'Create New Sheet' in the Data tab - Jira Issues Sheet menu group (see the following section).
It will create Jira Issues Sheet as a new sheet.

image-20211028-080928.png

The “Data” tab has the menu group for Jira Issues Sheet.

Menu item

The behavior of the item
image-20211028-081125.png

Create New Sheet

  • Create a new Jira Issues Sheet

  • Default fields are Issue type, Issue key, and Summary

  • Default JQL is “project=<the project of current issue>

  • This action allows you to create multiple Jira Issues Sheet

  • The copied Jira Issues Sheet will also be Jira Issues Sheet
image-20211028-081232.png

Edit JQL

  • Set a JQL for importing Jira issues

  • warning The sheet will be reloaded after modifying settings
image-20211028-081232.png

Edit Fields

  • Set Jira fields that will be displayed

  • warning The sheet will be reloaded after modifying settings
image-20211028-081330.png

Reload

  • Reload the sheet with the given JQL and Jira fields

  • warning On reloading, it clear every cell on the sheet. If you want to use the data of Jira issues, do it on other sheets.

How to move a column

The following instructions allow you to move a column to other columns.

  1. Select the whole column you want to move

  2. Drag the selection rectangle with pressing the Shift key to the point of a target column

  3. Drop it

Screen Shot 2021-10-28 at 5.35.36 PM.png

Restrictions & Tips

  • In rich text fields, it shows string includes HTML tags

  • If you save as ssJSON format, it stores the information of JQL and Jira fields

    • The data will be lost in other formats

  • This feature doesn’t support editing Jira issues. However, for bulk-editing Jira issues, this app(Excel-like Issue Editor for Jira) is suitable for it.