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

Original Estimate field's Excel export format should be configurable

    XMLWordPrintable

Details

    • 9
    • 48
    • 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.

    Description

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Atlassian Update – 4 January 2016

      Hi everyone,

      Thanks for voting and commenting on this issue. Your feedback is key to helping us understand how you use JIRA so we can continue improving your experience. We have reviewed this issue over the last few days; unfortunately we don't have any plans to support this in JIRA for the foreseeable future.

      Please remember that jira.atlassian.com is one of many inputs for the JIRA roadmap. You can learn more about our process here.

      I understand that our decision may be disappointing. Please don't hesitate to contact me if you have any questions.

      Regards,
      Dave Meyer
      dmeyer@atlassian.com
      Product Manager, JIRA Platform

      The Original Estimate field, which in JIRA is displayed as 1 day, 2 days, 2 weeks, etc. is converted to seconds per 7-hour day when it reaches Excel. For example, a task that is 1 day in JIRA appears as 25200 in Excel.

      I see a bug where this was done in order to implement sorting of time, but is there a way to switch this back to preserve the original date formatting - we don't need to sort by second and we would like to not have to manually reconvert back to dates.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-7438 "Current Fields" excel view of time-related fields is really bad for any post-processing in excel

          • Medium - Medium priority issues
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-23619 Time Tracking converted to seconds on export tickets to Excel

          • Low - Low priority issues
          • Closed

          Suggestion - JRASERVER-27675 Make it possible to choose base unit of time for excel exports

          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-26580 Issue Navigator Excel export change time to seconds format

          • Medium - Medium priority issues
          • Gathering Impact
          relates to

          Suggestion - JRASERVER-66524 Test

          • Closed

          Suggestion - JRACLOUD-8898 Original Estimate field's Excel export format should be configurable

          • Gathering Interest
          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Wiki Page Loading...

          Activity

            People

              Unassigned Unassigned
              fdba065ccea7 Christopher Woodill
              Votes:
              286 Vote for this issue
              Watchers:
              190 Start watching this issue

              Dates

                Created:
                Updated: