Doubt about format in number fields

[pentamsi]

I have a issue with the format number of the fields.

For example y want to put the group separator every 3 number, as usual, but when i edit i don't want to put the separator, and after for example want to delimitate the amount of number to 5. But when I try to put this configuration


and use in the form I have the problem when i put all the number in the field, count the separators as character and don't display all the number:

When editing the number


When not editing


Any one know any solution or this is a bug?

[david]

Set the display format to at least "##,###". Need a format character for every possible position.

Side note: going beyond formatters there are UI converters which allow you to do some pretty funky things with display vs storage. Entering fractions and storing as decimal for example: https://www.servoyforge.net/projects/fractions

[pentamsi]

No, it doesn't work changin the display format, still see 4 number and 1 delimeter.

[david]

I don't think you are having a formatting issue as this does work. How many digits in front of the fractional component does your backend numeric type allow for?

[pentamsi]

The delimiter is for the number separator, not decimal separator.

[david]

What is the backend storage type of the column?

[pentamsi]

It's a NUMBER type in the dbi

[david]

The dbi file only lists the most generic column type information. For example, a MySQL decimal(4,2) type is a number field to Servoy but it will only store two digits to the right and left of the decimal point.