Issue

When using input controls with formatting the underlying value was displayed when editing the controls value with no formatting applied. When editing a percentage formatted control the value was expected to be the underlying value instead of a percentage value.

Changes Applied

The editable value has been changed to apply the thousand separator, currency, scientific and percentage symbols.  The accuracy is still kept and no formatting logic is done on the decimal part of the value.

Percentage has changed so that any typed value is recognised as a percentage regardless of the % sign.  Transferred values to a percentage control behave the same as they used to, except if you transfer a % value eg 90% the percentage sign is now acknowledged (underlying value recognised as 0.9 not 90)

Behavior Changes Implication

Display value - The controls value after formatting rules have been applied. This is value displayed when the control is not being edited.

Editable value - The value that displays when editing the controls value.

Underlying value - The actual value of the control. This is the value the control will return when querying the controls value.

DescriptionTypeDisplay Value
Editable ValueUnderlying Value (Transfer Out)
Number format with thousand separator and 0 decimal places 12345 12,345

Previous 12345

Now 12,345

 12345
2 decimal places 12345.678 12,345.68

Previous 12345.678

Now 12,345.678

 12345.678
Currency format with thousand separator and 0 decimal places 12345 $12,345

Previous 12345

Now $12,345

 12345
2 decimal places 12345.678 12,345.68

Previous 12345.678

Now $12,345.678

 12345.678
Scientific format and 0 decimal places 1.23E4 1.23E4

Previous 12300

Now 1.23E4

 12300
12300 1.23E4

Previous 12300

Now 12300

 12300
Percentage format with thousand separator and 0 decimal places 12345

Previous 1,234,500 %

Now 12,345 %

Previous 12345

Now 12,345 %

Previous 12345

Now 123.45

12345%

Previous 123.45 %

Now 12,345 %

Previous 123.45

Now 12,345 %

123.45
2 decimal places 12345

Previous 1,234,500.00 %

Now 12,345.00 %

Previous 12345

Now 12,345 %

Previous 12345

Now 123.45

12345%

Previous 123.45 %

Now 12,345.00 %

Previous 123.45

Now 12,345 %

123.45

The red formatting now applies and is removed correctly for negative numbers in lists and controls

Image

Image