Excel Connector settings description - details and examples [3.5.x]

To configure Excel Connector add-in click on "Settings" (1), new dialog will appear (2).

Settings dialog is divided into five sections:

Performance

By default Resize columns automatically and Group sub-tasks and parents automatically options are enabled. When you disable Resize columns automatically option, the columns width will not adjust automatically. Your sheet will look similarly as shown below (1):

Group sub-tasks and parents automatically search whole sheet for parent issues and their sub-tasks. If both are found, it moves all sub-tasks under their parents issues. This option also allows you to easily hide and show sub-tasks by clicking on either boxes with numbers (1) or boxes with '+' and '-' (2) next to parent issue.

As this documentation is made using Jira Cloud and in it, sub-tasks are not available, to be used in it, no example can be used to illustrate it (more information - https://confluence.atlassian.com/jirasoftwarecloud/setting-up-issue-types-in-next-gen-projects-949233753.html). To see how it looks on Jira Server version, please check here.

Logging - by default "Debug Mode" is disabled. Its role is to collect more data in case of problems. It'll help our developers if in case of errors, user could enable Debug mode, do a faulty actions again and send us a log file found at: C:\Users\%username%\AppData\Local\Transition Technologies S.A\Excel Connector;
Timeout - it's the time (in seconds) that Excel Connector waits for response from Jira before displaying the timeout error. In case of slower internet connection or requests for a lot of data at the same time you can increase this value so the timeout error won't appear.
Time Format - It changes format in which time is displayed in columns displaying time. User friendly option is selected by default. If you need to switch time format to seconds just select second option and refresh sheet or get new issues. Time will convert to a selected unit of time.

(Look at 'Time Spent' column on below images)

Time format Seconds - image above

Time format User friendly - image below

5 minutes = 300 seconds

8 minutes = 480 seconds

Behavior

Auto select single issue ribbon - when enabled, it lets to automatically change to single issue ribbon - by doing so, after opening a new excel window with new sheet (i.e via CTRL+N keys shortcut) you will be automatically logged-in there, with the same credentials.

Auto log-in to new sheet - if it is enabled, then it is possible to instantly log in to new Excel's sheet (this can be done via Shift+F11 keys shortcut) using the same credentials as originally provided. If disabled, then for each new sheet, there's an additional need to log in to Excel Connector.