format-number format string incompatability

[Richard Haber]

I am using format-number(-1234.56,'#,##0. 00;(#,##0.00)') in a stylesheet
that works in every xsl processor (including MSXML2) except for the one in
..NET 1.1. I am expecting to see (1,234.56) as the result of this function,
but am getting an ArgumentExcepti on : NumberGroupSize s error with the
message "Parameter name: Every element in the value array should be between
one and nine, except for the last, which can be zero"

If I use just '(#,##0.00)' as the format, it gives me the expected result
(for both positive and negatives numbers) so it seems to be the second part
of the format after the ';'

Can anyone shed any light on this or suggest a viable workaround.

Thanks for the time

[Derek Harmon]

"Richard Haber" <ri***********@ hotmail.com> wrote in message news:OQ******** ******@TK2MSFTN GP12.phx.gbl...

I am using format-number(-1234.56,'#,##0. 00;(#,##0.00)') in a stylesheet
that works in every xsl processor (including MSXML2) except for the one in
.NET 1.1. I am expecting to see (1,234.56) as the result of this function,
but am getting an ArgumentExcepti on : NumberGroupSize s error with the
message "Parameter name: Every element in the value array should be between
one and nine, except for the last, which can be zero" : : Can anyone shed any light on this or suggest a viable workaround.

- - - workaround.xsl (excerpt)
<!-- . . . -->
<xsl:template name="formatNum ber">
<xsl:param name="num" />
<xsl:choose>
<xsl:when test="number($n um) &lt; 0">
<xsl:value-of select="format-number( number($num), '(#,##0.00)')" />
</xsl:when>
<xsl:when test="number($n um) &gt;= 0">
<xsl:value-of select="format-number( number($num), '#,##0.00')" />
</xsl:when>
</xsl:choose>
</xsl:template>
<!-- . . . -->
<xsl:call-template name="formatNum ber">
<xsl:with-param name="num" select="-1234.56" />
</xsl:call-template>
<!-- . . . -->
- - -
Derek Harmon

[Richard Haber]

Thanks for the quick response. This is a viable workaround.

Still left wondering why the .NET XSL classes seem to have been 'dumbed
down' from the rest of the XSLT Processors. Other Microsoft products have
extensive support for number formatting, e.g., Excel, so this can't be
unknown territory for them

"Derek Harmon" <lo*******@msn. com> wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

"Richard Haber" <ri***********@ hotmail.com> wrote in message news:OQ******** ******@TK2MSFTN GP12.phx.gbl...

I am using format-number(-1234.56,'#,##0. 00;(#,##0.00)') in a stylesheet
that works in every xsl processor (including MSXML2) except for the one in .NET 1.1. I am expecting to see (1,234.56) as the result of this function, but am getting an ArgumentExcepti on : NumberGroupSize s error with the
message "Parameter name: Every element in the value array should be between one and nine, except for the last, which can be zero"

: :

Can anyone shed any light on this or suggest a viable workaround.

- - - workaround.xsl (excerpt)
<!-- . . . -->
<xsl:template name="formatNum ber">
<xsl:param name="num" />
<xsl:choose>
<xsl:when test="number($n um) &lt; 0">
<xsl:value-of select="format-number( number($num),

'(#,##0.00)')" /> </xsl:when>
<xsl:when test="number($n um) &gt;= 0">
<xsl:value-of select="format-number( number($num), '#,##0.00')" /> </xsl:when>
</xsl:choose>
</xsl:template>
<!-- . . . -->
<xsl:call-template name="formatNum ber">
<xsl:with-param name="num" select="-1234.56" />
</xsl:call-template>
<!-- . . . -->
- - -
Derek Harmon