diff options
Diffstat (limited to 'oox/source/xls/externallinkfragment.cxx')
-rw-r--r-- | oox/source/xls/externallinkfragment.cxx | 551 |
1 files changed, 551 insertions, 0 deletions
diff --git a/oox/source/xls/externallinkfragment.cxx b/oox/source/xls/externallinkfragment.cxx new file mode 100644 index 000000000000..e1bff95ff724 --- /dev/null +++ b/oox/source/xls/externallinkfragment.cxx @@ -0,0 +1,551 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org 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 version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +#include "oox/xls/externallinkfragment.hxx" +#include <com/sun/star/sheet/XExternalSheetCache.hpp> +#include "oox/helper/attributelist.hxx" +#include "oox/xls/biffinputstream.hxx" +#include "oox/xls/defnamesbuffer.hxx" +#include "oox/xls/sheetdatacontext.hxx" +#include "oox/xls/unitconverter.hxx" + +using ::rtl::OUString; +using ::com::sun::star::uno::Any; +using ::com::sun::star::uno::Reference; +using ::com::sun::star::uno::Exception; +using ::com::sun::star::table::CellAddress; +using ::com::sun::star::sheet::XExternalSheetCache; +using ::oox::core::ContextHandlerRef; +using ::oox::core::RecordInfo; +using ::oox::core::Relation; + +namespace oox { +namespace xls { + +// ============================================================================ + +OoxExternalSheetDataContext::OoxExternalSheetDataContext( + OoxWorkbookFragmentBase& rFragment, const Reference< XExternalSheetCache >& rxSheetCache ) : + OoxWorkbookContextBase( rFragment ), + mxSheetCache( rxSheetCache ) +{ + OSL_ENSURE( mxSheetCache.is(), "OoxExternalSheetDataContext::OoxExternalSheetDataContext - missing sheet cache" ); +} + +// oox.core.ContextHandler2Helper interface ----------------------------------- + +ContextHandlerRef OoxExternalSheetDataContext::onCreateContext( sal_Int32 nElement, const AttributeList& rAttribs ) +{ + switch( getCurrentElement() ) + { + case XLS_TOKEN( sheetData ): + if( nElement == XLS_TOKEN( row ) ) return this; + break; + case XLS_TOKEN( row ): + if( nElement == XLS_TOKEN( cell ) ) { importCell( rAttribs ); return this; } + break; + case XLS_TOKEN( cell ): + if( nElement == XLS_TOKEN( v ) ) return this; // collect characters in onEndElement() + break; + } + return 0; +} + +void OoxExternalSheetDataContext::onEndElement( const OUString& rChars ) +{ + switch( getCurrentElement() ) + { + case XLS_TOKEN( v ): + switch( mnCurrType ) + { + case XML_b: + case XML_n: + setCellValue( Any( rChars.toDouble() ) ); + break; + case XML_e: + setCellValue( Any( BiffHelper::calcDoubleFromError( getUnitConverter().calcBiffErrorCode( rChars ) ) ) ); + break; + case XML_str: + setCellValue( Any( rChars ) ); + break; + } + mnCurrType = XML_TOKEN_INVALID; + break; + } +} + +ContextHandlerRef OoxExternalSheetDataContext::onCreateRecordContext( sal_Int32 nRecId, RecordInputStream& rStrm ) +{ + switch( getCurrentElement() ) + { + case OOBIN_ID_EXTSHEETDATA: + if( nRecId == OOBIN_ID_EXTROW ) { maCurrPos.Row = rStrm.readInt32(); return this; } + break; + case OOBIN_ID_EXTROW: + switch( nRecId ) + { + case OOBIN_ID_EXTCELL_BLANK: importExtCellBlank( rStrm ); break; + case OOBIN_ID_EXTCELL_BOOL: importExtCellBool( rStrm ); break; + case OOBIN_ID_EXTCELL_DOUBLE: importExtCellDouble( rStrm ); break; + case OOBIN_ID_EXTCELL_ERROR: importExtCellError( rStrm ); break; + case OOBIN_ID_EXTCELL_STRING: importExtCellString( rStrm ); break; + } + break; + } + return 0; +} + +// private -------------------------------------------------------------------- + +void OoxExternalSheetDataContext::importCell( const AttributeList& rAttribs ) +{ + if( getAddressConverter().convertToCellAddress( maCurrPos, rAttribs.getString( XML_r, OUString() ), 0, false ) ) + mnCurrType = rAttribs.getToken( XML_t, XML_n ); + else + mnCurrType = XML_TOKEN_INVALID; +} + +void OoxExternalSheetDataContext::importExtCellBlank( RecordInputStream& rStrm ) +{ + maCurrPos.Column = rStrm.readInt32(); + setCellValue( Any( OUString() ) ); +} + +void OoxExternalSheetDataContext::importExtCellBool( RecordInputStream& rStrm ) +{ + maCurrPos.Column = rStrm.readInt32(); + double fValue = (rStrm.readuInt8() == 0) ? 0.0 : 1.0; + setCellValue( Any( fValue ) ); +} + +void OoxExternalSheetDataContext::importExtCellDouble( RecordInputStream& rStrm ) +{ + maCurrPos.Column = rStrm.readInt32(); + setCellValue( Any( rStrm.readDouble() ) ); +} + +void OoxExternalSheetDataContext::importExtCellError( RecordInputStream& rStrm ) +{ + maCurrPos.Column = rStrm.readInt32(); + setCellValue( Any( BiffHelper::calcDoubleFromError( rStrm.readuInt8() ) ) ); +} + +void OoxExternalSheetDataContext::importExtCellString( RecordInputStream& rStrm ) +{ + maCurrPos.Column = rStrm.readInt32(); + setCellValue( Any( rStrm.readString() ) ); +} + +void OoxExternalSheetDataContext::setCellValue( const Any& rValue ) +{ + if( mxSheetCache.is() && getAddressConverter().checkCellAddress( maCurrPos, false ) ) try + { + mxSheetCache->setCellValue( maCurrPos.Column, maCurrPos.Row, rValue ); + } + catch( Exception& ) + { + } +} + +// ============================================================================ + +OoxExternalLinkFragment::OoxExternalLinkFragment( const WorkbookHelper& rHelper, + const OUString& rFragmentPath, ExternalLink& rExtLink ) : + OoxWorkbookFragmentBase( rHelper, rFragmentPath ), + mrExtLink( rExtLink ), + mnResultType( XML_TOKEN_INVALID ) +{ +} + +// oox.core.ContextHandler2Helper interface ----------------------------------- + +ContextHandlerRef OoxExternalLinkFragment::onCreateContext( sal_Int32 nElement, const AttributeList& rAttribs ) +{ + switch( getCurrentElement() ) + { + case XML_ROOT_CONTEXT: + if( nElement == XLS_TOKEN( externalLink ) ) return this; + break; + + case XLS_TOKEN( externalLink ): + switch( nElement ) + { + case XLS_TOKEN( externalBook ): mrExtLink.importExternalBook( getRelations(), rAttribs ); return this; + case XLS_TOKEN( ddeLink ): mrExtLink.importDdeLink( rAttribs ); return this; + case XLS_TOKEN( oleLink ): mrExtLink.importOleLink( getRelations(), rAttribs ); return this; + } + break; + + case XLS_TOKEN( externalBook ): + switch( nElement ) + { + case XLS_TOKEN( sheetNames ): + case XLS_TOKEN( definedNames ): + case XLS_TOKEN( sheetDataSet ): return this; + } + break; + + case XLS_TOKEN( sheetNames ): + if( nElement == XLS_TOKEN( sheetName ) ) mrExtLink.importSheetName( rAttribs ); + break; + case XLS_TOKEN( definedNames ): + if( nElement == XLS_TOKEN( definedName ) ) mrExtLink.importDefinedName( rAttribs ); + break; + case XLS_TOKEN( sheetDataSet ): + if( (nElement == XLS_TOKEN( sheetData )) && (mrExtLink.getLinkType() == LINKTYPE_EXTERNAL) ) + return createSheetDataContext( rAttribs.getInteger( XML_sheetId, -1 ) ); + break; + + case XLS_TOKEN( ddeLink ): + if( nElement == XLS_TOKEN( ddeItems ) ) return this; + break; + case XLS_TOKEN( ddeItems ): + if( nElement == XLS_TOKEN( ddeItem ) ) + { + mxExtName = mrExtLink.importDdeItem( rAttribs ); + return this; + } + break; + case XLS_TOKEN( ddeItem ): + if( nElement == XLS_TOKEN( values ) ) + { + if( mxExtName.get() ) mxExtName->importValues( rAttribs ); + return this; + } + break; + case XLS_TOKEN( values ): + if( nElement == XLS_TOKEN( value ) ) + { + mnResultType = rAttribs.getToken( XML_t, XML_n ); + return this; + } + break; + case XLS_TOKEN( value ): + if( nElement == XLS_TOKEN( val ) ) return this; // collect value in onEndElement() + break; + + case XLS_TOKEN( oleLink ): + if( nElement == XLS_TOKEN( oleItems ) ) return this; + break; + case XLS_TOKEN( oleItems ): + if( nElement == XLS_TOKEN( oleItem ) ) mxExtName = mrExtLink.importOleItem( rAttribs ); + break; + } + return 0; +} + +void OoxExternalLinkFragment::onEndElement( const OUString& rChars ) +{ + switch( getCurrentElement() ) + { + case XLS_TOKEN( val ): + maResultValue = rChars; + break; + case XLS_TOKEN( value ): + if( mxExtName.get() ) switch( mnResultType ) + { + case XML_b: + mxExtName->appendResultValue( maResultValue.toDouble() ); + break; + case XML_e: + mxExtName->appendResultValue( BiffHelper::calcDoubleFromError( getUnitConverter().calcBiffErrorCode( maResultValue ) ) ); + break; + case XML_n: + mxExtName->appendResultValue( maResultValue.toDouble() ); + break; + case XML_str: + mxExtName->appendResultValue( maResultValue ); + break; + default: + mxExtName->appendResultValue( BiffHelper::calcDoubleFromError( BIFF_ERR_NA ) ); + } + break; + } +} + +ContextHandlerRef OoxExternalLinkFragment::onCreateRecordContext( sal_Int32 nRecId, RecordInputStream& rStrm ) +{ + switch( getCurrentElement() ) + { + case XML_ROOT_CONTEXT: + if( nRecId == OOBIN_ID_EXTERNALBOOK ) + { + mrExtLink.importExternalBook( getRelations(), rStrm ); + return this; + } + break; + + case OOBIN_ID_EXTERNALBOOK: + switch( nRecId ) + { + case OOBIN_ID_EXTSHEETDATA: + if( mrExtLink.getLinkType() == LINKTYPE_EXTERNAL ) + return createSheetDataContext( rStrm.readInt32() ); + break; + + case OOBIN_ID_EXTSHEETNAMES: mrExtLink.importExtSheetNames( rStrm ); break; + case OOBIN_ID_EXTERNALNAME: mxExtName = mrExtLink.importExternalName( rStrm ); return this; + } + break; + + case OOBIN_ID_EXTERNALNAME: + switch( nRecId ) + { + case OOBIN_ID_EXTERNALNAMEFLAGS: if( mxExtName.get() ) mxExtName->importExternalNameFlags( rStrm ); break; + case OOBIN_ID_DDEITEMVALUES: if( mxExtName.get() ) mxExtName->importDdeItemValues( rStrm ); return this; + } + break; + + case OOBIN_ID_DDEITEMVALUES: + switch( nRecId ) + { + case OOBIN_ID_DDEITEM_BOOL: if( mxExtName.get() ) mxExtName->importDdeItemBool( rStrm ); break; + case OOBIN_ID_DDEITEM_DOUBLE: if( mxExtName.get() ) mxExtName->importDdeItemDouble( rStrm ); break; + case OOBIN_ID_DDEITEM_ERROR: if( mxExtName.get() ) mxExtName->importDdeItemError( rStrm ); break; + case OOBIN_ID_DDEITEM_STRING: if( mxExtName.get() ) mxExtName->importDdeItemString( rStrm ); break; + } + break; + } + return 0; +} + +ContextHandlerRef OoxExternalLinkFragment::createSheetDataContext( sal_Int32 nSheetId ) +{ + return new OoxExternalSheetDataContext( *this, mrExtLink.getSheetCache( nSheetId ) ); +} + +// oox.core.FragmentHandler2 interface ---------------------------------------- + +const RecordInfo* OoxExternalLinkFragment::getRecordInfos() const +{ + static const RecordInfo spRecInfos[] = + { + { OOBIN_ID_DDEITEMVALUES, OOBIN_ID_DDEITEMVALUES + 1 }, + { OOBIN_ID_EXTERNALBOOK, OOBIN_ID_EXTERNALBOOK + 228 }, + { OOBIN_ID_EXTERNALNAME, OOBIN_ID_EXTERNALNAME + 10 }, + { OOBIN_ID_EXTROW, -1 }, + { OOBIN_ID_EXTSHEETDATA, OOBIN_ID_EXTSHEETDATA + 1 }, + { -1, -1 } + }; + return spRecInfos; +} + +// ============================================================================ + +BiffExternalLinkFragment::BiffExternalLinkFragment( const BiffWorkbookFragmentBase& rParent, bool bImportDefNames ) : + BiffWorkbookFragmentBase( rParent ), + mbImportDefNames( bImportDefNames ) +{ +} + +BiffExternalLinkFragment::~BiffExternalLinkFragment() +{ +} + +bool BiffExternalLinkFragment::importFragment() +{ + // process all record in this sheet fragment + while( mrStrm.startNextRecord() && (mrStrm.getRecId() != BIFF_ID_EOF) ) + { + if( isBofRecord() ) + skipFragment(); // skip unknown embedded fragments + else + importRecord(); + } + return !mrStrm.isEof() && (mrStrm.getRecId() == BIFF_ID_EOF); +} + +void BiffExternalLinkFragment::importRecord() +{ + sal_uInt16 nRecId = mrStrm.getRecId(); + switch( getBiff() ) + { + case BIFF2: switch( nRecId ) + { + case BIFF2_ID_EXTERNALNAME: importExternalName(); break; + case BIFF_ID_EXTERNSHEET: importExternSheet(); break; + case BIFF2_ID_DEFINEDNAME: importDefinedName(); break; + } + break; + case BIFF3: switch( nRecId ) + { + case BIFF_ID_CRN: importCrn(); break; + case BIFF3_ID_EXTERNALNAME: importExternalName(); break; + case BIFF_ID_EXTERNSHEET: importExternSheet(); break; + case BIFF3_ID_DEFINEDNAME: importDefinedName(); break; + case BIFF_ID_XCT: importXct(); break; + } + break; + case BIFF4: switch( nRecId ) + { + case BIFF_ID_CRN: importCrn(); break; + case BIFF3_ID_EXTERNALNAME: importExternalName(); break; + case BIFF_ID_EXTERNSHEET: importExternSheet(); break; + case BIFF3_ID_DEFINEDNAME: importDefinedName(); break; + case BIFF_ID_XCT: importXct(); break; + } + break; + case BIFF5: switch( nRecId ) + { + case BIFF_ID_CRN: importCrn(); break; + case BIFF5_ID_EXTERNALNAME: importExternalName(); break; + case BIFF_ID_EXTERNSHEET: importExternSheet(); break; + case BIFF5_ID_DEFINEDNAME: importDefinedName(); break; + case BIFF_ID_XCT: importXct(); break; + } + break; + case BIFF8: switch( nRecId ) + { + case BIFF_ID_CRN: importCrn(); break; + case BIFF_ID_EXTERNALBOOK: importExternalBook(); break; + case BIFF5_ID_EXTERNALNAME: importExternalName(); break; + case BIFF_ID_EXTERNSHEET: importExternSheet(); break; + case BIFF5_ID_DEFINEDNAME: importDefinedName(); break; + case BIFF_ID_XCT: importXct(); break; + } + break; + case BIFF_UNKNOWN: break; + } +} + +void BiffExternalLinkFragment::finalizeImport() +{ + getDefinedNames().finalizeImport(); +} + +// private -------------------------------------------------------------------- + +void BiffExternalLinkFragment::importExternSheet() +{ + mxSheetCache.clear(); + if( getBiff() == BIFF8 ) + getExternalLinks().importExternSheet8( mrStrm ); + else + mxExtLink = getExternalLinks().importExternSheet( mrStrm ); +} + +void BiffExternalLinkFragment::importExternalBook() +{ + mxSheetCache.clear(); + mxExtLink = getExternalLinks().importExternalBook( mrStrm ); +} + +void BiffExternalLinkFragment::importExternalName() +{ + if( mxExtLink.get() ) + mxExtLink->importExternalName( mrStrm ); +} + +void BiffExternalLinkFragment::importXct() +{ + mxSheetCache.clear(); + if( mxExtLink.get() && (mxExtLink->getLinkType() == LINKTYPE_EXTERNAL) ) + { + switch( getBiff() ) + { + case BIFF2: + break; + case BIFF3: + case BIFF4: + case BIFF5: + mxSheetCache = mxExtLink->getSheetCache( 0 ); + break; + case BIFF8: + mrStrm.skip( 2 ); + mxSheetCache = mxExtLink->getSheetCache( mrStrm.readInt16() ); + break; + case BIFF_UNKNOWN: break; + } + } +} + +void BiffExternalLinkFragment::importCrn() +{ + if( !mxSheetCache.is() ) return; + + sal_uInt8 nCol2, nCol1; + sal_uInt16 nRow; + mrStrm >> nCol2 >> nCol1 >> nRow; + bool bLoop = true; + for( BinAddress aBinAddr( nCol1, nRow ); bLoop && !mrStrm.isEof() && (aBinAddr.mnCol <= nCol2); ++aBinAddr.mnCol ) + { + switch( mrStrm.readuInt8() ) + { + case BIFF_DATATYPE_EMPTY: + mrStrm.skip( 8 ); + setCellValue( aBinAddr, Any( OUString() ) ); + break; + case BIFF_DATATYPE_DOUBLE: + setCellValue( aBinAddr, Any( mrStrm.readDouble() ) ); + break; + case BIFF_DATATYPE_STRING: + { + OUString aText = (getBiff() == BIFF8) ? mrStrm.readUniString() : mrStrm.readByteStringUC( false, getTextEncoding() ); + setCellValue( aBinAddr, Any( aText ) ); + } + break; + case BIFF_DATATYPE_BOOL: + { + double fValue = (mrStrm.readuInt8() == 0) ? 0.0 : 1.0; + setCellValue( aBinAddr, Any( fValue ) ); + mrStrm.skip( 7 ); + } + break; + case BIFF_DATATYPE_ERROR: + setCellValue( aBinAddr, Any( BiffHelper::calcDoubleFromError( mrStrm.readuInt8() ) ) ); + mrStrm.skip( 7 ); + break; + default: + OSL_ENSURE( false, "BiffExternalLinkFragment::importCrn - unknown data type" ); + bLoop = false; + } + } +} + +void BiffExternalLinkFragment::importDefinedName() +{ + if( mbImportDefNames ) + getDefinedNames().importDefinedName( mrStrm ); +} + +void BiffExternalLinkFragment::setCellValue( const BinAddress& rBinAddr, const Any& rValue ) +{ + CellAddress aCellPos; + if( mxSheetCache.is() && getAddressConverter().convertToCellAddress( aCellPos, rBinAddr, 0, false ) ) try + { + mxSheetCache->setCellValue( aCellPos.Column, aCellPos.Row, rValue ); + } + catch( Exception& ) + { + } +} + +// ============================================================================ + +} // namespace xls +} // namespace oox + |