Problem with decimal separator

[Paulo Gafanha]

Hi,

I 'm having a problem with a field with type Number(double). I have it with
2 decimal places and my regional settings set that decimal separator is ','
but when i save the xml the number is with '.' as the separator.

I've already tried to use the '.' as thousands separator thinkinh that it
would assume ',' as decimal separator, but nothing.

Am i missing some configuration?

 

[Gavin McKay]

Hi,

I could be wrong, but I thought that the regional settings only control the
display, not the actual storage of the number. So even though it looks like
a comma is being used, under the hood the decimal point is used.

I don't have huge experience in Regionalization (sp?) though sorry, more
experienced heads might provide their input...

Gavin.

 

[Paulo Gafanha]

More details on the environment

I´m using Forms Server and i need the infopath form to save the value in XML
as number with the format 1,83 and not 1.83

I populate the fields from a Sql Server database where the values are like
1,83.

In MOSS i haven't been able to find any kind of misconfiguration...

This is really problematic to me.

Appreciate any help.

 

[Gavin McKay]

Hi Paulo,

I know this seems a nasty work-around (and it is but can you convert the
Xml again prior to using it? Since you are putting the Xml from InfoPath
somewhere, can you then format it to use commas instead of decimal points?
That way you can completely control the final output before putting it to
further use.

How are you submitting your form? Directly to a web service or somewhere
else?

Gavin.

 

[Paulo Gafanha]

I'm submitting the form to a sharepoint form library.

It is then used by an application to integrate with an ERP.

I really think infopath has to put the value in the right way.

Thanks for your help.

 

[Paulo Gafanha]

Hi,

I've solved the problem outside infopath, before sending data from xml to
the enterprise application.

Thanks.