Re: [xsl] Working with Scientific Notation

[Jeni Tennison <jeni at jenitennison dot com>]

Hi Michael,

> I was wondering if anyone knows of a good way to convert very small
> numbers represented in scientific notation to a standard decimal.
>
> The situation is this: I converted a spreadsheet from MS Excel 2002
> into an MS XML Spreadsheet (more on that later). I have an xsl file
> that can convert the spreadsheet into a
> more-attractive-than-the-MS-html-output html file. (And in total,
> there are too many files to do things worksheets that need to be
> converted to do this by hand). Many of the values that are formatted
> as percents in excel show up in scientifc notation (eg
> -9.1053999999999996E-2) in the xml output. When I try to format them
> with format-number(), they show up as NaN. (This is the MSXML
> DOMDocument 3.0, by the way). Now I think I've read that JDK 1.2
> processors don't bite on this, but the MSXML does. This is a real
> pain, because the decimals really need to be rounded by
> format-number() for the output to look decent.

The pure-XSLT options you've been given would probably be best, but if
it be feasible for you to upgrade to MSXML4, you could use the
extension function:

  ms:number()

to convert the string into an XPath number.

Cheers,

Jeni

---
Jeni Tennison
http://www.jenitennison.com/


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list