Not possible to input for floating field widget with comma and dot

[sraps (Alistek)]

It would be better if it would be option to input digits with any decimal separator symbol (comma and dot). And client application would convert it automatically to the internal type.

[Numérigraphe (numerigraphe)]

What if your local format contains both comma and dot (ie. 1,000.00)?
Lionel

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello Sraps,

This stuff cannot be acceptable generically.

If your purpose is to do so, you may opt for char field.

As far as the floating widget is concerned,it will behave according to locale.

You can create a blueprint for this.

Thanks.

[sraps (Alistek) (erpsraps)]

>>What if your local format contains both comma and dot (ie. 1,000.00)?

Not quite so, normally nobody inputs thousand separator. It is common when inputting floats not to input decimal separator at all, just for speedy input. Decimal separator would be placed just before last two digits (according to price accuracy). This is normal on many production accounting systems. And lot of user interfaces, both software or hardware.

So this should not be trated as something weird, this is normal behavior. Not having such or similar option (I accent - option, which could be turned on or off) for a decent accounting package, is to be considered as a lack of maturity.

[Numérigraphe (numerigraphe)]

I support this idea - it sure would please users here. I think it should be set to "confirmed / wishlist".
Lionel.

[Bruno JOLIVEAU - www.savoirfairelinux.com (zeekom)]

Hello
+1
I agree it would be "user friendly".

Thanks

[Borja López Soilán (NeoPolus) (borjals)]

+1

Jay, as reported on bug 576997 the current GTK client the behavior is not consistent along the interface:

  - For editable lists (one2many widgets), like the Invoice Lines in the Supplier Invoices, both "2.5" and "2,5" can be used (using Spanish locale settings). They actually work as sraps commented!

  - For float widgets, like the Total field of Supplier Invoices, only "2.5" can be used (using Spanish locale settings).

That means, that at least for Spanish users (1.000,00 numeric format) they only can use the numeric keyboard decimal separator (writes ",") on the (one2many) lists, but not on the float fields!

[Wyden Silvan (brain-tec) (brain-tec)]

+1

That would be very useful.

Thanks.

[Amit Mendapara (cristatus)]

This feature is already there in web client but depends on your language settings (user preferences).

[os33 (olivier-sommier)]

Hello,

@ Amit
I tested again with my workflow and I confirm this feature is NOT there in web client (at least for my needs).
I use 2 computers : PC and MAC. The settings are French on both computers. Note that the numeric keypad of MAC returns a COMA as decimal separator whereas the PC returns a DOT.

My need is to enter the time spend on task (Task/work done).

If I use the PC I can use the numeric keypad to enter 1.5 (convert to 1:30)

If I use the MAC I can't use the numeric keypad because 1,5 is not converted into 1:30 but 0:00

Hope it helps

Thanks

[Ferdinand (office-chricar)]

FYI: Koo accepts comma and dot as decimal separator :-)

[Albert Cervera i Areny - http://www.NaN-tic.com (albert-nan)]

Just in case this is useful for other client developers. Current bazaar version of Koo accepts both dot and comma as decimal separators as Ferdinand said, but it also shows thousand separators once the widget looses focus. So users will see:

When form is shown: 12.345,40
When user enters the field: 12345.40
Then she can write the new number: 23450.77 (or 23450,77)
When she leaves the field: 23.450,77

This works, of course, in forms and lists. Trees (which are not editable) and totals in lists use thousand separators too.