[TIME-123] Modifiable decimal separator for hours and Excel export

[Andriy Zhdanov]

Many of our users have comma(,) in Excel settings (instead of period(.)) and time report is then generating dates in place of hours. For example, if 7.5 hours is entered, Excel cell value is '7.May'. Could you provide an option for the decimal separator?

By hannuh/Hannu Hytönen on Thu, 16 Dec 2010 00:41:21 -0800

[Andriy Zhdanov]

Decimal separator is determined by (your) locale settings. I personally used to change column format in Excel (i.e. select whole column, right click and chose Number format).

Anyway, I've just added such possibility, I hope it's painless.

You may now set jira.timesheet.plugin.decimalSeparator=, in jira-application.properties.

Note, it affects whole plugin - all gadgets and both html and excel views for all reports.

Note, it is added to 2.0 version and you need to re-install it from plugins repository.

Please let me know whether it helps.

//Committed revision 156816

By azhdanov on Fri, 17 Dec 2010 14:05:11 -0800

[Andriy Zhdanov]

It seems that in newer versions of JIRA like 5.1.x, you have to insert

jira.timesheet.plugin.decimalSeparator=,

into jira-config.properties in the Application Data folder in order to take effect.

By tischer on Tue, 11 Dec 2012 03:32:28 -0800

[Andriy Zhdanov]

Right, btw, I've started https://studio.plugins.atlassian.com/wiki/display/TIME/Advanced+Configuration+Options for all options, tnx.

By azhdanov on Tue, 11 Dec 2012 10:11:44 -0800

[Andriy Zhdanov]

Issue #389 was marked as a duplicate of this issue.

[Former user]

Do you plan to presents this option in the Add-On config panel in JIRA Administration?

[Andriy Zhdanov]

Well, yes, it's an only option left in jira-config.properties after all.

[Andriy Zhdanov]

Hi,

Version 2.6.3 with the 3 new configuration options (Decimal Format and two options for Day Format), is available on Atlassian Marketplace.

Thank you for asking.