"Please enter a valid number" editing number type attributes

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

At times you get the error "Please enter a valid number" when editing number type attributes if the user locale uses comma as a decimal separator

STEPS TO REPRODUCE:

1. Administration > Studio > Objects > Project object
2. Create a Number type attribute with 2 decimals
3. Add it to a project blueprint
4. Change the user locale to any that uses comma as a decimal separator, let say Spanish
5. Associate a project to the above blueprint
6. On the number type field add a number like 4,32 (note the comma as decimal separator)
7. Edit the number type field add a number like 3.25 (note the dot as decimal separator)
8. When you move away the decimal separator changes from a dot to a comma as expected
9. Refresh the page
10. The decimal number display will turn to a dot 3.25 (You might need several edits and refreshes before you reproduce the issue)
11. Try to change the value to any other number like 7,17

Expected Results: The change to be saved
Actual results: You get the following error: Please enter a valid number

Environment

Clarity 16.3.1, 16.3.2

Cause

This has been investigated through DE171701

Resolution

This is not reproducible in Clarity 16.3.3 after some date formatting logic change.

Additional Information

Once you are on this scenario where the decimal separator displays as a dot instead of a comma, you can not change the field value any longer and if you click inside and outside the cell, the number multiplies by a thousand