format output properties change decimal/thousands separator

Hi,

I want to define the output format properties (e.g. oxf.xforms.format.output.double) so that the decimal separator is "," and the thousands separator is ".".
How can I achive this?

Martin

My "hacky" solution is to use the translate function.

<property as="xs:string"  name="oxf.xforms.format.output.double">
    if (. castable as xs:double) then translate(format-number(xs:double(.),'#,##0.000'),',.','.,') else .
</property>

Why don't you use the format-number function directly to do the correct formatting?

What you are doing now is converting a number in one format to another.

I want to use the format-number function directly, but I didn't get it working. I tried following: format-number(xs:double(.),'#,##0.000')

Is there somewhere a documentation about the formatting pattern.

Sorry, I had a mistake in my previous post. I tried this function call: format-number(xs:double(.),'#.##0,000')

My bad, you can not use the format-number for this.
The meaning of '.' and ',' are hardcoded: http://www.w3schools.com/xsl/func_formatnumber.asp

I believe the only way to get around this is as you showed in your original post.

Ok, thank you for the documentation link. I don't get the point that it is a standard xslt function.

Martin

Martin,

This means that the `format-number()` function is defined by the XSLT spec:

    https://www.w3.org/TR/xslt20/#function-format-number

It is also part of XPath 3:

    https://www.w3.org/TR/xpath-functions-30/#func-format-number

But it doesn't matter because we also support it from XForms in Orbeon Forms.

-Erik