Wrong price when using comma as decimal

[jjkoa]

Bug

Using Spanish locale (decimal separator is a comma), when adding a product to an order, if the price has 3 decimals, it removes the decimal.

Dolibarr Version

18.0.4

Environment PHP

7.2

Environment Database

MariaDB 11.3.2

Steps to reproduce the behavior and expected behavior

It should just replace the point with a comma in the unit price.

Test with spanish locale, with a 3 decimals product.

Examples:

• Add a free product, in unit price use: 0.225 -> It changes it to 225.00.
• Add an existing product, with a unit price of 0.225 -> This example works fine, value is set to 0,225
• Edit an existing product, with a unit price of 0.225 -> it changes the value to 225.00.

Attached files

No response

[ksar-ksar]

Hello,

if Spanish locale, decimal separator is a comma, why do you enter point and not Comma.
If you do the same on Excel for example, it will treat it as String and not number.

[jjkoa]

Hi. Excel does treat it as numeric and convert the point to a comma. The numeric keypad has a point, so it would be very annoying to use the numeric keypad and having to type a comma for every decimal.

This was how older versions of dolibarr worked. I have just test it in a dolibarr 5.0.6, and it works fine, it converts the 0.225 to 0,225.

I've seen this issue that is kind of similar: #22535 which seems to fix one of the examples, but It does not work with the other ones.

[ksar-ksar]

And what is your local setting thousands char ?

[jjkoa]

a point: '.' same settings as in the mentioned issue.

[ksar-ksar]

So you understand why if you put a . Dolibarr think that's thousand

[jjkoa]

I don't, it does not make any practical sense, no localized software would behave like that, and it was working fine in previous versions. But as you please, I close.