Versions Compared

Old Version 2

changes.mady.by.user Dominik M.

Saved on

compared with

New Version 3

changes.mady.by.user Dominik M.

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
    • Start MS Excel and create blank workbook
    • Open Excel Connector for JIRA ribbon (1), click Login to JIRA button (2)

    • Enter your credentials and click Connect button (3).

      (info) There's no need to use administrator account when working with Excel Connector.


  • Notice that the ribbon has expanded and the worksheet contents have changed. You are now logged into JIRA and ready to do some work.

Image Modified

...

Information about hidden 3rd row data

After logging in, there's a 3rd row in worksheet that is not visible (see image above). After manually changing its visibility, you can see what it contains (1):

Image Added

More details on 3rd row

When 3rd row is visible, you can see that it contains fields' IDs. It (this 4th row content) is strictly tied with Jira elements and is crucial to successful work of our add-in. You can take a look at the below image presenting column "Sprint" with "customfield_10107" field ID in Jira (you can see this ID in Jira view via Firefox Developers Tools analysis). Its data appear also in corresponding column "Sprint" on worksheet (image above).