Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-2188

[JIRAALIGN-2188] Separation character in a Jira Align export (comma) conflicts with number formatting

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 10.85
    • 10.80
    • Import|Export
    • 1
    • Severity 3 - Minor
    • Batman! - Usher5

      Issue Summary

      Issue found in Objective export.

      When a user create key results that contain numeral values such as an amount, the number is automatically formatted as "10,000,000"

      When exporting the key result as excel file, the result is displayed, as per the template guideline as 

      This create issues when number is used in the key result such as the example below:

      The comma inserted by Jira Align when entering number values gets reflected in the export, and make the comma separator inadequate

      Steps to Reproduce

      1. Create an objective
      2. Set some key result including numbers such as $10,000 
      3. export the objective and notice the key result field

      Expected Results

      Ideally the separator may be different than comma (one suggestion from customer is ||

      Actual Results

      Comma is used in both separator and number formatting making a use of the export for data processing inadequate

      -To note that the comma in numbers is not entered by users but by Jira Align

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

              cgottlieb@atlassian.com Caz (Inactive)
              0ed961e27eb4 Erwann (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: