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 ArgumentException : NumberGroupSizes 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

"Richard Haber" <richard_haber (AT) hotmail (DOT) com> wrote

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


Derek Harmon

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" <loresayer (AT) msn (DOT) com> wrote