On an editable grid we have a numeric field, set to Decimal, precision 2, maximum 12 characters, auto-complete with zeros is on.
If the user enters “0.466” it should either round it to 0.47 (great) or truncate it to 0.46 (OK). What it actually gives us is 4.66 (completely wrong). No way would any user want this to happen.
Are we the only ones seeing this behaviour?
Change the field type to text, leaving the SQL as decimal to 2 digits accuracy, and it will do exactly what you want. It will even round up and down depending on the values truncated.
You can then restrict the input to numbers and the decimal dot only.
You’re right @charlesfairbairn. That workaround is great for me and solves my problem.
I still think it’s a bug that a user can accidentally enter 3 decimal places instead of 2 and it causes the number to multiply by 10!
But now I can continue my development. Much appreciated.
