![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries >Thread Prev - Re: format-number and localisation [Thread Next] Re: format-number and localisationTo: NULL Date: 11/8/2006 4:10:00 PM
Simon Caldwell wrote:
> Apparently the VB is using CStr(number) to output the value. This
> seems to pick up the current default locale (in this case Dutch, with
> comma for decimal sep), which is what is usually wanted, apart from
> when the resulting number is to be passed to a stylesheet.
Yes, it picks up the current locale but even VBScript has a function
SetLocale to change that so you can easily do e.g.
Dim Pi, OldLocale
Pi = 3.1415927
' switch to en-US and store current default locale in OldLocale
OldLocale = SetLocale("en-US")
WScript.Echo CStr(Pi)
SetLocale OldLocale
WScript.Echo CStr(Pi)
which here on a German Windows version outputs
3.1415927
3,1415927
which means if you change the VB code to use SetLocale "en-US" before
you create the XML input numbers all should work fine. For all your
other needs you can easily switch back to the default locale as shown above.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
| ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||||
|
