/************************************************************************* * * $RCSfile: numehelp.cxx,v $ * * $Revision: 1.14 $ * * last change: $Author: sab $ $Date: 2001-10-29 16:01:23 $ * * The Contents of this file are made available subject to the terms of * either of the following licenses * * - GNU Lesser General Public License Version 2.1 * - Sun Industry Standards Source License Version 1.1 * * Sun Microsystems Inc., October, 2000 * * GNU Lesser General Public License Version 2.1 * ============================================= * Copyright 2000 by Sun Microsystems, Inc. * 901 San Antonio Road, Palo Alto, CA 94303, USA * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License version 2.1, as published by the Free Software Foundation. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * * * Sun Industry Standards Source License Version 1.1 * ================================================= * The contents of this file are subject to the Sun Industry Standards * Source License Version 1.1 (the "License"); You may not use this file * except in compliance with the License. You may obtain a copy of the * License at http://www.openoffice.org/license.html. * * Software provided under this License is provided on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. * See the License for the specific provisions governing your rights and * obligations concerning the Software. * * The Initial Developer of the Original Code is: Sun Microsystems, Inc. * * Copyright: 2000 by Sun Microsystems, Inc. * * All Rights Reserved. * * Contributor(s): _______________________________________ * * ************************************************************************/ #include "numehelp.hxx" #include "nmspmap.hxx" #include "xmlnmspe.hxx" #include "xmluconv.hxx" #ifndef _XMLOFF_XMLTOKEN_HXX #include "xmltoken.hxx" #endif #ifndef _XMLOFF_XMLEXP_HXX #include "xmlexp.hxx" #endif #ifndef _COM_SUN_STAR_UNO_REFERENCE_H_ #include #endif #ifndef _RTL_USTRING_HXX_ #include #endif #ifndef _TOOLS_INTN_HXX #include #endif #ifndef _ZFORLIST_HXX #include #endif #ifndef _COM_SUN_STAR_UTIL_NUMBERFORMAT_HPP_ #include #endif #ifndef _TOOLS_SOLMATH_HXX #include #endif #ifndef _TOOLS_DEBUG_HXX #include #endif #ifndef _RTL_USTRBUF_HXX_ #include #endif using namespace com::sun::star; using namespace xmloff::token; #define XML_TYPE "Type" #define XML_CURRENCYSYMBOL "CurrencySymbol" #define XML_CURRENCYABBREVIATION "CurrencyAbbreviation" #define XML_STANDARDFORMAT "StandardFormat" XMLNumberFormatAttributesExportHelper::XMLNumberFormatAttributesExportHelper( ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatsSupplier >& xTempNumberFormatsSupplier) : pExport(NULL), xNumberFormatsSupplier(xTempNumberFormatsSupplier), aNumberFormats() { } XMLNumberFormatAttributesExportHelper::~XMLNumberFormatAttributesExportHelper() { } sal_Int16 XMLNumberFormatAttributesExportHelper::GetCellType(const sal_Int32 nNumberFormat, rtl::OUString& sCurrency, sal_Bool& bIsStandard) { XMLNumberFormat aFormat(sEmpty, nNumberFormat, 0); XMLNumberFormatSet::iterator aItr = aNumberFormats.find(aFormat); if (aItr != aNumberFormats.end()) { bIsStandard = aItr->bIsStandard; sCurrency = aItr->sCurrency; return aItr->nType; } else { aFormat.nType = GetCellType(nNumberFormat, bIsStandard, xNumberFormatsSupplier); aFormat.bIsStandard = bIsStandard; if ((aFormat.nType & ~util::NumberFormat::DEFINED) == util::NumberFormat::CURRENCY) if (GetCurrencySymbol(nNumberFormat, aFormat.sCurrency, xNumberFormatsSupplier)) sCurrency = aFormat.sCurrency; aNumberFormats.insert(aFormat); return aFormat.nType; } return 0; } void XMLNumberFormatAttributesExportHelper::SetNumberFormatAttributes( const sal_Int32 nNumberFormat, const double& rValue, sal_uInt16 nNamespace, sal_Bool bExportValue) { if (pExport) { sal_Bool bIsStandard; rtl::OUString sCurrency; sal_Int16 nTypeKey = GetCellType(nNumberFormat, sCurrency, bIsStandard); WriteAttributes(*pExport, nTypeKey, rValue, sCurrency, nNamespace, bExportValue); } else DBG_ERROR("no SvXMLExport given"); } void XMLNumberFormatAttributesExportHelper::SetNumberFormatAttributes( const rtl::OUString& rValue, const rtl::OUString& rCharacters, sal_uInt16 nNamespace, sal_Bool bExportValue, sal_Bool bExportTypeAttribute) { if (pExport) SetNumberFormatAttributes(*pExport, rValue, rCharacters, nNamespace, bExportValue, bExportTypeAttribute); else DBG_ERROR("no SvXMLExport given"); } void XMLNumberFormatAttributesExportHelper::WriteAttributes(SvXMLExport& rXMLExport, const sal_Int16 nTypeKey, const double& rValue, const rtl::OUString& rCurrency, sal_uInt16 nNamespace, sal_Bool bExportValue) { sal_Bool bWasSetTypeAttribute = sal_False; switch(nTypeKey & ~util::NumberFormat::DEFINED) { case 0: case util::NumberFormat::NUMBER: case util::NumberFormat::SCIENTIFIC: case util::NumberFormat::FRACTION: { if (!bWasSetTypeAttribute) { rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_FLOAT); bWasSetTypeAttribute = sal_True; } } // No Break case util::NumberFormat::PERCENT: { if (!bWasSetTypeAttribute) { rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_PERCENTAGE); bWasSetTypeAttribute = sal_True; } } // No Break case util::NumberFormat::CURRENCY: { if (!bWasSetTypeAttribute) { rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_CURRENCY); if (rCurrency.getLength() > 0) rXMLExport.AddAttribute(nNamespace, XML_CURRENCY, rCurrency); bWasSetTypeAttribute = sal_True; } if (bExportValue) { String sValue; SolarMath::DoubleToString(sValue, rValue, 'A', INT_MAX, '.', sal_True); rXMLExport.AddAttribute(nNamespace, XML_VALUE, sValue); } } break; case util::NumberFormat::DATE: case util::NumberFormat::DATETIME: { if (!bWasSetTypeAttribute) { rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_DATE); bWasSetTypeAttribute = sal_True; } if (bExportValue) { if ( rXMLExport.GetMM100UnitConverter().setNullDate(rXMLExport.GetModel()) ) { rtl::OUStringBuffer sBuffer; rXMLExport.GetMM100UnitConverter().convertDateTime(sBuffer, rValue); rXMLExport.AddAttribute(nNamespace, XML_DATE_VALUE, sBuffer.makeStringAndClear()); } } } break; case util::NumberFormat::TIME: { if (!bWasSetTypeAttribute) { rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_TIME); bWasSetTypeAttribute = sal_True; } if (bExportValue) { rtl::OUStringBuffer sBuffer; rXMLExport.GetMM100UnitConverter().convertTime(sBuffer, rValue); rXMLExport.AddAttribute(nNamespace, XML_TIME_VALUE, sBuffer.makeStringAndClear()); } } break; case util::NumberFormat::LOGICAL: { if (!bWasSetTypeAttribute) { rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_BOOLEAN); bWasSetTypeAttribute = sal_True; } if (bExportValue) { rtl::OUString sOUValue; double fTempValue = rValue; if (SolarMath::ApproxEqual( fTempValue, 1.0 )) { rXMLExport.AddAttribute(nNamespace, XML_BOOLEAN_VALUE, XML_TRUE); } else { if (SolarMath::ApproxEqual( rValue, 0.0 )) { rXMLExport.AddAttribute(nNamespace, XML_BOOLEAN_VALUE, XML_FALSE); } else { String sValue; SolarMath::DoubleToString(sValue, fTempValue, 'A', INT_MAX, '.', sal_True); rtl::OUString sOUValue(sValue); rXMLExport.AddAttribute(nNamespace, XML_BOOLEAN_VALUE, sOUValue); } } } } break; case util::NumberFormat::TEXT: { if (!bWasSetTypeAttribute) { rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_FLOAT); bWasSetTypeAttribute = sal_True; if (bExportValue) { String sValue; SolarMath::DoubleToString(sValue, rValue, 'A', INT_MAX, '.', sal_True); rXMLExport.AddAttribute(nNamespace, XML_VALUE, sValue); } } } break; } } sal_Bool XMLNumberFormatAttributesExportHelper::GetCurrencySymbol(const sal_Int32 nNumberFormat, rtl::OUString& sCurrencySymbol, uno::Reference & xNumberFormatsSupplier) { if (xNumberFormatsSupplier.is()) { uno::Reference xNumberFormats = xNumberFormatsSupplier->getNumberFormats(); if (xNumberFormats.is()) { try { uno::Reference xNumberPropertySet = xNumberFormats->getByKey(nNumberFormat); uno::Any aCurrencySymbol = xNumberPropertySet->getPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(XML_CURRENCYSYMBOL))); if ( aCurrencySymbol >>= sCurrencySymbol) { rtl::OUString sCurrencyAbbreviation; uno::Any aCurrencyAbbreviation = xNumberPropertySet->getPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(XML_CURRENCYABBREVIATION))); if ( aCurrencyAbbreviation >>= sCurrencyAbbreviation) { if ( sCurrencyAbbreviation.getLength() != 0 ) sCurrencySymbol = sCurrencyAbbreviation; else { if ( sCurrencySymbol.getLength() == 1 && sCurrencySymbol.toChar() == NfCurrencyEntry::GetEuroSymbol() ) sCurrencySymbol = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("EUR")); } } return sal_True; } } catch ( uno::Exception& ) { DBG_ERROR("Numberformat not found"); } } } return sal_False; } sal_Int16 XMLNumberFormatAttributesExportHelper::GetCellType(const sal_Int32 nNumberFormat, sal_Bool& bIsStandard, uno::Reference & xNumberFormatsSupplier) { if (xNumberFormatsSupplier.is()) { uno::Reference xNumberFormats = xNumberFormatsSupplier->getNumberFormats(); if (xNumberFormats.is()) { try { uno::Reference xNumberPropertySet = xNumberFormats->getByKey(nNumberFormat); uno::Any aIsStandardFormat = xNumberPropertySet->getPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(XML_STANDARDFORMAT))); aIsStandardFormat >>= bIsStandard; uno::Any aNumberType = xNumberPropertySet->getPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(XML_TYPE))); sal_Int16 nNumberType; if ( aNumberType >>= nNumberType ) { return nNumberType; } } catch ( uno::Exception& ) { DBG_ERROR("Numberformat not found"); } } } return 0; } void XMLNumberFormatAttributesExportHelper::SetNumberFormatAttributes(SvXMLExport& rXMLExport, const sal_Int32 nNumberFormat, const double& rValue, sal_uInt16 nNamespace, sal_Bool bExportValue) { sal_Bool bIsStandard; sal_Int16 nTypeKey = GetCellType(nNumberFormat, bIsStandard, rXMLExport.GetNumberFormatsSupplier()); rtl::OUString sCurrency; if ((nTypeKey & ~util::NumberFormat::DEFINED) == util::NumberFormat::CURRENCY) GetCurrencySymbol(nNumberFormat, sCurrency, rXMLExport.GetNumberFormatsSupplier()); WriteAttributes(rXMLExport, nTypeKey, rValue, sCurrency, nNamespace, bExportValue); } void XMLNumberFormatAttributesExportHelper::SetNumberFormatAttributes(SvXMLExport& rXMLExport, const rtl::OUString& rValue, const rtl::OUString& rCharacters, sal_uInt16 nNamespace, sal_Bool bExportValue, sal_Bool bExportTypeAttribute) { if (bExportTypeAttribute) rXMLExport.AddAttribute(nNamespace, XML_VALUE_TYPE, XML_STRING); if (bExportValue && (rValue != rCharacters)) { rtl::OUString sTemp; SvXMLUnitConverter::clearUndefinedChars(sTemp, rValue); if (sTemp.getLength()) rXMLExport.AddAttribute(nNamespace, XML_STRING_VALUE, sTemp); } }