Open

 

Excel 365 Connector for Jira

Excel 365 Connector for Jira allows you to manage your Jira issues using MS Excel 365

Release Notes:

v3.0.1 (2024-04-11) New improvements:

• New default sorting type in Schema: Column alphabetically A-Z

• Only unreleased and release version available on dorp-down list in the Fix Version/s and Affect version/s fields

• Minor bug fixes

• Minor technical updates

v3.0.0 (2024-03-13) New improvements:

New Features and improvements:

• New Issue operations view (old Worklogs)

• Refreshed Templating view

• Changes in General view

• New menu Issue operations

• No more limits for trial version

• FAQ section

• Minor UI fixes

• Minor bug fixes

v2.19.2 (2024-02-05) Minor bug fixing:

• Minor technical updates

v2.19.1 (2024-02-01) Minor bug fixing:

• Bug fixing

v2.19.0 (2024-01-29) New improvements:

• New UI of the "Visible Fields" tab, now renamed as "Schema”

• New look for modals: Change Schema, Edit, Delete, Reorder

• More options for filtering fields

• Bug fixing

v2.18.0 (2023-12-13) New improvements:

• New look for modals Import, Export, Refresh, Save as a filter,

• New option for logged time “Time in a second”

• Bug fixes

v2.17.1 (2023-11-30) Major bug fixing:

• Fixing copy logs on macOS system

• Fixing default schema set up

• Fixing display of warning message

• Updating the help guide links

v2.17.0 (2023-10-20) New improvements:

• New view for help guide

• New view for warnings and errors

• New view for toast notifications

• Bug fixing

v2.16.0 (2023-09-28) New improvements:

• New view for menu

• New view for section “About”

• Bug fixing

v2.15.0 (2023-09-18) New improvements:

• New view for Log in screens.

• Added drop-down support for field “Labels”

v2.14.0 (2023-08-10) New improvements:

• New column order in default schema

• Fixing problems with issue transition

• Added dropdown support for field Components

v2.13.3 (2023-07-19) New improvements:

• Dropdown list for field Affects version

• Support for Assets/Insight object

v2.13.2 (2023-06-29) Minor bug fixing and improvements:

• Improved validation after editing incorrect parent ID for Sub-task

• Fixing coloring for changes in fields: parent ID, Key

• Fixed typos in information prompt

• Fixed problems with validation of Issue type

• Added warning prompt for user without editing permission

• Blocked data formatting in read only mode

v2.13.1 (2023-05-29) Minor bug fixing and improvements:

• Added warning about an invalid issue if its parent issue has been deleted

• Added detection of errors entered offline after turning on the application

• Blocked the ability to create new issues for users without permissions

• Fixed problems with the mechanism for adding and deleting new issues

• Fixed problems with clearing outdated warnings after refreshing and importing issues

v2.13.0 (2023-04-24) New features and improvements:

• Removing new issues

• Last Used filter in read-only mode

• Fixed adding worklogs issues

• Changed invalid characters in jql

• Bug Fixes

v2.12.0 (2023-03-23) New features and improvements:

• Refresh Selected Issues

• Selection of default visible fields schema

• UI improvements

• Fixed issue with deletion of sheet in the workbook

• Bug Fixes

v2.11.0 (2023-02-13) New features and improvements:

• Fixed issue with removing required value

• Fixed issue with different schemas for different issue types

• Fixed issue with incorrectly colored cells after showing new fields

• Small UI fixes and improvements

v2.10.0 (2023-01-25) New features and improvements:

• New Logger Settings UI

• Show Column ID for field in Visible Fields and link it to the cells

• Small UI fixes and improvements

• Checkboxes are now accessible from keyboard

• Linked Issue field error to cell

• Fixed validation of field Parent and Select List (cascading)

• Added tooltip for changed visible fields schema

• Fixed error with required fields for different issue types

v2.9.0 (2022-12-08) New features and improvements:

• Fixed problem with Required Time Tracking field

• Fixed issues with Cascading Select List field

• Minor bug fixes

v2.8.0 (2022-11-22) New features and improvements:

• Added fixes and improvements for Visible Fields Schema

• Fixed problem with incorrect sorting of issues after refresh

• Fixed issue with importing select List (cascading) custom field

• Added Service Management field: Request Type (read-only)

v2.7.0 (2022-10-13) New features and improvements:

• New feature - Visible Fields Schemas with custom selected fields

• Logs are now possible to download from Home Page

• Fixed sorting issues after refresh action

• Last used filter can be seen after choosing different filter and selected again

v2.6.2 (2022-08-31) Minor bug fixing

• Fixed issue with dropdown values on unmodifiable fields

• Newly added field is now coloured correctly

• Fixed problem with incorrect mapping of field Reporter

• Log in - Fixed issue with multiple different timer values during verification

• Minor improvements and fixes of user interface

v2.6.1 (2022-08-16) Minor bug fixing

• Fixed bugs with exporting new issues with Time Tracking and Parent fields

• Fixed problem with incorrect mapping of new issues with Epic type

• Visible Fields List is now in alphabetical case-insensitive order

• Expired Session error is no longer visible after renewed logging in

• Minor improvements of user interface in Data Formatting Settings section

