Thx for your fast response.
The problem is that I'm writing a transformation that turns an Excel sheet into
xml.
Unfortunately the excel is filled with formulas.
In the output xml of Office 2007 the number is not 298,16 (which stands in the
excel sheet) but its 298.15499999999997.
So I have to find a way to round exactly like Excel does, because the customer
cares about 1 Cent.
regards
. . . . . . . . . . . . . . . . . . . . . . . . . .
Patrick Szabo
XSLT-Entwickler
LexisNexis
Marxergasse 25, 1030 Wien
mailto:patrick(_dot_)szabo(_at_)lexisnexis(_dot_)at
Tel.: +43 (1) 534 52 - 1573
Fax: +43 (1) 534 52 - 146
-----Ursprüngliche Nachricht-----
Von: G. Ken Holman [mailto:gkholman(_at_)CraneSoftwrights(_dot_)com]
Gesendet: Montag, 24. Jänner 2011 15:49
An: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Betreff: Re: [xsl] round-half-to-even problem.
At 2011-01-24 15:39 +0100, Szabo, Patrick \(LNG-VIE\) wrote:
I'm using saxon 9 EE and xslt 2.0.
I want to round but I'm getting weird outputs.
Because you aren't "rounding to the closest digit", you are "rounding
to the closest even parity digit".
My Template looks like this:
<xsl:template match="data">
<absatz>
<xsl:choose>
<xsl:when test="@type='Number' and
string-length(substring-after(., '.')) > 2">
<xsl:value-of
select="round-half-to-even(text(), 2)"/>
</xsl:when>
<xsl:otherwise>
<xsl:apply-templates/>
</xsl:otherwise>
</xsl:choose>
</absatz>
</xsl:template>
Example:
<data type="Number">1351.845</data>
Output:
<absatz>1351.84</absatz>
Right ... because the "5" is half-rounding the "4" to "4". "4" is
the closest even-parity digit to the value "4.5". "6" is the closes
even-parity digit to the value "5.5".
Desired:
<absatz>1351.85</absatz>
Example:
<data type="Number">298.15499999999997</data>
Output:
<absatz>298.16</absatz> <- which is correct or at least what I want.
That surprises me ... I would have expected "298.15" because the next
digit is not simply "5" or above. I'm guessing it has to do with the
binary representation of the number.
Can anybody explain this to why on time it takes the bigger and the next
time the smaller number ?!
Because "round-half-to-even" rounds to an even-parity digit
(0,2,4,6,8) as you request.
Can I control that somehow ?!
If you are rounding for presentation purposes, then use:
format-string(.,'.00')
... which rounds the third digit to the second digit simply, where
"5" goes to the ceiling (a negative number gets smaller, a positive
number gets bigger).
I hope this helps.
. . . . . . . . . Ken
--
Contact us for world-wide XML consulting & instructor-led training
Crane Softwrights Ltd. http://www.CraneSoftwrights.com/s/
G. Ken Holman mailto:gkholman(_at_)CraneSoftwrights(_dot_)com
Legal business disclaimers: http://www.CraneSoftwrights.com/legal
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--