Export to CSV: Negative numbers with decimals contain an apostrophe when user locale is non English

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Negative numbers with decimals are not exported correctly to CSV if the user locale is Non-English. They do contain an apostrophe on the front and are treated as text instead of the number

STEPS TO REPRODUCE

1. Go to the project object or any object enabled for MUX
2. Create a number-type field that contains decimals and accepts negative values 
3. Go to the Modern UX and go to the project grid or object grid where the attribute was created
4. Add the number type attribute to the columns
5. Add a value to the field, ie: -20.56
6. Logged in with a user whose locale is English and perform an export to CSV
7. The data is exported and the number type field value shows correct and is treated as a number: -20.56
8. Change the user locale to Spanish, Italian, French ...
9. Log out and log in
10. Perform the same Export to CSV action. Note the UI shows the value with Spanish locale: -20,56
11. Look at the output

Expected Results: The data is exported and the field shows the correct value -20,56 and is treated as a number
Actual results: The data is exported, but the field value shows as '-20,56 and is treated as text, not as a number

Additional information: This only happens with numeric values that contain decimals. If the negative value is an integer then the export is OK

Environment

Clarity 16.1.0 and above

Cause

This is caused by DE70486

Resolution

This is fixed in 16.1.3