Message-ID: <1537343344.7841.1711623659658.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7840_1936749389.1711623659658" ------=_Part_7840_1936749389.1711623659658 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Creates a format string for displaying currency values, and allows local= e-specific currency symbols.
=20public System.String CreateCurrency(int numDecimalPlaces, boolean useNegat= iveSign, boolean useParensForNegatives, Color negativeColor, System.String = currencySymbol, System.String localeCode, boolean currencyAtFront, boolean = spaceBetween)=20
Public Function CreateCurrency(ByVal numDecimalPlaces As Integer, ByVal use= NegativeSign As Boolean, ByVal useParensForNegatives As Boolean, ByVal nega= tiveColor As Color, ByVal currencySymbol As String, ByVal localeCode As Str= ing, _ =09=09ByVal currencyAtFront As Boolean, ByVal spaceBetween As Boolean) As S= tring=20
true
, the negative sign will be used for negative values.=20
true
, negative numbers will be shown in parentheses.=20
negativeColor
may be null.=20
//--- Create a style. Style styl =3D wb.CreateStyle(); //--- The following assigns the currency string "[$=E2=82=AC= -2] #,##0.00;[Red][$=E2=82=AC-2] #,##0.00" //--- to the style, which will use the Euro symbol prior to the v= alues, with the //--- color red for negative values. styl.NumberFormat =3D wb.NumberFormat.CreateCurrency(2, false, false, NumberFormat.Color.Red, "=E2=82=AC", "2", true, true);=20
'--- Create a style. Dim styl As Style =3D wb.CreateStyle() '--- The following assigns the currency string "[$=E2=82=AC-= 2] #,##0.00;[Red][$=E2=82=AC-2] #,##0.00" '--- to the style, which will use the Euro symbol prior to the va= lues, with the '--- color red for negative values. styl.NumberFormat =3D wb.NumberFormat.CreateCurrency(2, _ False, _ False, _ NumberFormat.Color.Red, _ "=E2=82=AC", _ "2", _ True, _ True)=20