I am trying to use the XSL command format-number() with the NotesXMLTransformer in 6.5.4 and it does not work. Does anyone know a workaround for this?
Thank you,
Jeffrey Winkler
Subject: xsl:format-number
Exactly how are you using it?
Subject: RE: xsl:format-number
I have a web agent that queries the database and the result is passed to a NotesStream and that is then passed to the XSLTransfomer with the stylesheet as another NotesStream.
In my XSL I have the following line:
<xsl:value-of select=“format-number(number(OrderTotal),‘#,#00.00’)”/>
I used Xselerator to test the code and I know the xsl code works, Domino just wont format the text.
Jeff
Subject: RE: xsl:format-number
Are you sure the value you’re converting actually adheres to the requirements for conversion? That is, are you sure it’s number-format that’s failing and not number()?
Subject: RE: xsl:format-number
I have tried it with and without the number() function and I get the same results. It does not format the number.
Have you been able to get this to work?
Jeff
Subject: RE: xsl:format-number
If the result is the same with and without number(), then I’d suspect that number() isn’t doing anything and the original value is being passed through unconverted. What does the source element for OrderTotal look like?
Subject: RE: xsl:format-number
The source element looks like 123456.43 and sometimes 12343.3 or 12345 and I would like it to look like:123,456.43
12,343.30
12,345.00
Subject: RE: xsl:format-number
Not just the data, I mean the element, including any attributes, etc. A direct paste would be best.
Subject: RE: xsl:format-number
9114.92
Subject: RE: xsl:format-number
Crap. I was hoping to see something off in there. A bad character, some whitespace where it wasn’t supposed to be. I’m done, sorry – unless the machine this is running on has convinced itself that the decimal point should be a comma rather than a dot (which is unlikely).
Subject: RE: xsl:format-number
Thanks for your help.