New and Improved 3.13 Beta. Highlights: Shareable filters and dashboards and lots of other goodies. Any feedback can be raised as JIRA issues in the JIRA project.
Issue Details (XML | Word | Printable)

Key: JRA-1679
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Lars Kühne
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
JIRA

Use Excel types instead of Strings

Created: 13/May/03 07:29 AM   Updated: 05/Jul/06 10:43 AM
Component/s: Import / Export
Affects Version/s: 2.0.2
Fix Version/s: 3.7

Time Tracking:
Not Specified

Environment: -Duser.language=de_DE on the server, german version of Excel and english browser on the client
Issue Links:
Reference
 

Participants: Lars Kühne and Scott Farquhar [Atlassian]
Since last comment: 2 years, 6 weeks, 4 days ago
Resolution Date: 05/Jul/06 10:43 AM
Labels:


 Description  « Hide
The column Created, Updated, Time Estimate and Time Remaining cannot be used for further processing inside Excel. The reason is that the data is a String instead of a date / numeric value.

For example it would be nice to know the estimated remaining time per developer and project, and Excel could be used to implement the grouping and summing up the individual values. Problem: Excel (at least the german version) does know know how to sum "2 days" and "5 days" because those are Strings, not numbers.

For the Created and Updated columns it might be sufficient to do the i18n correctly. Right now I get a mix of german words and english notation: "8/Mai/03". If I change that to the correct german notation "8. Mai 03" Excel recognizes the String as a date and I can sort the line accordingly.

Not sure if Jira would benefit from other server/client language combinations (see environment description).



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Scott Farquhar [Atlassian] added a comment - 05/Jul/06 10:41 AM
Time Estimate and Time remaining seem to be in seconds now, so you should be able to use them for calculations. (as of at least JIRA 3.6)

Scott Farquhar [Atlassian] added a comment - 05/Jul/06 10:42 AM
It appears that dates work for me also. They seem to be in full time format '20/4/2006 1:12:00 PM'.

I'll close this issue, unless this still seems to be a problem for you.

Cheers,
Scott


Scott Farquhar [Atlassian] added a comment - 05/Jul/06 10:43 AM
This was probably fixed a long time before 3.7, but I know that it is at least fixed in that version.