Search view : Commas in float field = error (even if it is the separator of the language)

[Francois Degrave]

Hi!

Using fr_BE as language, I get an error whenever I use a comma (,) in a float field of a search view -- for example, the 'total' field on the invoice view.

It should be dependent on the language specificity or, at least, both dots and commas should work.

Cheers!

François

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Francois Degrave,

I have checked your issue with latest trunk and it's work as expected. Would you please provide us more information like version of OE, which error you did faced with the related steps. Would you please check the attached video and informed us where you faced the problem.

Thanks.

[Francois Degrave (fde-be)]

In your video you don't use fr_BE as a language, neither another language using commas as *decimal separator*.

[Amit Parik (amit-parik)]

Hello Francois,

Thanks or your reply.

I have faced the same problem when I am using a fr_BE language and set a decimal separator (,). I am not able to search with total filed of the invoice on advance search.

[Nicolas Vanhoren (OpenERP) (niv-openerp)]

Hello François.

The problem is due to a wrong configuration. When you install fr_BE, the decimal separator is not setted to the country's standard, it is configured as the english convention. In the english convention, the comma can be used is used as a thousand separator. For example we will write "15,423.85". The behavior of the web client is simply to ignore the thousand separator. So the behavior of the web client is completely normal according to its configuration. I also tested by customizing the thousand and decimal separators and that worked fine.

We could consider this incorrect default configuration as a openobject-server issue. I asked to odo and he said it is known since a long time and that he has no desire to try to solve it. Your best option is to manually configure the your language, which should not be very difficult.

[Francois Degrave (fde-be)]

No, you are wrong. My decimal separator is well configured, and yet there is an error during the search. I know I'm dumb but I'm not THAT stupid ;-)

Note that this error is only on client side! I get the error (in french of course, since it occurs only in french) "Recherche non valide déclenché depuis la vue de recherche"

[Nicolas Vanhoren (OpenERP) (niv-openerp)]

Did you removed/replaced the thousands separator ? If you didn't it won't work.