Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-1679

Use Excel types instead of Strings

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Fixed
    • 3.7
    • Import / Export [Deprecated]
    • -Duser.language=de_DE on the server, german version of Excel and english browser on the client
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      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).

            [JRASERVER-1679] Use Excel types instead of Strings

            Scott Farquhar added a comment -

            This was probably fixed a long time before 3.7, but I know that it is at least fixed in that version.

            Scott Farquhar added a comment - This was probably fixed a long time before 3.7, but I know that it is at least fixed in that version.

            Scott Farquhar added a comment -

            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 added a comment - 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 added a comment -

            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 added a comment - 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)

              Unassigned Unassigned
              2445c6318d9c Lars Kühne
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: