String sCurrencySymbol = ((String) xFormat.getPropertyValue("CurrencySymbol")).toString();
// change the numberformat only on cellranges with a currency numberformat
if( ( (fType & com.sun.star.util.NumberFormat.CURRENCY) > 0) &&
( sCurrencySymbol.compareTo( sOldSymbol ) == 0 ) ) {
AnyConverter aAnyConv = new AnyConverter();
boolean bThousandSep = aAnyConv.toBoolean(
xFormat.getPropertyValue("ThousandsSeparator"));
boolean bNegativeRed = aAnyConv.toBoolean(xFormat.getPropertyValue("NegativeRed"));
short fDecimals = aAnyConv.toShort(xFormat.getPropertyValue("Decimals"));
short fLeadingZeros = aAnyConv.toShort(xFormat.getPropertyValue("LeadingZeros"));
Locale oLocale = (Locale) aAnyConv.toObject(
new com.sun.star.uno.Type(Locale.class),xFormat.getPropertyValue("Locale"));
// create a new numberformat string
String sNew = xNumberFormats.generateFormat( iSimpleKey, oLocale, bThousandSep, bNegativeRed, fDecimals, fLeadingZeros );
// get the NumberKey from the numberformat