To configure Excel Connector add-in, please open "Settings" (1)
Directly after clicking it, you should notice a prompt (2)
Settings prompt is divided into four sections:
- Performance - as you are informed: "Disabling these options may improve issue loading times significantly". By default "Resize columns automatically" and "Group subtasks and parents automatically" are enabled;
When you disable "Resize columns automatically", then the columns width will not be adjusted automatically, so similar view as above is to be present (1↖).
"Group subtasks and parents automatically" enables to present subtasks in a cloaked or uncloaked way so that you know certain issue is connected with other(s). When this option is enabled then you get such view:
It can be changed (cloaked/uncloaked) for all grouped subtasks and parents by one click on a square with "one" or "two" present as a digit (1↖) or manually for a particular one(s) - thos emarked with "+" sign(2↖)
After pressing + sign you can see which issue type is linked to a subtask:
When this option is disabled, you won't get such possibility:
- Logging - by default "Debug Mode" is disabled. Its role is to collect more data for a log file in case of usage problems - after enabling it you can expect to obtain log file at: C:\Users\%username%\AppData\Local\Transition Technologies S.A\Excel Connector;
- Timeout - 180 seconds is set as a default value to wait for Jira response
- Time Format - "User friendly" mode is set by default. To change value to show it in seconds, please chose the latter option. When the latter option is enabled, you ought to get similar results, converter from e.g. weeks into seconds after clicking "Get Issues" (or after refreshing):
("remaining estimate' and "time spent" data were taken into consideration on below images' columns)
vs user friendly display mode - in days and hours:
