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

Issue #123 resolved
Andriy Zhdanov repo owner created an issue

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

Comments (8)

  1. Andriy Zhdanov reporter

    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

  2. Andriy Zhdanov reporter

    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

  3. Andriy Zhdanov reporter

    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.

  4. Log in to comment