v2.6.0 (2022-08-02) Compatibility with Jira 9.x

• Added compatibility with Jira 9.x

v2.5.0 (2022-07-28) Improvements

• When user logs time, Start date is calculated from current user time (Customer Request)

• Added ability to change date format in app settings (Customer Request)

• Custom Fields - Support for new custom field: Select List (cascading)

• Header is now visible even when scrolling down

• Minor bug fixes

v2.4.0 (2022-07-06) Improvements

• Added dropdowns support for fields: Priority, Issue Type, Fix Version

• Added ability to disable dropdowns injection

• Added ability for user to collect logs in file format

• Fixed issue with cloning formatting in new column after add column operation

• Fixed problem with metadata sorting

• Minor fixes on the interface side

v2.3.0 (2022-04-20) Improvements

• Custom Fields - Support for new custom field Project Picker

• Create Issue - When creating new issue Excel will scroll down to new row

• Export Issue - Fixed warning related to evaluation license

• Getting started page (Jira Data Center / Server) for administrators

• UI improvements

v2.2.0 (2022-02-23) Improvements

• Custom Fields - Support for new custom field Group Picker (multi group)

• Trial Limitations - Limit of issues to send has changed from 5 to 25

• Standard Fields - Project and Issue Type fields are not case-sensitive now. Improved communication about errors in these fields.

• Settings - Changes in settings are now auto-saved

v2.1.0 (2022-01-24) Improvements

• Custom Fields - Support for new custom field: Version Picker (single version) and Group Picker (single group)

• Templating - Field Issue Key now returns correct value instead of n/s

• Expired Session (Jira Cloud) - Toast with information about expired session will not disappear also after clicking on toast, user will be logged out

• Errors - Even better error handling

• Read Only Mode - Now after fetching data from filter that returns no tasks, sheet will not be affected

• Show/Hide Issue Fields - Fields key, project, summary, issue type are now visible

• Minor UI/UX improvements

• Minor bug fixes

v2.0.0 (2021-12-21) ​New User Interface

• New User Interface

  Version 2.0.0 brings new user interface - we changed all views to standardize and simplify the app UI. We believe this will greatly improve user experience. Moreover, in each section you will find details about it’s usage and links to documentation (also refreshed). We’ve added better error handling, so now you can see all information in each view.

• Feedback

  Please use our dedicated customer portal in case of any issues with new UI, improvements or new feature ideas: Support Portal

v1.9.0 (2021-08-04) Issue Structures

• Sending issue structures – ability to design and send issue structure. Users can now create parent issues and sub-task that are connected to each other by temporary issue ID.

v1.8.1 (2021-07-15) Fetching users improvements

• New option in settings allowing to run a live fetch of users, eg. if assignee was not visible on sheet, which resulted in validation error, now Excel 365 Connector will search for that user in Jira

v1.8.0 (2021-06-16) Performance improvement, global settings and login improvements

• New, better approach for fetching, rendering and saving data - now Excel 365 Connector for Jira is quicker than before

• User settings are saved as global settings in Excel - each time user create new document, setting will be the same

• Logging into Jira Cloud is done automatically when the last obtained authorization did not expired

• Improved persistent-state mechanism allows to store “remember me” data for Jira Server - user no longer need to have to enter data to the new workbook (new excel file)

• Support for “Sprint” field (read only)

• Minor bug fixing

v1.7.1 (2021-05-11) Time tracking improvements, Bug fixing

• Time Tracking column

• Fixed issue with duplicated last column on login to saved files

• Fixed issue with worklog feature not available for non-admin users

v1.7.0 (2021-04-26) Read-only import, support for Epic Link

• Fetching issues in read-only mode - ability to import raw issue data from Jira and work with them without tracking changes.

• Fields reordering improvement - now your new order of visible fields will be applied immediately after saving changes

• Support for new field: epic link

v1.6.0 (2021-04-01) Columns reordering and improvements in Templating

Improvements:

• "Fetch issue" and "Search issue" option in "Templating" feature - possibility to use issues independently of the main "Fetch issue" option for sheets

• Added field IDs in visible fields setting - with this improvement you can be sure if you are using correct fields and it can speed up the templating

• Visible fields reordering - with drag & drop easily change order of fields to rearrange the columns

• Timestamp - detailed information when issues were pulled from Jira or when spreadsheet was refreshed

• Improve "Undo" option in "Templating" - now it is possible to revert more than last change

Minor bug fixing

v1.5.0 (2021-03-22) Templating, More supported fields

New features:

• Templating - new feature, allowing to insert variables into spreadsheet and fill it with specified issue data. It can be used for creating templates and fill it in real time (powered by Excel).

  Insert variables in your spreadsheet then select range (cells to be updated) and fill all selected variables with data from selected Jira issue.

• Support to new fields: Sub Tasks, Linked Issues, Epic name

Bug fixing:

• Minor bug fixing

v1.4.2 (2021-02-11) Support for security level field, minor improvements

Improvements:

• support for security level field

• changes in the default visible fields

• minor improvements related to the login form

v1.4.1 (2021-01-13) Improvement, bug fixing

Improvement:

• Added support for “Number” type field in Next-gen projects

Bug Fixing:

• Characters encoding problem is resolved

• Minor bug fixing