Guide for users

On this page:



Launch Issue Editor

Issue navigator


Project sidebar


Edit

Copy and paste

Copy (CTRL+C/Windows or CMD+C/MacOS)

Mouse selectPaste (CTRL+V/Windows or CMD+V/MacOS)


Inline editing

Double-click or press "F2" to edit

Revert

After selecting cells, Revert (CTRL+Z/Windows or CMD+Z/MacOS)Changes discarded

Supported fields

* : display only fields

System fields

  • Type *
  • Key *
  • Summary
  • Description
  • Priority
  • Assignee
  • Reporter
  • Affects Version/s
  • Fix Version/s
  • Component/s
  • Status *
  • Created *
  • Updated *
  • Resolution
  • Due Date
  • Labels
  • Environment
  • Votes *
  • Watchers *
  • Security Level
  • Original Estimate
  • Time Spent *
  • Remaining Estimate
  • Progress *
  • Σ Original Estimate *
  • Σ Time Spent *
  • Σ Remaining Estimate *
  • Σ Progress *
  • Project *
  • Work Ratio *
  • Images *
  • Resolved *
  • Creator *
  • Sub-Tasks *
  • Linked Issues *

Custom fields

  • Date Picker
  • Date Time Picker
  • Number Field
  • Text Field(single line)
  • Text Field(multi-line)
  • Text Field(read only) *
  • URL Field
  • Version Picker(single version)
  • Version Picker(multiple versions)
  • Project Picker(single project)
  • User Picker(single user)
  • User Picker(multiple users)
  • Group Picker(single group)
  • Group Picker(multiple groups)
  • Checkboxes
  • Radio Buttons
  • Select List(single choice)
  • Select List(multiple choices)
  • Select List(cascading)
  • Labels

Jira Software

  • Epic Color *
  • Epic Link *
  • Epic Status *
  • Epic/Theme
  • Rank *
  • Sprint *
  • Epic Name
  • Flag
  • Dev Summary Custom Field *

Jira Service Desk

  • Approvals
  • Customer Request Type *
  • Organizations *
  • Request Participants *
  • SLA CustomField Type *

Color Custom Fields

  • Picker Color
  • Select Color

Save

Click "Save" or shortcut (CTRL+S/Windows or CMD+S/MacOS)

Hierarchy View

That hierarchy view function is to display Jira's subtask, Epic Link of Jira Software and Parent-child relationship of WBS Gantt-Chart for Jira.

Display all issues

Click the button

Context Menu

Right-click on the row number

Drag and drop

You can change parents in "Hierarchy View".

Cross-hair-cursor will display over the top or bottom of the grid line.

Select the row

Drag cross-hair-cursor

Sort and filter

Display all issues

Click column header


Search

Input a keyword and Enter

You can use shortcut (CTRL+F/Windows or CMD+F/MacOS) to move focus on the search box.

Settings

Columns

Issue Editor use column configuration of the issue navigator.

For more details about the issue navigator, please look Atlassian documentation.



Additional Help

If you have any questions please feel free to ask a member of the Atlassian community!

Add the tag "addon-jp.ricksoft.plugins.excel4jira" when you ask a question.