[TIME-123] Modifiable decimal separator for hours and Excel export
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 (9)
-
reporter -
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
-
reporter 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
-
reporter Issue
#389was marked as a duplicate of this issue. -
Account Deleted Do you plan to presents this option in the Add-On config panel in JIRA Administration?
-
reporter Well, yes, it's an only option left in jira-config.properties after all.
-
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.
-
reporter - edited description
- changed version to 2.7
-
reporter - removed version
Removing version: 2.7 (automated comment)
- Log in to comment
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