/************************************************************** * * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ #include "oox/dump/biffdumper.hxx" #include #include #include "oox/core/filterbase.hxx" #include "oox/dump/oledumper.hxx" #include "oox/ole/olestorage.hxx" #include "oox/xls/biffdetector.hxx" #include "oox/xls/biffinputstream.hxx" #include "oox/xls/formulabase.hxx" #if OOX_INCLUDE_DUMPER namespace oox { namespace dump { namespace biff { // ============================================================================ using namespace ::com::sun::star::io; using namespace ::com::sun::star::lang; using namespace ::com::sun::star::uno; using namespace ::com::sun::star::util; using namespace ::oox::xls; using ::comphelper::MediaDescriptor; using ::oox::core::FilterBase; using ::rtl::OString; using ::rtl::OStringBuffer; using ::rtl::OStringToOUString; using ::rtl::OUString; using ::rtl::OUStringBuffer; // ============================================================================ namespace { // constants ------------------------------------------------------------------ const sal_uInt16 BIFF_FONTFLAG_BOLD = 0x0001; const sal_uInt16 BIFF_FONTFLAG_ITALIC = 0x0002; const sal_uInt16 BIFF_OBJTYPE_GROUP = 0; const sal_uInt16 BIFF_OBJTYPE_LINE = 1; const sal_uInt16 BIFF_OBJTYPE_RECTANGLE = 2; const sal_uInt16 BIFF_OBJTYPE_OVAL = 3; const sal_uInt16 BIFF_OBJTYPE_ARC = 4; const sal_uInt16 BIFF_OBJTYPE_CHART = 5; const sal_uInt16 BIFF_OBJTYPE_TEXT = 6; const sal_uInt16 BIFF_OBJTYPE_BUTTON = 7; const sal_uInt16 BIFF_OBJTYPE_PICTURE = 8; const sal_uInt16 BIFF_OBJTYPE_POLYGON = 9; const sal_uInt16 BIFF_OBJTYPE_CHECKBOX = 11; const sal_uInt16 BIFF_OBJTYPE_OPTIONBUTTON = 12; const sal_uInt16 BIFF_OBJTYPE_EDIT = 13; const sal_uInt16 BIFF_OBJTYPE_LABEL = 14; const sal_uInt16 BIFF_OBJTYPE_DIALOG = 15; const sal_uInt16 BIFF_OBJTYPE_SPIN = 16; const sal_uInt16 BIFF_OBJTYPE_SCROLLBAR = 17; const sal_uInt16 BIFF_OBJTYPE_LISTBOX = 18; const sal_uInt16 BIFF_OBJTYPE_GROUPBOX = 19; const sal_uInt16 BIFF_OBJTYPE_DROPDOWN = 20; const sal_uInt16 BIFF_OBJTYPE_NOTE = 25; const sal_uInt16 BIFF_OBJTYPE_DRAWING = 30; const sal_uInt16 BIFF_OBJFLAGS_CONTROL = 0x0010; /// Form control. const sal_uInt16 BIFF_OBJFLAGS_CTLSSTREAM = 0x0020; /// Data in Ctls stream. const sal_uInt16 BIFF_STYLE_BUILTIN = 0x8000; const sal_uInt16 BIFF_PT_NOSTRING = 0xFFFF; // ---------------------------------------------------------------------------- void lclDumpDffClientPos( const OutputRef& rxOut, const BinaryInputStreamRef& rxStrm, const String& rName, sal_uInt16 nSubScale ) { MultiItemsGuard aMultiGuard( rxOut ); TableGuard aTabGuard( rxOut, 17 ); { sal_uInt16 nPos = rxStrm->readuInt16(); ItemGuard aItem( rxOut, rName ); rxOut->writeDec( nPos ); } { sal_uInt16 nSubUnits = rxStrm->readuInt16(); ItemGuard aItem( rxOut, "sub-units" ); rxOut->writeDec( nSubUnits ); rxOut->writeChar( '/' ); rxOut->writeDec( nSubScale ); } } void lclDumpDffClientRect( const OutputRef& rxOut, const BinaryInputStreamRef& rxStrm ) { lclDumpDffClientPos( rxOut, rxStrm, "start-col", 1024 ); lclDumpDffClientPos( rxOut, rxStrm, "start-row", 256 ); lclDumpDffClientPos( rxOut, rxStrm, "end-col", 1024 ); lclDumpDffClientPos( rxOut, rxStrm, "end-row", 256 ); } } // namespace // ============================================================================ // ============================================================================ BiffDffStreamObject::BiffDffStreamObject( const OutputObjectBase& rParent, const BinaryInputStreamRef& rxStrm ) { DffStreamObject::construct( rParent, rxStrm ); } void BiffDffStreamObject::implDumpClientAnchor() { dumpHex< sal_uInt16 >( "flags", "DFF-CLIENTANCHOR-FLAGS" ); lclDumpDffClientRect( mxOut, mxStrm ); } // ============================================================================ BiffCtlsStreamObject::BiffCtlsStreamObject( const OutputObjectBase& rParent, const BinaryInputStreamRef& rxStrm ) { InputObjectBase::construct( rParent, rxStrm ); mnStartPos = mnLength = 0; } void BiffCtlsStreamObject::dumpControl( sal_uInt32 nStartPos, sal_uInt32 nLength ) { mnStartPos = nStartPos; mnLength = nLength; dump(); mnStartPos = mnLength = 0; } void BiffCtlsStreamObject::implDump() { if( mnLength > 0 ) { mxOut->emptyLine(); writeEmptyItem( "CTLS-START" ); { IndentGuard aIndGuard( mxOut ); mxStrm->seek( mnStartPos ); BinaryInputStreamRef xRelStrm( new RelativeInputStream( *mxStrm, mnLength ) ); FormControlStreamObject( *this, xRelStrm ).dump(); } writeEmptyItem( "CTLS-END" ); mxOut->emptyLine(); } } // ============================================================================ // ============================================================================ BiffConfig::BiffConfig( const Config& rParent, BiffType eBiff ) : meBiff( eBiff ) { Config::construct( rParent ); } bool BiffConfig::implIsValid() const { return (meBiff != BIFF_UNKNOWN) && Config::implIsValid(); } NameListRef BiffConfig::implGetNameList( const OUString& rKey ) const { NameListRef xList = Config::implGetNameList( rKey ); if( !xList ) { OUString aBaseKey = rKey + CREATE_OUSTRING( "-BIFF" ); switch( meBiff ) { // fall-through intended! case BIFF8: if( !xList ) xList = Config::implGetNameList( aBaseKey + OUString( sal_Unicode( '8' ) ) ); case BIFF5: if( !xList ) xList = Config::implGetNameList( aBaseKey + OUString( sal_Unicode( '5' ) ) ); case BIFF4: if( !xList ) xList = Config::implGetNameList( aBaseKey + OUString( sal_Unicode( '4' ) ) ); case BIFF3: if( !xList ) xList = Config::implGetNameList( aBaseKey + OUString( sal_Unicode( '3' ) ) ); case BIFF2: if( !xList ) xList = Config::implGetNameList( aBaseKey + OUString( sal_Unicode( '2' ) ) ); case BIFF_UNKNOWN: break; } } return xList; } // ============================================================================ BiffSharedData::BiffSharedData( BiffType eBiff ) : meBiff( eBiff ), meTextEnc( osl_getThreadTextEncoding() ) { } void BiffSharedData::initializePerSheet() { maFontEncs.clear(); maXfFontIds.clear(); meTextEnc = osl_getThreadTextEncoding(); } void BiffSharedData::setTextEncoding( rtl_TextEncoding eTextEnc ) { if( eTextEnc != RTL_TEXTENCODING_DONTKNOW ) meTextEnc = eTextEnc; } sal_uInt16 BiffSharedData::getFontCount() const { return static_cast< sal_uInt16 >( maFontEncs.size() ); } rtl_TextEncoding BiffSharedData::getFontEncoding( sal_uInt16 nFontId ) const { return (nFontId < getFontCount()) ? maFontEncs[ nFontId ] : meTextEnc; } void BiffSharedData::appendFontEncoding( rtl_TextEncoding eFontEnc ) { maFontEncs.push_back( (eFontEnc == RTL_TEXTENCODING_DONTKNOW) ? meTextEnc : eFontEnc ); if( maFontEncs.size() == 4 ) maFontEncs.push_back( meTextEnc ); } sal_uInt16 BiffSharedData::getXfCount() const { return static_cast< sal_uInt16 >( maXfFontIds.size() ); } rtl_TextEncoding BiffSharedData::getXfEncoding( sal_uInt16 nXfId ) const { sal_uInt16 nFontId = (nXfId < getXfCount()) ? maXfFontIds[ nXfId ] : 0; return getFontEncoding( nFontId ); } void BiffSharedData::appendXfFontId( sal_uInt16 nFontId ) { maXfFontIds.push_back( nFontId ); } bool BiffSharedData::implIsValid() const { return meBiff != BIFF_UNKNOWN; } // ============================================================================ BiffObjectBase::~BiffObjectBase() { } void BiffObjectBase::construct( const ObjectBase& rParent, const BinaryInputStreamRef& rxStrm, BiffType eBiff, const OUString& rSysFileName ) { if( rParent.isValid() && rxStrm.get() && (eBiff != BIFF_UNKNOWN) ) { mxBiffData.reset( new BiffSharedData( eBiff ) ); mxBiffStrm.reset( new BiffInputStream( *rxStrm ) ); RecordObjectBase::construct( rParent, rxStrm, rSysFileName, mxBiffStrm, "RECORD-NAMES", "SIMPLE-RECORDS" ); if( RecordObjectBase::implIsValid() ) { reconstructConfig( ConfigRef( new BiffConfig( cfg(), eBiff ) ) ); mxDffObj.reset( new BiffDffStreamObject( *this, mxBiffStrm ) ); if( StorageBase* pRootStrg = cfg().getRootStorage().get() ) { BinaryInputStreamRef xCtlsStrm( new BinaryXInputStream( pRootStrg->openInputStream( CREATE_OUSTRING( "Ctls" ) ), true ) ); mxCtlsObj.reset( new BiffCtlsStreamObject( *this, xCtlsStrm ) ); } const Config& rCfg = cfg(); mxErrCodes = rCfg.getNameList( "ERRORCODES" ); mxConstType = rCfg.getNameList( "CONSTVALUE-TYPE" ); mxResultType = rCfg.getNameList( "FORMULA-RESULTTYPE" ); mnLastRecId = BIFF_ID_UNKNOWN; mbMergeContRec = rCfg.getBoolOption( "merge-continue-record", true ); } } } void BiffObjectBase::construct( const BiffObjectBase& rParent ) { *this = rParent; } bool BiffObjectBase::implIsValid() const { return isValid( mxBiffData ) && mxBiffStrm.get() && isValid( mxDffObj ) && InputObjectBase::implIsValid(); } bool BiffObjectBase::implStartRecord( BinaryInputStream&, sal_Int64& ornRecPos, sal_Int64& ornRecId, sal_Int64& ornRecSize ) { // previous record mnLastRecId = mxBiffStrm->getRecId(); switch( mnLastRecId ) { case BIFF_ID_CHBEGIN: mxOut->incIndent(); break; } // start next record bool bValid = mxBiffStrm->startNextRecord(); ornRecPos = mxBiffStrm->tellBase() - 4; ornRecId = mxBiffStrm->getRecId(); // special CONTINUE handling mxBiffStrm->resetRecord( mbMergeContRec ); if( mbMergeContRec ) switch( mxBiffStrm->getRecId() ) { case BIFF_ID_OBJ: case BIFF_ID_TXO: case BIFF_ID_EOF: case BIFF_ID_CONT: mxBiffStrm->resetRecord( false ); break; case BIFF_ID_MSODRAWINGGROUP: case BIFF_ID_CHESCHERFORMAT: mxBiffStrm->resetRecord( true, mxBiffStrm->getRecId() ); break; } // record specific settings switch( mxBiffStrm->getRecId() ) { case BIFF2_ID_BOF: case BIFF3_ID_BOF: case BIFF4_ID_BOF: case BIFF5_ID_BOF: case BIFF_ID_INTERFACEHDR: mxBiffStrm->enableDecoder( false ); break; case BIFF_ID_CHEND: mxOut->decIndent(); break; } ornRecSize = mxBiffStrm->size(); return bValid; } OUString BiffObjectBase::getErrorName( sal_uInt8 nErrCode ) const { return cfg().getName( mxErrCodes, nErrCode ); } // ---------------------------------------------------------------------------- sal_Int32 BiffObjectBase::readCol( bool bCol16Bit ) { return bCol16Bit ? mxBiffStrm->readuInt16() : mxBiffStrm->readuInt8(); } sal_Int32 BiffObjectBase::readRow( bool bRow32Bit ) { return bRow32Bit ? mxBiffStrm->readInt32() : mxBiffStrm->readuInt16(); } void BiffObjectBase::readAddress( Address& orAddress, bool bCol16Bit, bool bRow32Bit ) { orAddress.mnRow = readRow( bRow32Bit ); orAddress.mnCol = readCol( bCol16Bit ); } void BiffObjectBase::readRange( Range& orRange, bool bCol16Bit, bool bRow32Bit ) { orRange.maFirst.mnRow = readRow( bRow32Bit ); orRange.maLast.mnRow = readRow( bRow32Bit ); orRange.maFirst.mnCol = readCol( bCol16Bit ); orRange.maLast.mnCol = readCol( bCol16Bit ); } void BiffObjectBase::readRangeList( RangeList& orRanges, bool bCol16Bit, bool bRow32Bit ) { sal_uInt16 nCount; *mxBiffStrm >> nCount; orRanges.resize( nCount ); for( RangeList::iterator aIt = orRanges.begin(), aEnd = orRanges.end(); !mxBiffStrm->isEof() && (aIt != aEnd); ++aIt ) readRange( *aIt, bCol16Bit, bRow32Bit ); } // ---------------------------------------------------------------------------- void BiffObjectBase::writeBooleanItem( const String& rName, sal_uInt8 nBool ) { writeDecItem( rName, nBool, "BOOLEAN" ); } void BiffObjectBase::writeErrorCodeItem( const String& rName, sal_uInt8 nErrCode ) { writeHexItem( rName, nErrCode, mxErrCodes ); } void BiffObjectBase::writeFontPortions( const FontPortionModelList& rPortions ) { if( !rPortions.empty() ) { writeDecItem( "font-count", static_cast< sal_uInt32 >( rPortions.size() ) ); TableGuard aTabGuard( mxOut, 14 ); for( FontPortionModelList::const_iterator aIt = rPortions.begin(), aEnd = rPortions.end(); aIt != aEnd; ++aIt ) { MultiItemsGuard aMultiGuard( mxOut ); writeDecItem( "char-pos", aIt->mnPos ); writeDecItem( "font-idx", aIt->mnFontId, "FONTNAMES" ); } } } // ---------------------------------------------------------------------------- OUString BiffObjectBase::dumpByteString( const String& rName, BiffStringFlags nFlags, rtl_TextEncoding eDefaultTextEnc ) { OSL_ENSURE( !getFlag( nFlags, static_cast< BiffStringFlags >( ~(BIFF_STR_8BITLENGTH | BIFF_STR_EXTRAFONTS) ) ), "BiffObjectBase::dumpByteString - unknown flag" ); bool b8BitLength = getFlag( nFlags, BIFF_STR_8BITLENGTH ); OString aString = mxBiffStrm->readByteString( !b8BitLength, true ); FontPortionModelList aPortions; if( getFlag( nFlags, BIFF_STR_EXTRAFONTS ) ) aPortions.importPortions( *mxBiffStrm, false ); // create string portions OUStringBuffer aBuffer; sal_Int32 nStrLen = aString.getLength(); if( nStrLen > 0 ) { // add leading and trailing string position to ease the following loop if( aPortions.empty() || (aPortions.front().mnPos > 0) ) aPortions.insert( aPortions.begin(), FontPortionModel( 0, -1 ) ); if( aPortions.back().mnPos < nStrLen ) aPortions.push_back( FontPortionModel( nStrLen, -1 ) ); // use global text encoding, if nothing special is specified if( eDefaultTextEnc == RTL_TEXTENCODING_DONTKNOW ) eDefaultTextEnc = getBiffData().getTextEncoding(); // create all string portions according to the font id vector for( FontPortionModelList::const_iterator aIt = aPortions.begin(); aIt->mnPos < nStrLen; ++aIt ) { sal_Int32 nPortionLen = (aIt + 1)->mnPos - aIt->mnPos; if( nPortionLen > 0 ) { // convert byte string to unicode string, using current font encoding rtl_TextEncoding eTextEnc = mxBiffData->getFontEncoding( static_cast< sal_uInt16 >( aIt->mnFontId ) ); if( eTextEnc == RTL_TEXTENCODING_DONTKNOW ) eTextEnc = eDefaultTextEnc; aBuffer.append( OStringToOUString( aString.copy( aIt->mnPos, nPortionLen ), eTextEnc ) ); } } } OUString aUniStr = aBuffer.makeStringAndClear(); writeStringItem( rName( "text" ), aUniStr ); return aUniStr; } OUString BiffObjectBase::dumpUniString( const String& rName, BiffStringFlags nFlags ) { OSL_ENSURE( !getFlag( nFlags, static_cast< BiffStringFlags >( ~(BIFF_STR_8BITLENGTH | BIFF_STR_SMARTFLAGS) ) ), "BiffObjectBase::dumpUniString - unknown flag" ); bool b8BitLength = getFlag( nFlags, BIFF_STR_8BITLENGTH ); // --- string header --- sal_uInt16 nChars = b8BitLength ? mxBiffStrm->readuInt8() : mxBiffStrm->readuInt16(); sal_uInt8 nFlagField = 0; if( (nChars > 0) || !getFlag( nFlags, BIFF_STR_SMARTFLAGS ) ) *mxBiffStrm >> nFlagField; bool b16Bit = getFlag( nFlagField, BIFF_STRF_16BIT ); bool bFonts = getFlag( nFlagField, BIFF_STRF_RICH ); bool bPhonetic = getFlag( nFlagField, BIFF_STRF_PHONETIC ); sal_uInt16 nFontCount = bFonts ? mxBiffStrm->readuInt16() : 0; sal_uInt32 nPhoneticSize = bPhonetic ? mxBiffStrm->readuInt32() : 0; // --- character array --- OUString aString = mxBiffStrm->readUniStringChars( nChars, b16Bit, true ); writeStringItem( rName( "text" ), aString ); // --- formatting --- // #122185# bRich flag may be set, but format runs may be missing if( nFontCount > 0 ) { IndentGuard aIndGuard( mxOut ); FontPortionModelList aPortions; aPortions.importPortions( *mxBiffStrm, nFontCount, BIFF_FONTPORTION_16BIT ); writeFontPortions( aPortions ); } // --- phonetic information --- // #122185# bPhonetic flag may be set, but phonetic data may be missing if( nPhoneticSize > 0 ) { sal_Int64 nStrmPos = mxBiffStrm->tell(); IndentGuard aIndGuard( mxOut ); writeEmptyItem( "phonetic-data" ); dumpUnused( 2 ); dumpDec< sal_uInt16 >( "size" ); dumpDec< sal_uInt16 >( "font-idx", "FONTNAMES" ); dumpHex< sal_uInt16 >( "flags", "PHONETICPR-FLAGS" ); sal_uInt16 nCount = dumpDec< sal_uInt16 >( "portion-count" ); sal_uInt16 nLen = dumpDec< sal_uInt16 >( "text-len" ); dumpUnicodeArray( "text", mxBiffStrm->readuInt16() ); if( nLen == 0 ) dumpUnused( 2 ); for( sal_uInt16 nPortion = 0; !mxBiffStrm->isEof() && (nPortion < nCount); ++nPortion ) { MultiItemsGuard aMultiGuard( mxOut ); dumpDec< sal_uInt16 >( "first-portion-char" ); dumpDec< sal_uInt16 >( "first-main-char" ); dumpDec< sal_uInt16 >( "main-char-count" ); } dumpRemainingTo( nStrmPos + nPhoneticSize ); } return aString; } OUString BiffObjectBase::dumpString( const String& rName, BiffStringFlags nByteFlags, BiffStringFlags nUniFlags, rtl_TextEncoding eDefaultTextEnc ) { return (getBiff() == BIFF8) ? dumpUniString( rName, nUniFlags ) : dumpByteString( rName, nByteFlags, eDefaultTextEnc ); } OUString BiffObjectBase::dumpSegmentedUniString( const String& rName ) { sal_Int32 nLength = mxBiffStrm->readInt32(); OUStringBuffer aBuffer; while( !mxBiffStrm->isEof() && (aBuffer.getLength() < nLength) ) aBuffer.append( mxBiffStrm->readUniString() ); OUString aString = aBuffer.makeStringAndClear(); writeStringItem( rName, aString ); return aString; } void BiffObjectBase::dumpSegmentedUniStringArray( const String& rName ) { writeEmptyItem( rName ); IndentGuard aIndGuard( mxOut ); mxOut->resetItemIndex(); for( sal_uInt16 nIndex = 0, nCount = dumpDec< sal_uInt16 >( "count" ); !mxBiffStrm->isEof() && (nIndex < nCount); ++nIndex ) dumpSegmentedUniString( "#entry" ); } sal_uInt8 BiffObjectBase::dumpBoolean( const String& rName ) { sal_uInt8 nBool; *mxBiffStrm >> nBool; writeBooleanItem( rName( "boolean" ), nBool ); return nBool; } sal_uInt8 BiffObjectBase::dumpErrorCode( const String& rName ) { sal_uInt8 nErrCode; *mxBiffStrm >> nErrCode; writeErrorCodeItem( rName( "error-code" ), nErrCode ); return nErrCode; } rtl_TextEncoding BiffObjectBase::dumpCodePage( const String& rName ) { sal_uInt16 nCodePage = dumpDec< sal_uInt16 >( rName( "codepage" ), "CODEPAGES" ); return BiffHelper::calcTextEncodingFromCodePage( nCodePage ); } void BiffObjectBase::dumpFormulaResult( const String& rName ) { MultiItemsGuard aMultiGuard( mxOut ); sal_uInt8 pnResult[ 8 ]; mxBiffStrm->readMemory( pnResult, 8 ); writeArrayItem( rName( "result" ), pnResult, 8 ); if( (pnResult[ 6 ] == 0xFF) && (pnResult[ 7 ] == 0xFF) ) { sal_uInt8 nType = pnResult[ 0 ]; sal_uInt8 nData = pnResult[ 2 ]; writeHexItem( "type", nType, mxResultType ); switch( nType ) { case 1: writeBooleanItem( "value", nData ); break; case 2: writeErrorCodeItem( "value", nData ); break; } } else { double* pfValue = reinterpret_cast< double* >( pnResult ); ByteOrderConverter::convertLittleEndian( *pfValue ); writeDecItem( "value", *pfValue ); } } sal_Int32 BiffObjectBase::dumpColIndex( const String& rName, bool bCol16Bit ) { sal_Int32 nCol = readCol( bCol16Bit ); writeColIndexItem( rName( "col-idx" ), nCol ); return nCol; } sal_Int32 BiffObjectBase::dumpRowIndex( const String& rName, bool bRow32Bit ) { sal_Int32 nRow = readRow( bRow32Bit ); writeRowIndexItem( rName( "row-idx" ), nRow ); return nRow; } sal_Int32 BiffObjectBase::dumpColRange( const String& rName, bool bCol16Bit ) { sal_Int32 nCol1 = readCol( bCol16Bit ); sal_Int32 nCol2 = readCol( bCol16Bit ); writeColRangeItem( rName( "col-range" ), nCol1, nCol2 ); return nCol2 - nCol1 + 1; } sal_Int32 BiffObjectBase::dumpRowRange( const String& rName, bool bRow32Bit ) { sal_Int32 nRow1 = readRow( bRow32Bit ); sal_Int32 nRow2 = readRow( bRow32Bit ); writeRowRangeItem( rName( "row-range" ), nRow1, nRow2 ); return nRow2 - nRow1 + 1; } Address BiffObjectBase::dumpAddress( const String& rName, bool bCol16Bit, bool bRow32Bit ) { Address aPos; readAddress( aPos, bCol16Bit, bRow32Bit ); writeAddressItem( rName( "addr" ), aPos ); return aPos; } Range BiffObjectBase::dumpRange( const String& rName, bool bCol16Bit, bool bRow32Bit ) { Range aRange; readRange( aRange, bCol16Bit, bRow32Bit ); writeRangeItem( rName( "range" ), aRange ); return aRange; } void BiffObjectBase::dumpRangeList( const String& rName, bool bCol16Bit, bool bRow32Bit ) { RangeList aRanges; readRangeList( aRanges, bCol16Bit, bRow32Bit ); writeRangeListItem( rName( "range-list" ), aRanges ); } void BiffObjectBase::dumpConstArrayHeader( sal_uInt32& rnCols, sal_uInt32& rnRows ) { MultiItemsGuard aMultiGuard( mxOut ); rnCols = dumpDec< sal_uInt8 >( "width" ); rnRows = dumpDec< sal_uInt16 >( "height" ); switch( getBiff() ) { case BIFF2: case BIFF3: case BIFF4: case BIFF5: if( rnCols == 0 ) rnCols = 256; break; case BIFF8: ++rnCols; ++rnRows; break; case BIFF_UNKNOWN: break; } ItemGuard aItem( mxOut, "size" ); mxOut->writeDec( rnCols ); mxOut->writeChar( 'x' ); mxOut->writeDec( rnRows ); aItem.cont(); mxOut->writeDec( rnCols * rnRows ); } OUString BiffObjectBase::dumpConstValue( sal_Unicode cStrQuote ) { MultiItemsGuard aMultiGuard( mxOut ); OUStringBuffer aValue; switch( dumpDec< sal_uInt8 >( "type", mxConstType ) ) { case BIFF_DATATYPE_EMPTY: dumpUnused( 8 ); aValue.append( OOX_DUMP_EMPTYVALUE ); break; case BIFF_DATATYPE_DOUBLE: dumpDec< double >( "value" ); aValue.append( mxOut->getLastItemValue() ); break; case BIFF_DATATYPE_STRING: aValue.append( dumpString( "value", BIFF_STR_8BITLENGTH ) ); StringHelper::enclose( aValue, cStrQuote ); break; case BIFF_DATATYPE_BOOL: dumpBoolean( "value" ); aValue.append( mxOut->getLastItemValue() ); dumpUnused( 7 ); break; case BIFF_DATATYPE_ERROR: dumpErrorCode( "value" ); aValue.append( mxOut->getLastItemValue() ); dumpUnused( 7 ); break; } return aValue.makeStringAndClear(); } sal_uInt16 BiffObjectBase::dumpRepeatedRecId() { return dumpHex< sal_uInt16 >( "repeated-rec-id", getRecNames() ); } void BiffObjectBase::dumpFrHeader( bool bWithFlags, bool bWithRange ) { dumpHex< sal_uInt16 >( "fr-rec-id", getRecNames() ); sal_Int16 nFlags = bWithFlags ? dumpHex< sal_uInt16 >( "fr-flags", "FR-FLAGS" ) : 0x0001; if( bWithRange ) { if( getFlag< sal_uInt16 >( nFlags, 0x0001 ) ) dumpRange( "fr-range" ); else dumpUnused( 8 ); } } void BiffObjectBase::dumpDffClientRect() { lclDumpDffClientRect( mxOut, mxStrm ); } void BiffObjectBase::dumpEmbeddedDff() { mxOut->decIndent(); writeEmptyItem( "EMBEDDED-DFF-START" ); mxOut->incIndent(); mxDffObj->dump(); mxOut->emptyLine(); mxOut->decIndent(); writeEmptyItem( "EMBEDDED-DFF-END" ); mxOut->incIndent(); } void BiffObjectBase::dumpControl() { sal_uInt32 nStartPos = dumpHex< sal_uInt32 >( "ctls-stream-pos", "CONV-DEC" ); sal_uInt32 nLength = dumpHex< sal_uInt32 >( "ctls-stream-length", "CONV-DEC" ); if( isValid( mxCtlsObj ) ) mxCtlsObj->dumpControl( nStartPos, nLength ); } // ============================================================================ // ============================================================================ FormulaObject::FormulaObject( const BiffObjectBase& rParent ) : mnSize( 0 ) { BiffObjectBase::construct( rParent ); constructFmlaObj(); } FormulaObject::~FormulaObject() { } sal_uInt16 FormulaObject::readFormulaSize() { return (getBiff() == BIFF2) ? getBiffStream().readuInt8() : getBiffStream().readuInt16(); } sal_uInt16 FormulaObject::dumpFormulaSize( const String& rName ) { sal_uInt16 nSize = readFormulaSize(); writeDecItem( rName( "formula-size" ), nSize ); return nSize; } void FormulaObject::dumpCellFormula( const String& rName, sal_uInt16 nSize ) { dumpFormula( rName, nSize, false ); } void FormulaObject::dumpCellFormula( const String& rName ) { dumpFormula( rName, false ); } void FormulaObject::dumpNameFormula( const String& rName, sal_uInt16 nSize ) { dumpFormula( rName, nSize, true ); } void FormulaObject::dumpNameFormula( const String& rName ) { dumpFormula( rName, true ); } void FormulaObject::implDump() { { MultiItemsGuard aMultiGuard( mxOut ); writeEmptyItem( maName ); writeDecItem( "formula-size", mnSize ); } if( mnSize == 0 ) return; sal_Int64 nStartPos = mxStrm->tell(); sal_Int64 nEndPos = ::std::min< sal_Int64 >( nStartPos + mnSize, mxStrm->size() ); bool bValid = mxTokens.get(); mxStack.reset( new FormulaStack ); maAddData.clear(); IndentGuard aIndGuard( mxOut ); { TableGuard aTabGuard( mxOut, 8, 18 ); while( bValid && !mxStrm->isEof() && (mxStrm->tell() < nEndPos) ) { MultiItemsGuard aMultiGuard( mxOut ); writeHexItem( EMPTY_STRING, static_cast< sal_uInt16 >( mxStrm->tell() - nStartPos ) ); sal_uInt8 nTokenId = dumpHex< sal_uInt8 >( EMPTY_STRING, mxTokens ); bValid = mxTokens->hasName( nTokenId ); if( bValid ) { sal_uInt8 nTokClass = nTokenId & BIFF_TOKCLASS_MASK; sal_uInt8 nBaseId = nTokenId & BIFF_TOKID_MASK; if( nTokClass == BIFF_TOKCLASS_NONE ) { switch( nBaseId ) { case BIFF_TOKID_EXP: dumpExpToken( "EXP" ); break; case BIFF_TOKID_TBL: dumpExpToken( "TBL" ); break; case BIFF_TOKID_ADD: dumpBinaryOpToken( "+" ); break; case BIFF_TOKID_SUB: dumpBinaryOpToken( "-" ); break; case BIFF_TOKID_MUL: dumpBinaryOpToken( "*" ); break; case BIFF_TOKID_DIV: dumpBinaryOpToken( "/" ); break; case BIFF_TOKID_POWER: dumpBinaryOpToken( "^" ); break; case BIFF_TOKID_CONCAT: dumpBinaryOpToken( "&" ); break; case BIFF_TOKID_LT: dumpBinaryOpToken( "<" ); break; case BIFF_TOKID_LE: dumpBinaryOpToken( "<=" ); break; case BIFF_TOKID_EQ: dumpBinaryOpToken( "=" ); break; case BIFF_TOKID_GE: dumpBinaryOpToken( ">=" ); break; case BIFF_TOKID_GT: dumpBinaryOpToken( "<" ); break; case BIFF_TOKID_NE: dumpBinaryOpToken( "<>" ); break; case BIFF_TOKID_ISECT: dumpBinaryOpToken( " " ); break; case BIFF_TOKID_LIST: dumpBinaryOpToken( "," ); break; case BIFF_TOKID_RANGE: dumpBinaryOpToken( ":" ); break; case BIFF_TOKID_UPLUS: dumpUnaryOpToken( "+", "" ); break; case BIFF_TOKID_UMINUS: dumpUnaryOpToken( "-", "" ); break; case BIFF_TOKID_PERCENT: dumpUnaryOpToken( "", "%" ); break; case BIFF_TOKID_PAREN: dumpUnaryOpToken( "(", ")" ); break; case BIFF_TOKID_MISSARG: dumpMissArgToken(); break; case BIFF_TOKID_STR: dumpStringToken(); break; case BIFF_TOKID_NLR: bValid = dumpNlrToken(); break; case BIFF_TOKID_ATTR: bValid = dumpAttrToken(); break; case BIFF_TOKID_SHEET: dumpSheetToken(); break; case BIFF_TOKID_ENDSHEET: dumpEndSheetToken(); break; case BIFF_TOKID_ERR: dumpErrorToken(); break; case BIFF_TOKID_BOOL: dumpBoolToken(); break; case BIFF_TOKID_INT: dumpIntToken(); break; case BIFF_TOKID_NUM: dumpDoubleToken(); break; default: bValid = false; } } else { OUString aTokClass = cfg().getName( mxClasses, nTokClass ); switch( nBaseId ) { case BIFF_TOKID_ARRAY: dumpArrayToken( aTokClass ); break; case BIFF_TOKID_FUNC: dumpFuncToken( aTokClass ); break; case BIFF_TOKID_FUNCVAR: dumpFuncVarToken( aTokClass ); break; case BIFF_TOKID_NAME: dumpNameToken( aTokClass ); break; case BIFF_TOKID_REF: dumpRefToken( aTokClass, false ); break; case BIFF_TOKID_AREA: dumpAreaToken( aTokClass, false ); break; case BIFF_TOKID_MEMAREA: dumpMemAreaToken( aTokClass, true ); break; case BIFF_TOKID_MEMERR: dumpMemAreaToken( aTokClass, false ); break; case BIFF_TOKID_MEMNOMEM: dumpMemAreaToken( aTokClass, false ); break; case BIFF_TOKID_MEMFUNC: dumpMemFuncToken( aTokClass ); break; case BIFF_TOKID_REFERR: dumpRefErrToken( aTokClass, false ); break; case BIFF_TOKID_AREAERR: dumpRefErrToken( aTokClass, true ); break; case BIFF_TOKID_REFN: dumpRefToken( aTokClass, true ); break; case BIFF_TOKID_AREAN: dumpAreaToken( aTokClass, true ); break; case BIFF_TOKID_MEMAREAN: dumpMemFuncToken( aTokClass ); break; case BIFF_TOKID_MEMNOMEMN: dumpMemFuncToken( aTokClass ); break; case BIFF_TOKID_FUNCCE: dumpCmdToken( aTokClass ); break; case BIFF_TOKID_NAMEX: dumpNameXToken( aTokClass ); break; case BIFF_TOKID_REF3D: dumpRef3dToken( aTokClass, mbNameMode ); break; case BIFF_TOKID_AREA3D: dumpArea3dToken( aTokClass, mbNameMode ); break; case BIFF_TOKID_REFERR3D: dumpRefErr3dToken( aTokClass, false ); break; case BIFF_TOKID_AREAERR3D: dumpRefErr3dToken( aTokClass, true ); break; default: bValid = false; } } } } } bValid = nEndPos == mxStrm->tell(); if( bValid ) { dumpAddTokenData(); writeInfoItem( "formula", mxStack->getFormulaString() ); writeInfoItem( "classes", mxStack->getClassesString() ); } else dumpBinary( OOX_DUMP_ERRASCII( "formula-error" ), nEndPos - mxStrm->tell(), false ); mnSize = 0; } void FormulaObject::dumpFormula( const String& rName, sal_uInt16 nSize, bool bNameMode ) { maName = rName( "formula" ); mnSize = nSize; mbNameMode = bNameMode; dump(); mnSize = 0; } void FormulaObject::dumpFormula( const String& rName, bool bNameMode ) { dumpFormula( rName, readFormulaSize(), bNameMode ); } // private -------------------------------------------------------------------- void FormulaObject::constructFmlaObj() { if( BiffObjectBase::implIsValid() ) { mxFuncProv.reset( new FunctionProvider( FILTER_BIFF, getBiff(), true ) ); Config& rCfg = cfg(); mxClasses = rCfg.getNameList( "TOKENCLASSES" ); mxRelFlags = rCfg.getNameList( "REFRELFLAGS" ); mxNlrTypes = rCfg.getNameList( "NLRTYPES" ); mxAttrTypes = rCfg.getNameList( "ATTRTYPES" ); mxSpTypes = rCfg.getNameList( "ATTRSPACETYPES" ); // create classified token names mxTokens = rCfg.createNameList< ConstList >( "TOKENS" ); mxTokens->includeList( rCfg.getNameList( "BASETOKENS" ) ); NameListRef xClassTokens = rCfg.getNameList( "CLASSTOKENS" ); if( mxClasses.get() && xClassTokens.get() ) for( NameListBase::const_iterator aCIt = mxClasses->begin(), aCEnd = mxClasses->end(); aCIt != aCEnd; ++aCIt ) for( NameListBase::const_iterator aTIt = xClassTokens->begin(), aTEnd = xClassTokens->end(); aTIt != aTEnd; ++aTIt ) mxTokens->setName( aCIt->first | aTIt->first, aTIt->second + aCIt->second ); mnColCount = 256; mnRowCount = (getBiff() == BIFF8) ? 65536 : 16384; } } // ---------------------------------------------------------------------------- namespace { OUString lclCreateName( const OUString& rRef, sal_uInt16 nNameIdx ) { OUStringBuffer aName( rRef ); StringHelper::appendIndexedText( aName, CREATE_OUSTRING( "NAME" ), nNameIdx ); return aName.makeStringAndClear(); } OUString lclCreateNlr( const OUString& rData, bool bRel = true ) { OUStringBuffer aNlr; if( !bRel ) aNlr.append( OOX_DUMP_ADDRABS ); StringHelper::appendIndexedText( aNlr, CREATE_OUSTRING( "NLR" ), rData ); return aNlr.makeStringAndClear(); } OUString lclCreateNlr( const TokenAddress& rPos ) { OUStringBuffer aAddr; StringHelper::appendAddrCol( aAddr, rPos.mnCol, true ); StringHelper::appendAddrRow( aAddr, rPos.mnRow, true ); return lclCreateNlr( aAddr.makeStringAndClear(), rPos.mbRelRow ); } } // namespace // ---------------------------------------------------------------------------- TokenAddress FormulaObject::createTokenAddress( sal_uInt16 nCol, sal_uInt16 nRow, bool bRelC, bool bRelR, bool bNameMode ) const { TokenAddress aPos; aPos.mnCol = nCol; if( bRelC && bNameMode && (nCol >= mnColCount / 2) ) aPos.mnCol -= mnColCount; aPos.mbRelCol = bRelC; aPos.mnRow = nRow; if( bRelR && bNameMode && (nRow >= mnRowCount / 2) ) aPos.mnRow -= mnRowCount; aPos.mbRelRow = bRelR; return aPos; } OUString FormulaObject::createRef( const OUString& rData ) const { return maRefPrefix + rData; } OUString FormulaObject::createName( sal_uInt16 nNameIdx ) const { return lclCreateName( maRefPrefix, nNameIdx ); } OUString FormulaObject::createPlaceHolder( size_t nIdx ) const { OUStringBuffer aStr; StringHelper::appendDec( aStr, static_cast< sal_uInt32 >( nIdx ) ); StringHelper::enclose( aStr, OOX_DUMP_PLACEHOLDER ); return aStr.makeStringAndClear(); } OUString FormulaObject::createPlaceHolder() const { return createPlaceHolder( maAddData.size() ); } sal_uInt16 FormulaObject::readFuncId() { return (getBiff() >= BIFF4) ? mxStrm->readuInt16() : mxStrm->readuInt8(); } OUString FormulaObject::writeFuncIdItem( sal_uInt16 nFuncId, const FunctionInfo** oppFuncInfo ) { ItemGuard aItemGuard( mxOut, "func-id" ); writeHexItem( EMPTY_STRING, nFuncId, "FUNCID" ); OUStringBuffer aBuffer; const FunctionInfo* pFuncInfo = mxFuncProv->getFuncInfoFromBiffFuncId( nFuncId ); if( pFuncInfo ) aBuffer.append( pFuncInfo->maOoxFuncName ); else { bool bCmd = getFlag( nFuncId, BIFF_TOK_FUNCVAR_CMD ); aBuffer.appendAscii( bCmd ? "CMD" : "FUNC" ); StringHelper::appendIndex( aBuffer, nFuncId & BIFF_TOK_FUNCVAR_FUNCIDMASK ); } OUString aFuncName = aBuffer.makeStringAndClear(); aItemGuard.cont(); mxOut->writeChar( OOX_DUMP_STRQUOTE ); mxOut->writeString( aFuncName ); mxOut->writeChar( OOX_DUMP_STRQUOTE ); if( oppFuncInfo ) *oppFuncInfo = pFuncInfo; return aFuncName; } sal_uInt16 FormulaObject::dumpTokenCol( const String& rName, bool& rbRelC, bool& rbRelR ) { sal_uInt16 nCol = 0; if( getBiff() == BIFF8 ) { nCol = dumpHex< sal_uInt16 >( rName, mxRelFlags ); rbRelC = getFlag( nCol, BIFF_TOK_REF_COLREL ); rbRelR = getFlag( nCol, BIFF_TOK_REF_ROWREL ); nCol &= BIFF_TOK_REF_COLMASK; } else nCol = dumpDec< sal_uInt8 >( rName ); return nCol; } sal_uInt16 FormulaObject::dumpTokenRow( const String& rName, bool& rbRelC, bool& rbRelR ) { sal_uInt16 nRow = 0; if( getBiff() == BIFF8 ) nRow = dumpDec< sal_uInt16 >( rName ); else { nRow = dumpHex< sal_uInt16 >( rName, mxRelFlags ); rbRelC = getFlag( nRow, BIFF_TOK_REF_COLREL ); rbRelR = getFlag( nRow, BIFF_TOK_REF_ROWREL ); nRow &= BIFF_TOK_REF_ROWMASK; } return nRow; } TokenAddress FormulaObject::dumpTokenAddress( bool bNameMode ) { bool bRelC = false; bool bRelR = false; sal_uInt16 nRow = dumpTokenRow( "row", bRelC, bRelR ); sal_uInt16 nCol = dumpTokenCol( "col", bRelC, bRelR ); return createTokenAddress( nCol, nRow, bRelC, bRelR, bNameMode ); } TokenRange FormulaObject::dumpTokenRange( bool bNameMode ) { bool bRelC1 = false; bool bRelR1 = false; bool bRelC2 = false; bool bRelR2 = false; sal_uInt16 nRow1 = dumpTokenRow( "row1", bRelC1, bRelR1 ); sal_uInt16 nRow2 = dumpTokenRow( "row2", bRelC2, bRelR2 ); sal_uInt16 nCol1 = dumpTokenCol( "col1", bRelC1, bRelR1 ); sal_uInt16 nCol2 = dumpTokenCol( "col2", bRelC2, bRelR2 ); TokenRange aRange; aRange.maFirst = createTokenAddress( nCol1, nRow1, bRelC1, bRelR1, bNameMode ); aRange.maLast = createTokenAddress( nCol2, nRow2, bRelC2, bRelR2, bNameMode ); return aRange; } sal_Int16 FormulaObject::readTokenRefIdx() { sal_Int16 nRefIdx = dumpDec< sal_Int16 >( "ref-idx" ); switch( getBiff() ) { case BIFF2: dumpUnused( 1 ); break; case BIFF3: dumpUnused( 2 ); break; case BIFF4: dumpUnused( 2 ); break; case BIFF5: dumpUnused( 8 ); break; case BIFF8: break; case BIFF_UNKNOWN: break; } return nRefIdx; } OUString FormulaObject::dumpTokenRefIdx() { OUStringBuffer aRef( CREATE_OUSTRING( "REF" ) ); StringHelper::appendIndex( aRef, readTokenRefIdx() ); aRef.append( OOX_DUMP_TABSEP ); return aRef.makeStringAndClear(); } OUString FormulaObject::dumpTokenRefTabIdxs() { sal_Int16 nRefIdx = readTokenRefIdx(); OUStringBuffer aRef( CREATE_OUSTRING( "REF" ) ); StringHelper::appendIndex( aRef, nRefIdx ); if( getBiff() == BIFF5 ) { dumpDec< sal_Int16 >( "tab1" ); sal_Int16 nTab2 = dumpDec< sal_Int16 >( "tab2" ); if( (nRefIdx > 0) && (nTab2 > 0) && (nRefIdx != nTab2) ) { aRef.append( OOX_DUMP_RANGESEP ); aRef.appendAscii( "REF" ); StringHelper::appendIndex( aRef, nTab2 ); } } aRef.append( OOX_DUMP_TABSEP ); return aRef.makeStringAndClear(); } void FormulaObject::dumpIntToken() { dumpDec< sal_uInt16 >( "value" ); mxStack->pushOperand( mxOut->getLastItemValue() ); } void FormulaObject::dumpDoubleToken() { dumpDec< double >( "value" ); mxStack->pushOperand( mxOut->getLastItemValue() ); } void FormulaObject::dumpStringToken() { OUStringBuffer aValue; aValue.append( dumpString( "value", BIFF_STR_8BITLENGTH, BIFF_STR_8BITLENGTH ) ); StringHelper::enclose( aValue, OOX_DUMP_FMLASTRQUOTE ); mxStack->pushOperand( aValue.makeStringAndClear() ); } void FormulaObject::dumpBoolToken() { dumpBoolean( "value" ); mxStack->pushOperand( mxOut->getLastItemValue() ); } void FormulaObject::dumpErrorToken() { dumpErrorCode( "value" ); mxStack->pushOperand( mxOut->getLastItemValue() ); } void FormulaObject::dumpMissArgToken() { mxStack->pushOperand( OUString( OOX_DUMP_EMPTYVALUE ) ); } void FormulaObject::dumpArrayToken( const OUString& rTokClass ) { dumpUnused( (getBiff() == BIFF2) ? 6 : 7 ); mxStack->pushOperand( createPlaceHolder(), rTokClass ); maAddData.push_back( ADDDATA_ARRAY ); } void FormulaObject::dumpNameToken( const OUString& rTokClass ) { sal_uInt16 nNameIdx = dumpDec< sal_uInt16 >( "name-idx" ); switch( getBiff() ) { case BIFF2: dumpUnused( 5 ); break; case BIFF3: case BIFF4: dumpUnused( 8 ); break; case BIFF5: dumpUnused( 12 ); break; case BIFF8: dumpUnused( 2 ); break; case BIFF_UNKNOWN: break; } mxStack->pushOperand( createName( nNameIdx ), rTokClass ); } void FormulaObject::dumpNameXToken( const OUString& rTokClass ) { OUString aRef = dumpTokenRefIdx(); sal_uInt16 nNameIdx = dumpDec< sal_uInt16 >( "name-idx" ); dumpUnused( (getBiff() == BIFF8) ? 2 : 12 ); mxStack->pushOperand( lclCreateName( aRef, nNameIdx ), rTokClass ); } void FormulaObject::dumpRefToken( const OUString& rTokClass, bool bNameMode ) { TokenAddress aPos = dumpTokenAddress( bNameMode ); writeTokenAddressItem( "addr", aPos, bNameMode ); mxStack->pushOperand( createRef( mxOut->getLastItemValue() ), rTokClass ); } void FormulaObject::dumpAreaToken( const OUString& rTokClass, bool bNameMode ) { TokenRange aRange = dumpTokenRange( bNameMode ); writeTokenRangeItem( "range", aRange, bNameMode ); mxStack->pushOperand( createRef( mxOut->getLastItemValue() ), rTokClass ); } void FormulaObject::dumpRefErrToken( const OUString& rTokClass, bool bArea ) { dumpUnused( ((getBiff() == BIFF8) ? 4 : 3) * (bArea ? 2 : 1) ); mxStack->pushOperand( createRef( getErrorName( BIFF_ERR_REF ) ), rTokClass ); } void FormulaObject::dumpRef3dToken( const OUString& rTokClass, bool bNameMode ) { OUString aRef = dumpTokenRefTabIdxs(); TokenAddress aPos = dumpTokenAddress( bNameMode ); writeTokenAddress3dItem( "addr", aRef, aPos, bNameMode ); mxStack->pushOperand( mxOut->getLastItemValue(), rTokClass ); } void FormulaObject::dumpArea3dToken( const OUString& rTokClass, bool bNameMode ) { OUString aRef = dumpTokenRefTabIdxs(); TokenRange aRange = dumpTokenRange( bNameMode ); writeTokenRange3dItem( "range", aRef, aRange, bNameMode ); mxStack->pushOperand( mxOut->getLastItemValue(), rTokClass ); } void FormulaObject::dumpRefErr3dToken( const OUString& rTokClass, bool bArea ) { OUString aRef = dumpTokenRefTabIdxs(); dumpUnused( ((getBiff() == BIFF8) ? 4 : 3) * (bArea ? 2 : 1) ); mxStack->pushOperand( aRef + getErrorName( BIFF_ERR_REF ), rTokClass ); } void FormulaObject::dumpMemFuncToken( const OUString& /*rTokClass*/ ) { dumpDec< sal_uInt16, sal_uInt8 >( getBiff() != BIFF2, "size" ); } void FormulaObject::dumpMemAreaToken( const OUString& rTokClass, bool bAddData ) { dumpUnused( (getBiff() == BIFF2) ? 3 : 4 ); dumpMemFuncToken( rTokClass ); if( bAddData ) maAddData.push_back( ADDDATA_MEMAREA ); } void FormulaObject::dumpExpToken( const String& rName ) { Address aPos; aPos.mnRow = dumpDec< sal_uInt16 >( "row" ); aPos.mnCol = dumpDec< sal_uInt16, sal_uInt8 >( getBiff() != BIFF2, "col" ); writeAddressItem( "base-addr", aPos ); OUStringBuffer aOp( rName ); StringHelper::appendIndex( aOp, mxOut->getLastItemValue() ); mxStack->pushOperand( aOp.makeStringAndClear() ); } void FormulaObject::dumpUnaryOpToken( const String& rLOp, const String& rROp ) { mxStack->pushUnaryOp( rLOp, rROp ); } void FormulaObject::dumpBinaryOpToken( const String& rOp ) { mxStack->pushBinaryOp( rOp ); } void FormulaObject::dumpFuncToken( const OUString& rTokClass ) { sal_uInt16 nFuncId = readFuncId(); const FunctionInfo* pFuncInfo = 0; OUString aFuncName = writeFuncIdItem( nFuncId, &pFuncInfo ); if( pFuncInfo && (pFuncInfo->mnMinParamCount == pFuncInfo->mnMaxParamCount) ) mxStack->pushFuncOp( aFuncName, rTokClass, pFuncInfo->mnMinParamCount ); else mxStack->setError(); } void FormulaObject::dumpFuncVarToken( const OUString& rTokClass ) { sal_uInt8 nParamCount; *mxStrm >> nParamCount; sal_uInt16 nFuncId = readFuncId(); bool bCmd = getFlag( nFuncId, BIFF_TOK_FUNCVAR_CMD ); if( bCmd ) writeHexItem( "param-count", nParamCount, "PARAMCOUNT-CMD" ); else writeDecItem( "param-count", nParamCount ); OUString aFuncName = writeFuncIdItem( nFuncId ); if( bCmd && getFlag( nParamCount, BIFF_TOK_FUNCVAR_CMDPROMPT ) ) { aFuncName += OUString( OOX_DUMP_CMDPROMPT ); nParamCount &= BIFF_TOK_FUNCVAR_COUNTMASK; } mxStack->pushFuncOp( aFuncName, rTokClass, nParamCount ); } void FormulaObject::dumpCmdToken( const OUString& rTokClass ) { sal_uInt8 nParamCount = dumpDec< sal_uInt8 >( "param-count", "PARAMCOUNT-CMD" ); sal_uInt16 nCmdId = readFuncId() | BIFF_TOK_FUNCVAR_CMD; OUString aFuncName = writeFuncIdItem( nCmdId ); if( getFlag( nParamCount, BIFF_TOK_FUNCVAR_CMDPROMPT ) ) { aFuncName += OUString( OOX_DUMP_CMDPROMPT ); nParamCount &= BIFF_TOK_FUNCVAR_COUNTMASK; } mxStack->pushFuncOp( aFuncName, rTokClass, nParamCount ); } void FormulaObject::dumpSheetToken() { dumpUnused( (getBiff() == BIFF2) ? 4 : 6 ); maRefPrefix = dumpTokenRefIdx(); } void FormulaObject::dumpEndSheetToken() { dumpUnused( (getBiff() == BIFF2) ? 3 : 4 ); maRefPrefix = OUString(); } bool FormulaObject::dumpAttrToken() { bool bValid = true; bool bBiff2 = getBiff() == BIFF2; sal_uInt8 nType = dumpHex< sal_uInt8 >( "type", mxAttrTypes ); switch( nType ) { case BIFF_TOK_ATTR_VOLATILE: dumpUnused( bBiff2 ? 1 : 2 ); break; case BIFF_TOK_ATTR_IF: dumpDec< sal_uInt16, sal_uInt8 >( !bBiff2, "skip" ); break; case BIFF_TOK_ATTR_CHOOSE: { sal_uInt16 nCount = dumpDec< sal_uInt16, sal_uInt8 >( !bBiff2, "choices" ); mxOut->resetItemIndex(); for( sal_uInt16 nIdx = 0; nIdx < nCount; ++nIdx ) dumpDec< sal_uInt16, sal_uInt8 >( !bBiff2, "#skip" ); dumpDec< sal_uInt16, sal_uInt8 >( !bBiff2, "skip-err" ); } break; case 0: // in array formulas and defined names, the skip-bit may be 0 case BIFF_TOK_ATTR_SKIP: dumpDec< sal_uInt16, sal_uInt8 >( !bBiff2, "skip" ); break; case BIFF_TOK_ATTR_SUM: dumpUnused( bBiff2 ? 1 : 2 ); mxStack->pushFuncOp( CREATE_OUSTRING( "SUM" ), OUString( OOX_DUMP_BASECLASS ), 1 ); break; case BIFF_TOK_ATTR_ASSIGN: dumpUnused( bBiff2 ? 1 : 2 ); break; case BIFF_TOK_ATTR_SPACE: case BIFF_TOK_ATTR_SPACE | BIFF_TOK_ATTR_VOLATILE: switch( getBiff() ) { case BIFF2: bValid = false; break; case BIFF3: dumpDec< sal_uInt16 >( "leading-spaces" ); break; case BIFF4: case BIFF5: case BIFF8: dumpDec< sal_uInt8 >( "char-type", mxSpTypes ); dumpDec< sal_uInt8 >( "char-count" ); break; case BIFF_UNKNOWN: break; } break; default: bValid = false; } return bValid; } bool FormulaObject::dumpNlrToken() { const OUString aRefClass = cfg().getName( mxClasses, BIFF_TOKCLASS_REF ); const OUString aValClass = cfg().getName( mxClasses, BIFF_TOKCLASS_VAL ); bool bValid = true; sal_uInt8 nType = dumpHex< sal_uInt8 >( "type", mxNlrTypes ); switch( nType ) { case BIFF_TOK_NLR_ERR: dumpNlrErrToken(); break; case BIFF_TOK_NLR_ROWR: dumpNlrColRowToken( aRefClass, false ); break; case BIFF_TOK_NLR_COLR: dumpNlrColRowToken( aRefClass, false ); break; case BIFF_TOK_NLR_ROWV: dumpNlrColRowToken( aValClass, false ); break; case BIFF_TOK_NLR_COLV: dumpNlrColRowToken( aValClass, false ); break; case BIFF_TOK_NLR_RANGE: dumpNlrRangeToken( aRefClass, false ); break; case BIFF_TOK_NLR_SRANGE: dumpNlrRangeToken( aRefClass, true ); break; case BIFF_TOK_NLR_SROWR: dumpNlrColRowToken( aRefClass, true ); break; case BIFF_TOK_NLR_SCOLR: dumpNlrColRowToken( aRefClass, true ); break; case BIFF_TOK_NLR_SROWV: dumpNlrColRowToken( aValClass, true ); break; case BIFF_TOK_NLR_SCOLV: dumpNlrColRowToken( aValClass, true ); break; case BIFF_TOK_NLR_RANGEERR: dumpNlrRangeErrToken(); break; default: bValid = false; } return bValid; } void FormulaObject::dumpNlrErrToken() { dumpDec< sal_uInt32 >( "delname-idx" ); mxStack->pushOperand( lclCreateNlr( getErrorName( BIFF_ERR_NAME ) ) ); } void FormulaObject::dumpNlrColRowToken( const OUString& rTokClass, bool bAddData ) { if( bAddData ) { dumpUnused( 4 ); mxStack->pushOperand( createPlaceHolder(), rTokClass ); maAddData.push_back( ADDDATA_NLR ); } else { TokenAddress aPos = dumpTokenAddress( false ); writeInfoItem( "addr", lclCreateNlr( aPos ) ); mxStack->pushOperand( mxOut->getLastItemValue(), rTokClass ); } } void FormulaObject::dumpNlrRangeToken( const OUString& rTokClass, bool bAddData ) { if( bAddData ) { dumpUnused( 4 ); mxStack->pushOperand( createPlaceHolder(), rTokClass ); maAddData.push_back( ADDDATA_NLR ); } else { TokenAddress aPos = dumpTokenAddress( false ); writeInfoItem( "addr", lclCreateNlr( aPos ) ); mxStack->pushOperand( mxOut->getLastItemValue(), rTokClass ); } dumpUnknown( 1 ); dumpRange( "target-range" ); } void FormulaObject::dumpNlrRangeErrToken() { dumpDec< sal_uInt32 >( "delname-idx" ); dumpUnused( 9 ); mxStack->pushOperand( lclCreateNlr( getErrorName( BIFF_ERR_NAME ) ) ); } void FormulaObject::dumpAddTokenData() { mxOut->resetItemIndex(); for( AddDataTypeVec::const_iterator aIt = maAddData.begin(), aEnd = maAddData.end(); aIt != aEnd; ++aIt ) { AddDataType eType = *aIt; { ItemGuard aItem( mxOut, "#add-data" ); switch( eType ) { case ADDDATA_NLR: mxOut->writeAscii( "tNlr" ); break; case ADDDATA_ARRAY: mxOut->writeAscii( "tArray" ); break; case ADDDATA_MEMAREA: mxOut->writeAscii( "tMemArea" ); break; } } size_t nIdx = aIt - maAddData.begin(); IndentGuard aIndGuard( mxOut ); switch( eType ) { case ADDDATA_NLR: dumpAddDataNlr( nIdx ); break; case ADDDATA_ARRAY: dumpAddDataArray( nIdx ); break; case ADDDATA_MEMAREA: dumpAddDataMemArea( nIdx ); break; } } } void FormulaObject::dumpAddDataNlr( size_t nIdx ) { sal_uInt32 nFlags = dumpHex< sal_uInt32 >( "flags", "NLRADDFLAGS" ); sal_uInt32 nCount = nFlags & BIFF_TOK_NLR_ADDMASK; OUStringBuffer aBuffer; for( sal_uInt32 nPos = 0; nPos < nCount; ++nPos ) { Address aPos; readAddress( aPos ); OUStringBuffer aAddr; StringHelper::appendAddress( aAddr, aPos ); StringHelper::appendToken( aBuffer, aAddr.makeStringAndClear(), OOX_DUMP_LISTSEP ); } OUString aAddrList = aBuffer.makeStringAndClear(); writeInfoItem( "stacked-positions", aAddrList ); mxStack->replaceOnTop( createPlaceHolder( nIdx ), lclCreateNlr( aAddrList ) ); } void FormulaObject::dumpAddDataArray( size_t nIdx ) { sal_uInt32 nCols, nRows; dumpConstArrayHeader( nCols, nRows ); OUStringBuffer aOp; TableGuard aTabGuard( mxOut, 17 ); for( sal_uInt32 nRow = 0; nRow < nRows; ++nRow ) { OUStringBuffer aArrayLine; for( sal_uInt32 nCol = 0; nCol < nCols; ++nCol ) StringHelper::appendToken( aArrayLine, dumpConstValue( OOX_DUMP_FMLASTRQUOTE ), OOX_DUMP_LISTSEP ); StringHelper::appendToken( aOp, aArrayLine.makeStringAndClear(), OOX_DUMP_ARRAYSEP ); } StringHelper::enclose( aOp, '{', '}' ); mxStack->replaceOnTop( createPlaceHolder( nIdx ), aOp.makeStringAndClear() ); } void FormulaObject::dumpAddDataMemArea( size_t /*nIdx*/ ) { dumpRangeList( EMPTY_STRING, getBiff() == BIFF8 ); } // ============================================================================ // ============================================================================ RecordStreamObject::~RecordStreamObject() { } void RecordStreamObject::construct( const ObjectBase& rParent, const BinaryInputStreamRef& rxStrm, BiffType eBiff, const OUString& rSysFileName ) { BiffObjectBase::construct( rParent, rxStrm, eBiff, rSysFileName ); if( BiffObjectBase::implIsValid() ) mxFmlaObj.reset( new FormulaObject( *this ) ); } bool RecordStreamObject::implIsValid() const { return isValid( mxFmlaObj ) && BiffObjectBase::implIsValid(); } // ============================================================================ WorkbookStreamObject::WorkbookStreamObject( const ObjectBase& rParent, const BinaryInputStreamRef& rxStrm, const OUString& rSysFileName ) { if( rxStrm.get() ) { BiffType eBiff = BiffDetector::detectStreamBiffVersion( *rxStrm ); RecordStreamObject::construct( rParent, rxStrm, eBiff, rSysFileName ); if( RecordStreamObject::implIsValid() ) { Config& rCfg = cfg(); mxColors = rCfg.getNameList( "COLORS" ); mxBorderStyles = rCfg.getNameList( "BORDERSTYLES" ); mxFillPatterns = rCfg.getNameList( "FILLPATTERNS" ); mnPTRowFields = 0; mnPTColFields = 0; mnPTRowColItemsIdx = 0; mbHasDff = false; initializePerSheet(); } } } WorkbookStreamObject::~WorkbookStreamObject() { if( WorkbookStreamObject::implIsValid() ) { Config& rCfg = cfg(); rCfg.eraseNameList( "FONTNAMES" ); rCfg.eraseNameList( "FORMATS" ); } } void WorkbookStreamObject::implDumpRecordBody() { BiffInputStream& rStrm = getBiffStream(); sal_uInt16 nRecId = rStrm.getRecId(); sal_Int64 nRecSize = rStrm.size(); BiffType eBiff = getBiff(); switch( nRecId ) { case BIFF2_ID_ARRAY: case BIFF3_ID_ARRAY: dumpRange( "array-range", false ); dumpHex< sal_uInt16, sal_uInt8 >( eBiff != BIFF2, "flags", "ARRAY-FLAGS" ); if( eBiff >= BIFF5 ) dumpUnused( 4 ); getFormulaDumper().dumpCellFormula(); break; case BIFF2_ID_BLANK: case BIFF3_ID_BLANK: dumpCellHeader( nRecId == BIFF2_ID_BLANK ); break; case BIFF2_ID_BOF: case BIFF3_ID_BOF: case BIFF4_ID_BOF: case BIFF5_ID_BOF: dumpHex< sal_uInt16 >( "bof-type", "BOF-BIFFTYPE" ); dumpHex< sal_uInt16 >( "sheet-type", "BOF-SHEETTYPE" ); if( nRecSize >= 6 ) dumpDec< sal_uInt16 >( "build-id" ); if( nRecSize >= 8 ) dumpDec< sal_uInt16 >( "build-year" ); if( nRecSize >= 12 ) dumpHex< sal_uInt32 >( "history-flags", "BOF-HISTORY-FLAGS" ); if( nRecSize >= 16 ) dumpHex< sal_uInt32 >( "lowest-version", "BOF-LOWESTVERSION-FLAGS" ); if( (eBiff == BIFF4) && (getLastRecId() != BIFF_ID_OBJ) ) initializePerSheet(); break; case BIFF_ID_BOOKEXT: dumpFrHeader( true, true ); dumpDec< sal_uInt32 >( "rec-size" ); dumpHex< sal_uInt32 >( "flags-1", "BOOKEXT-FLAGS1" ); if( rStrm.getRemaining() > 0 ) dumpHex< sal_uInt8 >( "flags-2", "BOOKEXT-FLAGS2" ); if( rStrm.getRemaining() > 0 ) dumpHex< sal_uInt8 >( "flags-3", "BOOKEXT-FLAGS3" ); break; case BIFF2_ID_BOOLERR: case BIFF3_ID_BOOLERR: dumpCellHeader( nRecId == BIFF2_ID_BOOLERR ); dumpBoolErr(); break; case BIFF_ID_CFHEADER: dumpDec< sal_uInt16 >( "rule-count" ); dumpHex< sal_uInt16 >( "flags", "CFHEADER-FLAGS" ); dumpRange( "bounding-range" ); dumpRangeList(); break; case BIFF_ID_CFRULE: { dumpDec< sal_uInt8 >( "type", "CFRULE-TYPE" ); dumpDec< sal_uInt8 >( "operator", "CFRULE-OPERATOR" ); sal_uInt16 nFmla1Size = dumpDec< sal_uInt16 >( "formula1-size" ); sal_uInt16 nFmla2Size = dumpDec< sal_uInt16 >( "formula2-size" ); dumpCfRuleProp(); if( nFmla1Size > 0 ) getFormulaDumper().dumpNameFormula( "formula1", nFmla1Size ); if( nFmla2Size > 0 ) getFormulaDumper().dumpNameFormula( "formula2", nFmla2Size ); } break; case BIFF_ID_CFRULE12: { dumpFrHeader( true, true ); dumpDec< sal_uInt8 >( "type", "CFRULE12-TYPE" ); dumpDec< sal_uInt8 >( "operator", "CFRULE-OPERATOR" ); sal_uInt16 nFmla1Size = dumpDec< sal_uInt16 >( "formula1-size" ); sal_uInt16 nFmla2Size = dumpDec< sal_uInt16 >( "formula2-size" ); dumpDxf12Prop(); if( nFmla1Size > 0 ) getFormulaDumper().dumpNameFormula( "formula1", nFmla1Size ); if( nFmla2Size > 0 ) getFormulaDumper().dumpNameFormula( "formula2", nFmla2Size ); getFormulaDumper().dumpNameFormula( "active-formula" ); dumpHex< sal_uInt8 >( "flags", "CFRULE12-FLAGS" ); dumpDec< sal_uInt16 >( "priority" ); dumpCfRule12Param( dumpDec< sal_uInt16 >( "sub-type", "CFRULE12-SUBTYPE" ) ); } break; case BIFF_ID_CFRULEEXT: dumpFrHeader( true, true ); dumpBool< sal_uInt32 >( "cfrule12-follows" ); dumpDec< sal_uInt16 >( "cfheader-id" ); if( rStrm.getRemaining() >= 25 ) { dumpDec< sal_uInt16 >( "cfrule-idx" ); dumpDec< sal_uInt8 >( "operator", "CFRULE-OPERATOR" ); sal_uInt8 nSubType = dumpDec< sal_uInt8 >( "sub-type", "CFRULE12-SUBTYPE" ); dumpDec< sal_uInt16 >( "priority" ); dumpHex< sal_uInt8 >( "flags", "CFRULEEXT-FLAGS" ); if( dumpBoolean( "has-dxf-data" ) ) dumpDxf12Prop(); dumpCfRule12Param( nSubType ); } break; case BIFF_ID_CH3DDATAFORMAT: dumpDec< sal_uInt8 >( "base", "CH3DDATAFORMAT-BASE" ); dumpDec< sal_uInt8 >( "top", "CH3DDATAFORMAT-TOP" ); break; case BIFF_ID_CHAREAFORMAT: dumpColorABGR( "fg-color" ); dumpColorABGR( "bg-color" ); dumpPatternIdx(); dumpHex< sal_uInt16 >( "flags", "CHAREAFORMAT-FLAGS" ); if( eBiff == BIFF8 ) dumpColorIdx( "fg-color-idx" ); if( eBiff == BIFF8 ) dumpColorIdx( "bg-color-idx" ); break; case BIFF_ID_CHAXESSET: dumpDec< sal_uInt16 >( "axesset-id", "CHAXESSET-ID" ); dumpRect< sal_Int32 >( "inner-plotarea-pos", (eBiff <= BIFF4) ? "CONV-TWIP-TO-CM" : "" ); break; case BIFF_ID_CHAXIS: dumpDec< sal_uInt16 >( "axis-type", "CHAXIS-TYPE" ); if( eBiff <= BIFF4 ) dumpRect< sal_Int32 >( "position", "CONV-TWIP-TO-CM" ); else dumpUnused( 16 ); break; case BIFF_ID_CHBAR: dumpDec< sal_Int16 >( "overlap", "CONV-PERCENT-NEG" ); dumpDec< sal_Int16 >( "gap", "CONV-PERCENT" ); dumpHex< sal_uInt16 >( "flags", "CHBAR-FLAGS" ); break; case BIFF_ID_CHCHART: dumpRect< sal_Int32 >( "chart-frame", "CONV-PT1616-TO-CM", FORMATTYPE_FIX ); break; case BIFF_ID_CHCHART3D: dumpDec< sal_uInt16 >( "rotation-angle", "CONV-DEG" ); dumpDec< sal_Int16 >( "elevation-angle", "CONV-DEG" ); dumpDec< sal_uInt16 >( "eye-distance" ); dumpDec< sal_uInt16 >( "relative-height", "CONV-PERCENT" ); dumpDec< sal_uInt16 >( "relative-depth", "CONV-PERCENT" ); dumpDec< sal_uInt16 >( "depth-gap", "CONV-PERCENT" ); dumpHex< sal_uInt16 >( "flags", "CHCHART3D-FLAGS" ); break; case BIFF_ID_CHDATAFORMAT: dumpDec< sal_Int16 >( "point-idx", "CHDATAFORMAT-POINTIDX" ); dumpDec< sal_Int16 >( "series-idx" ); if( eBiff >= BIFF5 ) dumpDec< sal_Int16 >( "format-idx", "CHDATAFORMAT-FORMATIDX" ); if( eBiff >= BIFF5 ) dumpHex< sal_uInt16 >( "flags", "CHDATAFORMAT-FLAGS" ); break; case BIFF_ID_CHDATERANGE: dumpDec< sal_uInt16 >( "minimum-date" ); dumpDec< sal_uInt16 >( "maximum-date" ); dumpDec< sal_uInt16 >( "major-unit-value" ); dumpDec< sal_uInt16 >( "major-unit", "CHDATERANGE-UNIT" ); dumpDec< sal_uInt16 >( "minor-unit-value" ); dumpDec< sal_uInt16 >( "minor-unit", "CHDATERANGE-UNIT" ); dumpDec< sal_uInt16 >( "base-unit", "CHDATERANGE-UNIT" ); dumpDec< sal_uInt16 >( "axis-crossing-date" ); dumpHex< sal_uInt16 >( "flags", "CHDATERANGE-FLAGS" ); break; case BIFF_ID_CHECKCOMPAT: dumpFrHeader( true, true ); dumpBool< sal_uInt32 >( "check-compatibility" ); break; case BIFF_ID_CHESCHERFORMAT: dumpEmbeddedDff(); break; case BIFF_ID_CHFRAME: dumpDec< sal_uInt16 >( "format", "CHFRAME-FORMAT" ); dumpHex< sal_uInt16 >( "flags", "CHFRAME-FLAGS" ); break; case BIFF_ID_CHFRAMEPOS: dumpDec< sal_uInt16 >( "tl-mode", "CHFRAMEPOS-POSMODE" ); dumpDec< sal_uInt16 >( "br-mode", "CHFRAMEPOS-POSMODE" ); dumpRectWithGaps< sal_Int16 >( "position", 2 ); break; case BIFF_ID_CHFRBLOCKBEGIN: dumpFrHeader( true, false ); dumpDec< sal_uInt16 >( "type", "CHFRBLOCK-TYPE" ); dumpDec< sal_uInt16 >( "context" ); dumpDec< sal_uInt16 >( "value-1" ); dumpDec< sal_uInt16 >( "value-2" ); break; case BIFF_ID_CHFRBLOCKEND: dumpFrHeader( true, false ); dumpDec< sal_uInt16 >( "type", "CHFRBLOCK-TYPE" ); if( rStrm.getRemaining() >= 6 ) dumpUnused( 6 ); break; case BIFF_ID_CHFRCATEGORYPROPS: dumpFrHeader( true, false ); dumpDec< sal_uInt16 >( "label-offset", "CONV-PERCENT" ); dumpDec< sal_uInt16 >( "alignment", "CHFRCATEGORYPROPS-ALIGN" ); dumpHex< sal_uInt16 >( "flags", "CHFRCATEGORYPROPS-FLAGS" ); break; case BIFF_ID_CHFREXTPROPS: { dumpFrHeader( true, true ); dumpDec< sal_uInt32 >( "data-size" ); dumpDec< sal_uInt8 >( "version" ); dumpUnused( 1 ); dumpDec< sal_uInt16 >( "parent", "CHFREXTPROPS-PARENT" ); dumpChFrExtProps(); dumpUnused( 4 ); } break; case BIFF_ID_CHFRINFO: { dumpFrHeader( true, false ); dumpDec< sal_uInt8 >( "creator", "CHFRINFO-APPVERSION" ); dumpDec< sal_uInt8 >( "writer", "CHFRINFO-APPVERSION" ); sal_uInt16 nCount = dumpDec< sal_uInt16 >( "rec-range-count" ); mxOut->resetItemIndex(); for( sal_uInt16 nIndex = 0; !rStrm.isEof() && (nIndex < nCount); ++nIndex ) dumpHexPair< sal_uInt16 >( "#rec-range", '-' ); } break; case BIFF_ID_CHFRLABELPROPS: dumpFrHeader( true, true ); dumpHex< sal_uInt16 >( "flags", "CHFRLABELPROPS-FLAGS" ); dumpUniString( "separator", BIFF_STR_SMARTFLAGS ); break; case BIFF_ID_CHFRLAYOUT: dumpFrHeader( true, true ); dumpHex< sal_uInt32 >( "checksum" ); dumpHex< sal_uInt16 >( "flags", "CHFRLAYOUT-FLAGS" ); dumpDec< sal_uInt16 >( "mode-x", "CHFRLAYOUT-MODE" ); dumpDec< sal_uInt16 >( "mode-y", "CHFRLAYOUT-MODE" ); dumpDec< sal_uInt16 >( "mode-w", "CHFRLAYOUT-MODE" ); dumpDec< sal_uInt16 >( "mode-h", "CHFRLAYOUT-MODE" ); dumpRect< double >( "position" ); dumpUnused( 2 ); break; case BIFF_ID_CHFRPLOTAREALAYOUT: dumpFrHeader( true, true ); dumpHex< sal_uInt32 >( "checksum" ); dumpHex< sal_uInt16 >( "flags", "CHFRPLOTAREALAYOUT-FLAGS" ); dumpRect< sal_Int16 >( "position" ); dumpDec< sal_uInt16 >( "mode-x", "CHFRLAYOUT-MODE" ); dumpDec< sal_uInt16 >( "mode-y", "CHFRLAYOUT-MODE" ); dumpDec< sal_uInt16 >( "mode-w", "CHFRLAYOUT-MODE" ); dumpDec< sal_uInt16 >( "mode-h", "CHFRLAYOUT-MODE" ); dumpRect< double >( "position" ); dumpUnused( 2 ); break; case BIFF_ID_CHFRSHAPEPROPS: dumpFrHeader( true, true ); dumpDec< sal_uInt16 >( "context" ); dumpUnused( 2 ); dumpHex< sal_uInt32 >( "checksum" ); dumpDec< sal_uInt32 >( "xml-size" ); break; case BIFF_ID_CHFRTEXTPROPS: dumpFrHeader( true, true ); dumpHex< sal_uInt32 >( "checksum" ); dumpDec< sal_uInt32 >( "xml-size" ); break; case BIFF_ID_CHFRUNITPROPS: dumpFrHeader( true, false ); dumpDec< sal_Int16 >( "preset", "CHFRUNITPROPS-PRESET" ); dumpDec< double >( "unit" ); dumpHex< sal_uInt16 >( "flags", "CHFRUNITPROPS-FLAGS" ); break; case BIFF_ID_CHFRWRAPPER: dumpFrHeader( true, false ); break; case BIFF_ID_CHLABELRANGE: dumpDec< sal_uInt16 >( "axis-crossing" ); dumpDec< sal_uInt16 >( "label-frequency" ); dumpDec< sal_uInt16 >( "tick-frequency" ); dumpHex< sal_uInt16 >( "flags", "CHLABELRANGE-FLAGS" ); break; case BIFF_ID_CHLEGEND: dumpRect< sal_Int32 >( "position", (eBiff <= BIFF4) ? "CONV-TWIP-TO-CM" : "" ); dumpDec< sal_uInt8 >( "docked-pos", "CHLEGEND-DOCKPOS" ); dumpDec< sal_uInt8 >( "spacing", "CHLEGEND-SPACING" ); dumpHex< sal_uInt16 >( "flags", "CHLEGEND-FLAGS" ); break; case BIFF_ID_CHLINEFORMAT: dumpColorABGR(); dumpDec< sal_uInt16 >( "line-type", "CHLINEFORMAT-LINETYPE" ); dumpDec< sal_Int16 >( "line-weight", "CHLINEFORMAT-LINEWEIGHT" ); dumpHex< sal_uInt16 >( "flags", "CHLINEFORMAT-FLAGS" ); if( eBiff == BIFF8 ) dumpColorIdx(); break; case BIFF_ID_CHMARKERFORMAT: dumpColorABGR( "border-color" ); dumpColorABGR( "fill-color" ); dumpDec< sal_uInt16 >( "marker-type", "CHMARKERFORMAT-TYPE" ); dumpHex< sal_uInt16 >( "flags", "CHMARKERFORMAT-FLAGS" ); if( eBiff == BIFF8 ) dumpColorIdx( "border-color-idx" ); if( eBiff == BIFF8 ) dumpColorIdx( "fill-color-idx" ); if( eBiff == BIFF8 ) dumpDec< sal_Int32 >( "marker-size", "CONV-TWIP-TO-PT" ); break; case BIFF_ID_CHOBJECTLINK: dumpDec< sal_uInt16 >( "link-target", "CHOBJECTLINK-TARGET" ); dumpDec< sal_Int16 >( "series-idx" ); dumpDec< sal_Int16 >( "point-idx", "CHOBJECTLINK-POINT" ); break; case BIFF_ID_CHPICFORMAT: dumpDec< sal_uInt16 >( "bitmap-mode", "CHPICFORMAT-BITMAP-MODE" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "flags", "CHPICFORMAT-FLAGS" ); dumpDec< double >( "scaling-factor" ); break; case BIFF_ID_CHPIE: dumpDec< sal_uInt16 >( "angle", "CONV-DEG" ); if( eBiff >= BIFF5 ) dumpDec< sal_uInt16 >( "hole-size" ); if( eBiff >= BIFF8 ) dumpHex< sal_uInt16 >( "flags", "CHPIE-FLAGS" ); break; case BIFF_ID_CHPIVOTFLAGS: dumpRepeatedRecId(); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "flags", "CHPIVOTFLAGS-FLAGS" ); break; case BIFF8_ID_CHPIVOTREF: dumpRepeatedRecId(); dumpUnused( 4 ); dumpUniString( "ref", BIFF_STR_8BITLENGTH ); break; case BIFF_ID_CHPLOTGROWTH: dumpFix< sal_Int32 >( "horizontal-growth" ); dumpFix< sal_Int32 >( "vertical-growth" ); break; case BIFF_ID_CHPROPERTIES: dumpHex< sal_uInt16 >( "flags", "CHPROPERTIES-FLAGS" ); dumpDec< sal_uInt8 >( "empty-cells", "CHPROPERTIES-EMPTYCELLS" ); break; case BIFF_ID_CHSCATTER: if( eBiff == BIFF8 ) dumpDec< sal_uInt16 >( "bubble-size", "CONV-PERCENT" ); if( eBiff == BIFF8 ) dumpDec< sal_uInt16 >( "size-type", "CHSCATTER-SIZETYPE" ); if( eBiff == BIFF8 ) dumpHex< sal_uInt16 >( "flags", "CHSCATTER-FLAGS" ); break; case BIFF_ID_CHSERERRORBAR: dumpDec< sal_uInt8 >( "type", "CHSERERRORBAR-TYPE" ); dumpDec< sal_uInt8 >( "source", "CHSERERRORBAR-SOURCE" ); dumpBool< sal_uInt8 >( "draw-t-shape" ); dumpBool< sal_uInt8 >( "draw-line" ); dumpDec< double >( "value" ); dumpDec< sal_uInt16 >( "custom-count" ); break; case BIFF_ID_CHSERIES: dumpDec< sal_uInt16 >( "categories-type", "CHSERIES-TYPE" ); dumpDec< sal_uInt16 >( "values-type", "CHSERIES-TYPE" ); dumpDec< sal_uInt16 >( "categories-count" ); dumpDec< sal_uInt16 >( "values-count" ); if( eBiff == BIFF8 ) dumpDec< sal_uInt16 >( "bubbles-type", "CHSERIES-TYPE" ); if( eBiff == BIFF8 ) dumpDec< sal_uInt16 >( "bubbles-count" ); break; case BIFF_ID_CHSERTRENDLINE: switch( dumpDec< sal_uInt8 >( "type", "CHSERTRENDLINE-TYPE" ) ) { case 0: dumpDec< sal_uInt8 >( "order" ); break; case 4: dumpDec< sal_uInt8 >( "average-period" ); break; default: dumpUnused( 1 ); } dumpDec< double >( "intercept" ); dumpBool< sal_uInt8 >( "show-equation" ); dumpBool< sal_uInt8 >( "show-r-sqrare" ); dumpDec< double >( "forecast-forward" ); dumpDec< double >( "forecast-backward" ); break; case BIFF_ID_CHSOURCELINK: dumpDec< sal_uInt8 >( "link-target", "CHSOURCELINK-TARGET" ); dumpDec< sal_uInt8 >( "link-type", "CHSOURCELINK-TYPE" ); dumpHex< sal_uInt16 >( "flags", "CHSOURCELINK-FLAGS" ); dumpFormatIdx(); getFormulaDumper().dumpNameFormula(); break; case BIFF_ID_CHSTRING: dumpDec< sal_uInt16 >( "text-type", "CHSTRING-TYPE" ); dumpString( "text", BIFF_STR_8BITLENGTH, BIFF_STR_8BITLENGTH ); break; case BIFF_ID_CHTEXT: dumpDec< sal_uInt8 >( "horizontal-align", "CHTEXT-HORALIGN" ); dumpDec< sal_uInt8 >( "vertical-align", "CHTEXT-VERALIGN" ); dumpDec< sal_uInt16 >( "fill-mode", "CHTEXT-FILLMODE" ); dumpColorABGR(); dumpRect< sal_Int32 >( "position", (eBiff <= BIFF4) ? "CONV-TWIP-TO-CM" : "" ); dumpHex< sal_uInt16 >( "flags-1", "CHTEXT-FLAGS1" ); if( eBiff == BIFF8 ) dumpColorIdx(); if( eBiff == BIFF8 ) dumpHex< sal_uInt16 >( "flags-2", "CHTEXT-FLAGS2" ); if( eBiff == BIFF8 ) dumpDec< sal_uInt16 >( "rotation", "TEXTROTATION" ); break; case BIFF_ID_CHTICK: dumpDec< sal_uInt8 >( "major-ticks", "CHTICK-TYPE" ); dumpDec< sal_uInt8 >( "minor-ticks", "CHTICK-TYPE" ); dumpDec< sal_uInt8 >( "label-position", "CHTICK-LABELPOS" ); dumpDec< sal_uInt8 >( "fill-mode", "CHTEXT-FILLMODE" ); dumpColorABGR( "label-color" ); dumpUnused( 16 ); dumpHex< sal_uInt16 >( "flags", "CHTICK-FLAGS" ); if( eBiff == BIFF8 ) dumpColorIdx( "label-color-idx" ); if( eBiff == BIFF8 ) dumpDec< sal_uInt16 >( "label-rotation", "TEXTROTATION" ); break; case BIFF_ID_CHTYPEGROUP: dumpUnused( 16 ); dumpHex< sal_uInt16 >( "flags", "CHTYPEGROUP-FLAGS" ); if( eBiff >= BIFF5 ) dumpDec< sal_uInt16 >( "group-idx" ); break; case BIFF_ID_CHVALUERANGE: dumpDec< double >( "minimum" ); dumpDec< double >( "maximum" ); dumpDec< double >( "major-inc" ); dumpDec< double >( "minor-inc" ); dumpDec< double >( "axis-crossing" ); dumpHex< sal_uInt16 >( "flags", "CHVALUERANGE-FLAGS" ); break; case BIFF_ID_CODENAME: dumpUniString( "codename" ); break; case BIFF_ID_CODEPAGE: getBiffData().setTextEncoding( dumpCodePage() ); mbHasCodePage = true; break; case BIFF_ID_COLINFO: dumpColRange(); dumpDec< sal_uInt16 >( "col-width", "CONV-COLWIDTH" ); dumpXfIdx( "xf-idx" ); dumpHex< sal_uInt16 >( "flags", "COLINFO-FLAGS" ); dumpUnused( 2 ); break; case BIFF_ID_COLUMNDEFAULT: mxOut->resetItemIndex(); for( sal_Int32 nCol = 0, nCount = dumpColRange(); nCol < nCount; ++nCol ) dumpXfIdx( "#xf-idx", true ); dumpUnused( 2 ); break; case BIFF_ID_COLWIDTH: dumpColRange( EMPTY_STRING, false ); dumpDec< sal_uInt16 >( "col-width", "CONV-COLWIDTH" ); break; case BIFF_ID_COMPRESSPICS: dumpFrHeader( true, true ); dumpBool< sal_uInt32 >( "recommend-compress-pics" ); break; case BIFF_ID_CONNECTION: { dumpFrHeader( true, false ); sal_uInt16 nType = dumpDec< sal_uInt16 >( "data-source-type", "CONNECTION-SOURCETYPE" ); sal_uInt16 nFlags1 = dumpHex< sal_uInt16 >( "flags", "CONNECTION-FLAGS" ); dumpDec< sal_uInt16 >( "param-count" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "querytable-flags", "QUERYTABLESETTINGS-FLAGS" ); switch( nType ) { case 4: dumpHex< sal_uInt16 >( "html-flags", "QUERYTABLESETTINGS-HTML-FLAGS" ); break; case 5: dumpHex< sal_uInt16 >( "oledb-flags", "QUERYTABLESETTINGS-OLEDB-FLAGS" ); break; case 7: dumpHex< sal_uInt16 >( "ado-flags", "QUERYTABLESETTINGS-ADO-FLAGS" ); break; default: dumpUnused( 2 ); } dumpDec< sal_uInt8 >( "edited-version" ); dumpDec< sal_uInt8 >( "refreshed-version" ); dumpDec< sal_uInt8 >( "min-refresh-version" ); dumpDec< sal_uInt16 >( "refresh-interval", "QUERYTABLESETTINGS-INTERVAL" ); dumpDec< sal_uInt16 >( "html-format", "QUERYTABLESETTINGS-HTMLFORMAT" ); dumpDec< sal_Int32 >( "reconnect-type", "CONNECTION-RECONNECTTYPE" ); dumpDec< sal_uInt8 >( "credentials", "CONNECTION-CREDENTIALS" ); dumpUnused( 1 ); dumpSegmentedUniString( "source-file" ); dumpSegmentedUniString( "source-conn-file" ); dumpSegmentedUniString( "name" ); dumpSegmentedUniString( "description" ); dumpSegmentedUniString( "sso-id" ); if( nFlags1 & 0x0004 ) dumpSegmentedUniString( "table-names" ); if( nFlags1 & 0x0010 ) { break; // TODO: parameter array structure } bool bEscape = false; switch( nType ) { case 1: dumpSegmentedUniString( "connection-string" ); break; case 4: dumpSegmentedUniStringArray( "urls" ); dumpSegmentedUniStringArray( "post-method" ); break; case 5: bEscape = true; break; case 6: bEscape = true; break; } if( bEscape ) break; dumpSegmentedUniStringArray( "sql-command" ); dumpSegmentedUniStringArray( "orig-sql-command" ); dumpSegmentedUniStringArray( "webquery-dialog-url" ); switch( dumpDec< sal_uInt8 >( "linked-object-type", "CONNECTION-LINKEDOBJECTTYPE" ) ) { case 1: dumpSegmentedUniString( "defined-name" ); break; case 2: dumpHex< sal_uInt16 >( "cache-id" ); break; } } break; case BIFF_ID_CONT: if( (eBiff == BIFF8) && (getLastRecId() == BIFF_ID_OBJ) ) dumpEmbeddedDff(); break; case BIFF_ID_COORDLIST: { mxOut->resetItemIndex(); TableGuard aTabGuard( mxOut, 12, 10 ); while( rStrm.getRemaining() >= 4 ) { MultiItemsGuard aMultiGuard( mxOut ); writeEmptyItem( "#point" ); dumpDec< sal_uInt16 >( "x" ); dumpDec< sal_uInt16 >( "y" ); } } break; case BIFF_ID_COUNTRY: dumpDec< sal_uInt16 >( "ui-country", "COUNTRY" ); dumpDec< sal_uInt16 >( "sys-country", "COUNTRY" ); break; case BIFF_ID_CRN: { sal_Int32 nCol2 = dumpColIndex( "last-col-idx", false ); sal_Int32 nCol1 = dumpColIndex( "first-col-idx", false ); sal_Int32 nRow = dumpRowIndex( "row-idx" ); TableGuard aTabGuard( mxOut, 14, 17 ); for( Address aPos( nCol1, nRow ); !rStrm.isEof() && (aPos.mnCol <= nCol2); ++aPos.mnCol ) { MultiItemsGuard aMultiGuard( mxOut ); writeAddressItem( "pos", aPos ); dumpConstValue(); } } break; case BIFF_ID_DCONBINAME: dumpDec< sal_uInt8 >( "builtin-id", "DEFINEDNAME-BUILTINID" ); dumpUnused( 3 ); dumpString( "source-link", BIFF_STR_8BITLENGTH, BIFF_STR_SMARTFLAGS ); break; case BIFF_ID_DCONNAME: dumpString( "source-name", BIFF_STR_8BITLENGTH ); dumpString( "source-link", BIFF_STR_8BITLENGTH, BIFF_STR_SMARTFLAGS ); break; case BIFF_ID_DCONREF: dumpRange( "source-range", false ); dumpString( "source-link", BIFF_STR_8BITLENGTH, BIFF_STR_SMARTFLAGS ); break; case BIFF2_ID_DATATABLE: dumpRange( "table-range", false ); dumpBoolean( "recalc-always" ); dumpBoolean( "row-table" ); dumpAddress( "ref1" ); break; case BIFF3_ID_DATATABLE: dumpRange( "table-range", false ); dumpHex< sal_uInt16 >( "flags", "DATATABLE-FLAGS" ); dumpAddress( "ref1" ); dumpAddress( "ref2" ); break; case BIFF2_ID_DATATABLE2: dumpRange( "table-range", false ); dumpBoolean( "recalc-always" ); dumpUnused( 1 ); dumpAddress( "ref1" ); dumpAddress( "ref2" ); break; case BIFF_ID_DATAVALIDATION: { dumpHex< sal_uInt32 >( "flags", "DATAVALIDATION-FLAGS" ); dumpUniString( "input-title" ); dumpUniString( "error-title" ); dumpUniString( "input-message" ); dumpUniString( "error-message" ); sal_uInt16 nFmla1Size = getFormulaDumper().dumpFormulaSize( "formula1-size" ); dumpUnused( 2 ); if( nFmla1Size > 0 ) getFormulaDumper().dumpNameFormula( "formula1", nFmla1Size ); sal_uInt16 nFmla2Size = getFormulaDumper().dumpFormulaSize( "formula2-size" ); dumpUnused( 2 ); if( nFmla2Size > 0 ) getFormulaDumper().dumpNameFormula( "formula2", nFmla2Size ); dumpRangeList(); } break; case BIFF_ID_DATAVALIDATIONS: dumpHex< sal_uInt16 >( "flags", "DATAVALIDATIONS-FLAGS" ); dumpDec< sal_Int32 >( "input-box-pos-x" ); dumpDec< sal_Int32 >( "input-box-pos-y" ); dumpDec< sal_Int32 >( "dropdown-object-id" ); dumpDec< sal_Int32 >( "dval-entry-count" ); break; case BIFF_ID_DBCELL: dumpDec< sal_uInt32 >( "reverse-offset-to-row" ); mxOut->resetItemIndex(); while( rStrm.getRemaining() >= 2 ) dumpDec< sal_uInt16 >( "#cell-offset" ); break; case BIFF_ID_DBQUERY: if( eBiff == BIFF8 ) { if( (getLastRecId() != BIFF_ID_PCITEM_STRING) && (getLastRecId() != BIFF_ID_DBQUERY) ) { dumpHex< sal_uInt16 >( "flags", "DBQUERY-FLAGS" ); dumpDec< sal_uInt16 >( "sql-param-count" ); dumpDec< sal_uInt16 >( "command-count" ); dumpDec< sal_uInt16 >( "post-method-count" ); dumpDec< sal_uInt16 >( "server-sql-count" ); dumpDec< sal_uInt16 >( "odbc-connection-count" ); } } break; case BIFF2_ID_DEFINEDNAME: case BIFF3_ID_DEFINEDNAME: { rtl_TextEncoding eTextEnc = getBiffData().getTextEncoding(); dumpHex< sal_uInt16, sal_uInt8 >( eBiff != BIFF2, "flags", "DEFINEDNAME-FLAGS" ); if( eBiff == BIFF2 ) dumpDec< sal_uInt8 >( "macro-type", "DEFINEDNAME-MACROTYPE-BIFF2" ); dumpChar( "accelerator", eTextEnc ); sal_uInt8 nNameLen = dumpDec< sal_uInt8 >( "name-len" ); sal_uInt16 nFmlaSize = getFormulaDumper().dumpFormulaSize(); if( eBiff >= BIFF5 ) { bool bBiff8 = eBiff == BIFF8; if( bBiff8 ) dumpUnused( 2 ); else dumpDec< sal_uInt16 >( "externsheet-idx", "DEFINEDNAME-SHEETIDX" ); dumpDec< sal_uInt16 >( "sheet-idx", "DEFINEDNAME-SHEETIDX" ); sal_uInt8 nMenuLen = dumpDec< sal_uInt8 >( "menu-text-len" ); sal_uInt8 nDescrLen = dumpDec< sal_uInt8 >( "description-text-len" ); sal_uInt8 nHelpLen = dumpDec< sal_uInt8 >( "help-text-len" ); sal_uInt8 nStatusLen = dumpDec< sal_uInt8 >( "statusbar-text-len" ); writeStringItem( "name", bBiff8 ? rStrm.readUniStringBody( nNameLen, true ) : rStrm.readCharArrayUC( nNameLen, eTextEnc, true ) ); getFormulaDumper().dumpNameFormula( EMPTY_STRING, nFmlaSize ); if( nMenuLen > 0 ) writeStringItem( "menu-text", bBiff8 ? rStrm.readUniStringBody( nMenuLen, true ) : rStrm.readCharArrayUC( nMenuLen, eTextEnc, true ) ); if( nDescrLen > 0 ) writeStringItem( "description-text", bBiff8 ? rStrm.readUniStringBody( nDescrLen, true ) : rStrm.readCharArrayUC( nDescrLen, eTextEnc, true ) ); if( nHelpLen > 0 ) writeStringItem( "help-text", bBiff8 ? rStrm.readUniStringBody( nHelpLen, true ) : rStrm.readCharArrayUC( nHelpLen, eTextEnc, true ) ); if( nStatusLen > 0 ) writeStringItem( "statusbar-text", bBiff8 ? rStrm.readUniStringBody( nStatusLen, true ) : rStrm.readCharArrayUC( nStatusLen, eTextEnc, true ) ); } else { writeStringItem( "name", rStrm.readCharArrayUC( nNameLen, eTextEnc, true ) ); getFormulaDumper().dumpNameFormula( EMPTY_STRING, nFmlaSize ); if( eBiff == BIFF2 ) getFormulaDumper().dumpFormulaSize(); } } break; case BIFF3_ID_DEFROWHEIGHT: dumpHex< sal_uInt16 >( "flags", "DEFROWHEIGHT-FLAGS" ); dumpDec< sal_uInt16 >( "row-height", "CONV-TWIP-TO-PT" ); break; case BIFF2_ID_DIMENSION: case BIFF3_ID_DIMENSION: dumpRange( "used-area", true, (nRecId == BIFF3_ID_DIMENSION) && (eBiff == BIFF8) ); if( nRecId == BIFF3_ID_DIMENSION ) dumpUnused( 2 ); break; case BIFF_ID_DXF: dumpFrHeader( true, true ); dumpHex< sal_uInt16 >( "flags", "DXF-FLAGS" ); dumpDxfProp(); break; case BIFF_ID_EXTERNALBOOK: { sal_uInt16 nCount = dumpDec< sal_uInt16 >( "sheet-count" ); if( rStrm.getRemaining() == 2 ) dumpHex< sal_uInt16 >( "special-key", "EXTERNALBOOK-KEY" ); else { dumpString( "workbook-url" ); mxOut->resetItemIndex(); for( sal_uInt16 nSheet = 0; !rStrm.isEof() && (nSheet < nCount); ++nSheet ) dumpString( "#sheet-name" ); } } break; case BIFF2_ID_EXTERNALNAME: case BIFF3_ID_EXTERNALNAME: { sal_uInt16 nFlags = (eBiff >= BIFF3) ? dumpHex< sal_uInt16 >( "flags", "EXTERNALNAME-FLAGS" ) : 0; if( eBiff >= BIFF5 ) { if( getFlag< sal_uInt16 >( nFlags, 0x0010 ) ) { dumpHex< sal_uInt32 >( "storage-id" ); } else { dumpDec< sal_uInt16 >( "externsheet-idx" ); dumpUnused( 2 ); } } OUString aName = dumpString( "name", BIFF_STR_8BITLENGTH, BIFF_STR_8BITLENGTH ); if( (aName.getLength() > 0) && (aName[ 0 ] == 1) && (rStrm.getRemaining() >= 2) ) getFormulaDumper().dumpNameFormula(); } break; case BIFF_ID_EXTERNSHEET: if( eBiff == BIFF8 ) { sal_uInt16 nCount = dumpDec< sal_uInt16 >( "ref-count" ); TableGuard aTabGuard( mxOut, 10, 17, 24 ); mxOut->resetItemIndex(); for( sal_uInt16 nRefId = 0; !rStrm.isEof() && (nRefId < nCount); ++nRefId ) { MultiItemsGuard aMultiGuard( mxOut ); writeEmptyItem( "#ref" ); dumpDec< sal_uInt16 >( "extbook-idx" ); dumpDec< sal_Int16 >( "first-sheet", "EXTERNSHEET-IDX" ); dumpDec< sal_Int16 >( "last-sheet", "EXTERNSHEET-IDX" ); } } else { OStringBuffer aUrl( rStrm.readByteString( false, true ) ); if( (aUrl.getLength() > 0) && (aUrl[ 0 ] == '\x03') ) aUrl.append( static_cast< sal_Char >( rStrm.readuInt8() ) ); writeStringItem( "encoded-url", OStringToOUString( aUrl.makeStringAndClear(), getBiffData().getTextEncoding() ) ); } break; case BIFF_ID_FILEPASS: { rStrm.enableDecoder( false ); if( eBiff == BIFF8 ) { switch( dumpDec< sal_uInt16 >( "type", "FILEPASS-TYPE" ) ) { case 0: dumpHex< sal_uInt16 >( "key" ); dumpHex< sal_uInt16 >( "verifier" ); break; case 1: { sal_uInt16 nMajor = dumpDec< sal_uInt16 >( "major-version", "FILEPASS-MAJOR" ); dumpDec< sal_uInt16 >( "minor-version" ); switch( nMajor ) { case 1: dumpArray( "salt", 16 ); dumpArray( "verifier", 16 ); dumpArray( "verifier-hash", 16 ); break; } } break; } } else { dumpHex< sal_uInt16 >( "key" ); dumpHex< sal_uInt16 >( "verifier" ); } rStrm.seekToStart(); BiffDecoderRef xDecoder = BiffCodecHelper::implReadFilePass( rStrm, eBiff ); if( xDecoder.get() ) cfg().requestEncryptionData( *xDecoder ); setBinaryOnlyMode( !xDecoder || !xDecoder->isValid() ); } break; case BIFF_ID_FILESHARING: dumpBool< sal_uInt16 >( "recommend-read-only" ); dumpHex< sal_uInt16 >( "password-hash" ); dumpString( "password-creator", BIFF_STR_8BITLENGTH, BIFF_STR_SMARTFLAGS ); break; case BIFF_ID_FILTERCOLUMN: { dumpDec< sal_uInt16 >( "column-index" ); dumpHex< sal_uInt16 >( "flags", "FILTERCOLUMN-FLAGS" ); sal_uInt8 nStrLen1 = dumpFilterColumnOperator( "operator-1" ); sal_uInt8 nStrLen2 = dumpFilterColumnOperator( "operator-2" ); bool bBiff8 = eBiff == BIFF8; rtl_TextEncoding eTextEnc = getBiffData().getTextEncoding(); if( nStrLen1 > 0 ) writeStringItem( "string-1", bBiff8 ? rStrm.readUniStringBody( nStrLen1, true ) : rStrm.readCharArrayUC( nStrLen1, eTextEnc, true ) ); if( nStrLen2 > 0 ) writeStringItem( "string-2", bBiff8 ? rStrm.readUniStringBody( nStrLen2, true ) : rStrm.readCharArrayUC( nStrLen2, eTextEnc, true ) ); } break; case BIFF2_ID_FONT: case BIFF3_ID_FONT: dumpFontRec(); break; case BIFF_ID_FORCEFULLCALC: dumpFrHeader( true, true ); dumpBool< sal_Int32 >( "recalc-all-formulas" ); break; case BIFF2_ID_FORMAT: case BIFF4_ID_FORMAT: dumpFormatRec(); break; case BIFF2_ID_FORMULA: case BIFF3_ID_FORMULA: case BIFF4_ID_FORMULA: dumpCellHeader( eBiff == BIFF2 ); dumpFormulaResult(); dumpHex< sal_uInt16, sal_uInt8 >( eBiff != BIFF2, "flags", "FORMULA-FLAGS" ); if( eBiff >= BIFF5 ) dumpUnused( 4 ); getFormulaDumper().dumpCellFormula(); break; case BIFF_ID_FOOTER: if( rStrm.getRemaining() > 0 ) dumpString( "footer", BIFF_STR_8BITLENGTH ); break; case BIFF_ID_GUTS: dumpDec< sal_uInt16 >( "row-outlines-width" ); dumpDec< sal_uInt16 >( "column-outlines-height" ); dumpDec< sal_uInt16 >( "row-levels", "GUTS-LEVELS" ); dumpDec< sal_uInt16 >( "column-levels", "GUTS-LEVELS" ); break; case BIFF_ID_HEADER: if( rStrm.getRemaining() > 0 ) dumpString( "header", BIFF_STR_8BITLENGTH ); break; case BIFF_ID_HEADERFOOTER: { dumpFrHeader( true, true ); dumpGuid( "view-guid" ); dumpHex< sal_uInt16 >( "flags", "HEADERFOOTER-FLAGS" ); sal_uInt16 nEvenHLen = dumpDec< sal_uInt16 >( "even-h-len" ); sal_uInt16 nEvenFLen = dumpDec< sal_uInt16 >( "even-f-len" ); sal_uInt16 nFirstHLen = dumpDec< sal_uInt16 >( "first-h-len" ); sal_uInt16 nFirstFLen = dumpDec< sal_uInt16 >( "first-f-len" ); if( nEvenHLen > 0 ) dumpUniString( "even-h" ); if( nEvenFLen > 0 ) dumpUniString( "even-f" ); if( nFirstHLen > 0 ) dumpUniString( "first-h" ); if( nFirstFLen > 0 ) dumpUniString( "first-f" ); } break; case BIFF_ID_HYPERLINK: dumpRange(); if( cfg().getStringOption( dumpGuid( "guid" ), OUString() ).equalsAscii( "StdHlink" ) ) StdHlinkObject( *this ).dump(); break; case BIFF3_ID_IMGDATA: case BIFF8_ID_IMGDATA: { sal_uInt16 nFormat = dumpDec< sal_uInt16 >( "image-format", "IMGDATA-FORMAT" ); dumpDec< sal_uInt16 >( "environment", "IMGDATA-ENV" ); dumpDec< sal_uInt32 >( "data-size" ); if( nFormat == 9 ) { writeEmptyItem( "bitmap-header" ); IndentGuard aIndGuard( mxOut ); if( dumpDec< sal_uInt32 >( "header-size" ) == 12 ) { dumpDec< sal_Int16 >( "width" ); dumpDec< sal_Int16 >( "height" ); dumpDec< sal_Int16 >( "planes" ); dumpDec< sal_Int16 >( "bit-count" ); } } } break; case BIFF2_ID_INDEX: case BIFF3_ID_INDEX: if( eBiff <= BIFF4 ) dumpHex< sal_uInt32 >( "first-defname-pos", "CONV-DEC" ); else dumpUnused( 4 ); dumpRowIndex( "first-row-with-cell", eBiff == BIFF8 ); dumpRowIndex( "first-free-row", eBiff == BIFF8 ); if( nRecId == BIFF3_ID_INDEX ) dumpHex< sal_uInt32 >( (eBiff <= BIFF4) ? "first-xf-pos" : "defcolwidth-pos", "CONV-DEC" ); mxOut->resetItemIndex(); while( rStrm.getRemaining() >= 4 ) dumpHex< sal_uInt32 >( "#first-row-pos-of-block", "CONV-DEC" ); break; case BIFF2_ID_INTEGER: dumpCellHeader( true ); dumpDec< sal_uInt16 >( "value" ); break; case BIFF2_ID_LABEL: case BIFF3_ID_LABEL: { bool bBiff2 = nRecId == BIFF2_ID_LABEL; sal_uInt16 nXfIdx = dumpCellHeader( bBiff2 ); rtl_TextEncoding eOldTextEnc = getBiffData().getTextEncoding(); getBiffData().setTextEncoding( getBiffData().getXfEncoding( nXfIdx ) ); dumpString( "value", bBiff2 ? BIFF_STR_8BITLENGTH : BIFF_STR_DEFAULT ); getBiffData().setTextEncoding( eOldTextEnc ); } break; case BIFF_ID_LABELRANGES: dumpRangeList( "row-ranges" ); dumpRangeList( "col-ranges" ); break; case BIFF_ID_LABELSST: dumpCellHeader(); dumpDec< sal_Int32 >( "sst-idx" ); break; case BIFF_ID_MERGEDCELLS: mxOut->resetItemIndex(); for( sal_uInt16 nIdx = 0, nCount = dumpDec< sal_uInt16 >( "count" ); !rStrm.isEof() && (nIdx < nCount); ++nIdx ) dumpRange( "#range" ); break; case BIFF_ID_MSODRAWING: case BIFF_ID_MSODRAWINGGROUP: case BIFF_ID_MSODRAWINGSEL: dumpEmbeddedDff(); mbHasDff = true; break; case BIFF_ID_MTHREADSETTINGS: dumpFrHeader( true, true ); dumpBool< sal_Int32 >( "multi-thread-enabled" ); dumpBool< sal_Int32 >( "manual-thread-count" ); dumpDec< sal_Int32 >( "thread-count" ); break; case BIFF_ID_MULTBLANK: { Address aPos = dumpAddress(); { TableGuard aTabGuard( mxOut, 12 ); for( ; rStrm.getRemaining() >= 4; ++aPos.mnCol ) { MultiItemsGuard aMultiGuard( mxOut ); writeAddressItem( "pos", aPos ); dumpXfIdx(); } } dumpColIndex( "last-col-idx" ); } break; case BIFF_ID_MULTRK: { Address aPos = dumpAddress(); { TableGuard aTabGuard( mxOut, 12, 12 ); for( ; rStrm.getRemaining() >= 8; ++aPos.mnCol ) { MultiItemsGuard aMultiGuard( mxOut ); writeAddressItem( "pos", aPos ); dumpXfIdx(); dumpRk( "value" ); } } dumpColIndex( "last-col-idx" ); } break; case BIFF_ID_NOTE: dumpAddress( "anchor-cell" ); if( eBiff == BIFF8 ) { dumpHex< sal_uInt16 >( "flags", "NOTE-FLAGS" ); dumpDec< sal_uInt16 >( "obj-id" ); dumpUniString( "author" ); dumpUnused( 1 ); } else { sal_uInt16 nTextLen = dumpDec< sal_uInt16 >( "text-len" ); nTextLen = ::std::min( nTextLen, static_cast< sal_uInt16 >( rStrm.getRemaining() ) ); writeStringItem( "note-text", rStrm.readCharArrayUC( nTextLen, getBiffData().getTextEncoding(), true ) ); } break; case BIFF_ID_NOTESOUND: dumpHex< sal_uInt32 >( "identifier" ); dumpDec< sal_uInt32 >( "total-data-size" ); dumpDec< sal_uInt32 >( "wave-data-size" ); if( dumpDec< sal_uInt32 >( "fmt-size" ) >= 16 ) { dumpDec< sal_uInt16 >( "format", "NOTESOUND-FORMAT" ); dumpDec< sal_uInt16 >( "channels" ); dumpDec< sal_uInt32 >( "sampling-rate" ); dumpDec< sal_uInt32 >( "data-rate" ); dumpDec< sal_uInt16 >( "data-block-size" ); dumpDec< sal_uInt16 >( "bits-per-sample" ); } break; case BIFF2_ID_NUMBER: case BIFF3_ID_NUMBER: dumpCellHeader( nRecId == BIFF2_ID_NUMBER ); dumpDec< double >( "value" ); break; case BIFF_ID_OBJ: dumpObjRec(); break; case BIFF_ID_OLESIZE: dumpUnused( 2 ); dumpRange( "visible-range", false ); break; case BIFF_ID_PAGELAYOUTVIEW: dumpFrHeader( true, true ); dumpDec< sal_uInt16 >( "scaling", "CONV-PERCENT" ); dumpHex< sal_uInt16 >( "flags", "PAGELAYOUTVIEW-FLAGS" ); break; case BIFF_ID_PAGESETUP: dumpDec< sal_uInt16 >( "paper-size", "PAGESETUP-PAPERSIZE" ); dumpDec< sal_uInt16 >( "scaling", "CONV-PERCENT" ); dumpDec< sal_uInt16 >( "first-page" ); dumpDec< sal_uInt16 >( "scale-to-width", "PAGESETUP-SCALETOPAGES" ); dumpDec< sal_uInt16 >( "scale-to-height", "PAGESETUP-SCALETOPAGES" ); dumpHex< sal_uInt16 >( "flags", "PAGESETUP-FLAGS" ); if( eBiff >= BIFF5 ) { dumpDec< sal_uInt16 >( "horizontal-res", "PAGESETUP-DPI" ); dumpDec< sal_uInt16 >( "vertical-res", "PAGESETUP-DPI" ); dumpDec< double >( "header-margin", "CONV-INCH-TO-CM" ); dumpDec< double >( "footer-margin", "CONV-INCH-TO-CM" ); dumpDec< sal_uInt16 >( "copies" ); } break; case BIFF_ID_PALETTE: mxOut->resetItemIndex( 8 ); for( sal_uInt16 nIdx = 0, nCount = dumpDec< sal_uInt16 >( "count" ); !rStrm.isEof() && (nIdx < nCount); ++nIdx ) { OUStringBuffer aColorName; StringHelper::appendHex( aColorName, dumpColorABGR( "#color" ) ); mxColors->setName( nIdx + 8, aColorName.makeStringAndClear() ); } break; case BIFF_ID_PANE: dumpDec< sal_uInt16 >( "x-pos", "CONV-TWIP-TO-CM" ); dumpDec< sal_uInt16 >( "y-pos", "CONV-TWIP-TO-CM" ); dumpAddress( "first-visible-cell" ); dumpDec< sal_uInt8 >( "active-pane", "PANE-ID" ); break; case BIFF_ID_PCITEM_STRING: dumpString( "value" ); break; case BIFF_ID_PHONETICPR: dumpDec< sal_uInt16 >( "font-id", "FONTNAMES" ); dumpHex< sal_uInt16 >( "flags", "PHONETICPR-FLAGS" ); dumpRangeList( "show-phonetic" ); break; case BIFF_ID_PROJEXTSHEET: dumpDec< sal_uInt8 >( "sheet-type", "PROJEXTSHEET-TYPE" ); dumpUnused( 1 ); dumpByteString( "sheet-link", BIFF_STR_8BITLENGTH ); break; case BIFF_ID_PTDATAFIELD: dumpDec< sal_Int16 >( "field" ); dumpDec< sal_uInt16 >( "subtotal", "PTDATAFIELD-SUBTOTAL" ); dumpDec< sal_uInt16 >( "show-data-as", "PTDATAFIELD-SHOWDATAAS" ); dumpDec< sal_Int16 >( "base-field" ); dumpDec< sal_Int16 >( "base-item", "PTDATAFIELD-BASEITEM" ); dumpFormatIdx(); dumpPivotString( "name" ); break; case BIFF_ID_PTDEFINITION: { dumpRange( "output-range" ); dumpRowIndex( "first-header-row-idx" ); dumpAddress( "first-data-pos" ); dumpDec< sal_uInt16 >( "cache-idx" ); dumpUnused( 2 ); dumpDec< sal_uInt16 >( "default-data-axis", "PTFIELD-AXISTYPE" ); dumpDec< sal_Int16 >( "default-data-pos", "PTDEFINITION-DATAFIELD-POS" ); dumpDec< sal_uInt16 >( "field-count" ); mnPTRowFields = dumpDec< sal_uInt16 >( "row-field-count" ); mnPTColFields = dumpDec< sal_uInt16 >( "column-field-count" ); dumpDec< sal_uInt16 >( "page-field-count" ); dumpDec< sal_uInt16 >( "data-field-count" ); dumpDec< sal_uInt16 >( "data-row-count" ); dumpDec< sal_uInt16 >( "data-column-count" ); dumpHex< sal_uInt16 >( "flags", "PTDEFINITION-FLAGS" ); dumpDec< sal_uInt16 >( "auto-format-idx" ); sal_uInt16 nTabNameLen = dumpDec< sal_uInt16 >( "table-name-len" ); sal_uInt16 nDataNameLen = dumpDec< sal_uInt16 >( "data-name-len" ); dumpPivotString( "table-name", nTabNameLen ); dumpPivotString( "data-name", nDataNameLen ); mnPTRowColItemsIdx = 0; } break; case BIFF_ID_PTDEFINITION2: { dumpDec< sal_uInt16 >( "format-rec-count" ); sal_uInt16 nErrCaptLen = dumpDec< sal_uInt16 >( "error-caption-len" ); sal_uInt16 nMissCaptLen = dumpDec< sal_uInt16 >( "missing-caption-len" ); sal_uInt16 nTagLen = dumpDec< sal_uInt16 >( "tag-len" ); dumpDec< sal_uInt16 >( "select-rec-count" ); dumpDec< sal_uInt16 >( "page-rows" ); dumpDec< sal_uInt16 >( "page-cols" ); dumpHex< sal_uInt32 >( "flags", "PTDEFINITION2-FLAGS" ); sal_uInt16 nPageStyleLen = dumpDec< sal_uInt16 >( "page-field-style-len" ); sal_uInt16 nTabStyleLen = dumpDec< sal_uInt16 >( "pivot-table-style-len" ); sal_uInt16 nVacStyleLen = dumpDec< sal_uInt16 >( "vacated-style-len" ); dumpPivotString( "error-caption", nErrCaptLen ); dumpPivotString( "missing-caption", nMissCaptLen ); dumpPivotString( "tag", nTagLen ); dumpPivotString( "page-field-style", nPageStyleLen ); dumpPivotString( "pivot-table-style", nTabStyleLen ); dumpPivotString( "vacated-style", nVacStyleLen ); } break; case BIFF_ID_PTFIELD: dumpDec< sal_uInt16 >( "axis-type", "PTFIELD-AXISTYPE" ); dumpDec< sal_uInt16 >( "subtotal-count" ); dumpHex< sal_uInt16 >( "subtotals", "PTFIELD-SUBTOTALS" ); dumpDec< sal_uInt16 >( "item-count" ); dumpPivotString( "field-name" ); break; case BIFF_ID_PTFIELD2: dumpHex< sal_uInt32 >( "flags", "PTFIELD2-FLAGS" ); dumpDec< sal_Int16 >( "autosort-basefield-idx" ); dumpDec< sal_Int16 >( "autoshow-basefield-idx" ); dumpFormatIdx(); if( rStrm.getRemaining() >= 2 ) { sal_uInt16 nFuncNameLen = dumpDec< sal_uInt16 >( "subtotal-func-name-len" ); dumpUnused( 8 ); dumpPivotString( "subtotal-func-name", nFuncNameLen ); } break; case BIFF_ID_PTFITEM: dumpDec< sal_uInt16 >( "item-type", "PTFITEM-ITEMTYPE" ); dumpHex< sal_uInt16 >( "flags", "PTFITEM-FLAGS" ); dumpDec< sal_Int16 >( "cache-idx", "PTFITEM-CACHEIDX" ); dumpPivotString( "item-name" ); break; case BIFF_ID_PTPAGEFIELDS: { mxOut->resetItemIndex(); TableGuard aTabGuard( mxOut, 17, 17, 17 ); while( rStrm.getRemaining() >= 6 ) { writeEmptyItem( "#page-field" ); MultiItemsGuard aMultiGuard( mxOut ); IndentGuard aIndGuard( mxOut ); dumpDec< sal_Int16 >( "base-field" ); dumpDec< sal_Int16 >( "item", "PTPAGEFIELDS-ITEM" ); dumpDec< sal_uInt16 >( "dropdown-obj-id" ); } } break; case BIFF_ID_PTROWCOLFIELDS: mxOut->resetItemIndex(); for( sal_Int64 nIdx = 0, nCount = rStrm.getRemaining() / 2; nIdx < nCount; ++nIdx ) dumpDec< sal_Int16 >( "#field-idx" ); break; case BIFF_ID_PTROWCOLITEMS: if( mnPTRowColItemsIdx < 2 ) { sal_uInt16 nCount = (mnPTRowColItemsIdx == 0) ? mnPTRowFields : mnPTColFields; sal_Int64 nLineSize = 8 + 2 * nCount; mxOut->resetItemIndex(); while( rStrm.getRemaining() >= nLineSize ) { writeEmptyItem( "#line-data" ); IndentGuard aIndGuard( mxOut ); MultiItemsGuard aMultiGuard( mxOut ); dumpDec< sal_uInt16 >( "ident-count" ); dumpDec< sal_uInt16 >( "item-type", "PTROWCOLITEMS-ITEMTYPE" ); dumpDec< sal_uInt16 >( "used-count" ); dumpHex< sal_uInt16 >( "flags", "PTROWCOLITEMS-FLAGS" ); OUStringBuffer aItemList; for( sal_uInt16 nIdx = 0; nIdx < nCount; ++nIdx ) StringHelper::appendToken( aItemList, mxStrm->readInt16() ); writeInfoItem( "item-idxs", aItemList.makeStringAndClear() ); } ++mnPTRowColItemsIdx; } break; case BIFF_ID_QUERYTABLE: dumpHex< sal_uInt16 >( "flags", "QUERYTABLE-FLAGS" ); dumpDec< sal_uInt16 >( "autoformat-id" ); dumpHex< sal_uInt16 >( "autoformat-flags", "QUERYTABLE-AUTOFORMAT-FLAGS" ); dumpUnused( 4 ); dumpUniString( "defined-name" ); dumpUnused( 2 ); break; case BIFF_ID_QUERYTABLEREFRESH: { dumpFrHeader( true, false ); bool bPivot = dumpBool< sal_uInt16 >( "pivot-table" ); dumpHex< sal_uInt16 >( "flags", "QUERYTABLEREFRESH-FLAGS" ); dumpHex< sal_uInt32 >( bPivot ? "pivottable-flags" : "querytable-flags", bPivot ? "QUERYTABLEREFRESH-PTFLAGS" : "QUERYTABLEREFRESH-QTFLAGS" ); dumpDec< sal_uInt8 >( "refreshed-version" ); dumpDec< sal_uInt8 >( "min-refresh-version" ); dumpUnused( 2 ); dumpUniString( "table-name" ); dumpUnused( 2 ); } break; case BIFF_ID_QUERYTABLESETTINGS: { dumpFrHeader( true, false ); sal_uInt16 nType = dumpDec< sal_uInt16 >( "data-source-type", "CONNECTION-SOURCETYPE" ); dumpHex< sal_uInt16 >( "flags-1", "QUERYTABLESETTINGS-FLAGS" ); switch( nType ) { case 4: dumpHex< sal_uInt16 >( "html-flags", "QUERYTABLESETTINGS-HTML-FLAGS" ); break; case 5: dumpHex< sal_uInt16 >( "oledb-flags", "QUERYTABLESETTINGS-OLEDB-FLAGS" ); break; case 7: dumpHex< sal_uInt16 >( "ado-flags", "QUERYTABLESETTINGS-ADO-FLAGS" ); break; default: dumpUnused( 2 ); } dumpHex< sal_uInt16 >( "ext-flags", "QUERYTABLESETTINGS-EXT-FLAGS" ); dumpDec< sal_uInt8 >( "edited-version" ); dumpDec< sal_uInt8 >( "refreshed-version" ); dumpDec< sal_uInt8 >( "min-refresh-version" ); dumpUnused( 3 ); dumpDec< sal_uInt16 >( "oledb-count" ); dumpDec< sal_uInt16 >( "future-data-size" ); dumpDec< sal_uInt16 >( "refresh-interval", "QUERYTABLESETTINGS-INTERVAL" ); dumpDec< sal_uInt16 >( "html-format", "QUERYTABLESETTINGS-HTMLFORMAT" ); } break; case BIFF_ID_QUERYTABLESTRING: dumpFrHeader( true, false ); dumpUniString( "connection-string" ); break; case BIFF_ID_RECALCID: dumpFrHeader( true, false ); dumpDec< sal_uInt32 >( "recalc-engine-id" ); break; case BIFF_ID_RK: dumpCellHeader(); dumpRk( "value" ); break; case BIFF2_ID_ROW: { dumpRowIndex(); dumpColIndex( "first-used-col-idx" ); dumpColIndex( "first-free-col-idx" ); dumpHex< sal_uInt16 >( "height", "ROW-HEIGHT" ); dumpUnused( 2 ); bool bHasDefXf = dumpBool< sal_uInt8 >( "custom-format" ); dumpDec< sal_uInt16 >( "cell-offset" ); if( bHasDefXf ) dumpXfIdx( "custom-format", true ); if( bHasDefXf ) dumpXfIdx( "custom-xf-idx", false ); } break; case BIFF3_ID_ROW: dumpRowIndex(); dumpColIndex( "first-used-col-idx" ); dumpColIndex( "first-free-col-idx" ); dumpHex< sal_uInt16 >( "height", "ROW-HEIGHT" ); dumpUnused( (eBiff <= BIFF4) ? 2 : 4 ); if( eBiff <= BIFF4 ) dumpDec< sal_uInt16 >( "cell-offset" ); dumpHex< sal_uInt32 >( "flags", "ROW-FLAGS" ); break; case BIFF_ID_RSTRING: { sal_uInt16 nXfIdx = dumpCellHeader(); rtl_TextEncoding eOldTextEnc = getBiffData().getTextEncoding(); getBiffData().setTextEncoding( getBiffData().getXfEncoding( nXfIdx ) ); dumpString( "value" ); getBiffData().setTextEncoding( eOldTextEnc ); FontPortionModelList aPortions; aPortions.importPortions( rStrm, eBiff == BIFF8 ); writeFontPortions( aPortions ); } break; case BIFF_ID_SCENARIO: { sal_uInt16 nCellCount = dumpDec< sal_uInt16 >( "cell-count" ); // two bytes instead of flag field dumpBoolean( "locked" ); dumpBoolean( "hidden" ); sal_uInt16 nNameLen = dumpDec< sal_uInt8 >( "name-len" ); sal_uInt16 nCommentLen = dumpDec< sal_uInt8 >( "comment-len" ); sal_uInt16 nUserLen = dumpDec< sal_uInt8 >( "user-len" ); writeStringItem( "name", rStrm.readUniStringBody( nNameLen, true ) ); if( nUserLen > 0 ) dumpUniString( "user" ); // repeated string length if( nCommentLen > 0 ) dumpUniString( "comment" ); // repeated string length mxOut->resetItemIndex(); for( sal_uInt16 nCell = 0; !rStrm.isEof() && (nCell < nCellCount); ++nCell ) dumpAddress( "#pos" ); mxOut->resetItemIndex(); for( sal_uInt16 nCell = 0; !rStrm.isEof() && (nCell < nCellCount); ++nCell ) dumpString( "#value" ); dumpUnused( 2 * nCellCount ); } break; case BIFF_ID_SCENARIOS: dumpDec< sal_uInt16 >( "count" ); dumpDec< sal_uInt16 >( "selected" ); dumpDec< sal_uInt16 >( "shown" ); dumpRangeList( "result-cells" ); break; case BIFF_ID_SCL: { sal_uInt16 nNum = dumpDec< sal_uInt16 >( "numerator" ); sal_uInt16 nDen = dumpDec< sal_uInt16 >( "denominator" ); if( nDen > 0 ) writeDecItem( "current-zoom", static_cast< sal_uInt16 >( nNum * 100 / nDen ), "CONV-PERCENT" ); } break; case BIFF_ID_SCREENTIP: dumpFrHeader( false, true ); dumpNullUnicodeArray( "tooltip" ); break; case BIFF_ID_SELECTION: dumpDec< sal_uInt8 >( "pane", "PANE-ID" ); dumpAddress( "active-cell" ); dumpDec< sal_uInt16 >( "list-idx" ); dumpRangeList( "selection", false ); break; case BIFF_ID_SHAREDFEATHEAD: { dumpFrHeader( true, true ); sal_uInt16 nType = dumpDec< sal_uInt16 >( "feature-type", "SHAREDFEATHEAD-TYPE" ); dumpUnused( 1 ); if( dumpBool< sal_Int32 >( "has-data" ) ) switch( nType ) { case 2: dumpHex< sal_uInt32 >( "allowed-flags", "SHAREDFEATHEAD-PROT-FLAGS" ); break; } } break; case BIFF_ID_SHAREDFMLA: dumpRange( "formula-range", false ); dumpUnused( 1 ); dumpDec< sal_uInt8 >( "cell-count" ); getFormulaDumper().dumpCellFormula(); break; case BIFF_ID_SHEET: if( eBiff >= BIFF5 ) { rStrm.enableDecoder( false ); dumpHex< sal_uInt32 >( "sheet-stream-pos", "CONV-DEC" ); rStrm.enableDecoder( true ); dumpDec< sal_uInt8 >( "sheet-state", "SHEET-STATE" ); dumpDec< sal_uInt8 >( "sheet-type", "SHEET-TYPE" ); } dumpString( "sheet-name", BIFF_STR_8BITLENGTH, BIFF_STR_8BITLENGTH ); break; case BIFF_ID_SHEETEXT: dumpFrHeader( true, true ); dumpDec< sal_uInt32 >( "rec-size" ); dumpDec< sal_uInt32 >( "flags-1", "SHEETEXT-FLAGS1" ); if( rStrm.getRemaining() >= 20 ) { dumpDec< sal_uInt32 >( "flags-2", "SHEETEXT-FLAGS2" ); dumpExtCfColor( "tab-color" ); } break; case BIFF_ID_SHEETHEADER: dumpHex< sal_uInt32 >( "substream-size", "CONV-DEC" ); dumpByteString( "sheet-name", BIFF_STR_8BITLENGTH ); break; case BIFF_ID_SST: dumpDec< sal_uInt32 >( "string-cell-count" ); dumpDec< sal_uInt32 >( "sst-size" ); mxOut->resetItemIndex(); while( !rStrm.isEof() && (rStrm.getRemaining() >= 3) ) dumpUniString( "#entry" ); break; case BIFF2_ID_STRING: case BIFF3_ID_STRING: dumpString( "result", ((nRecId == BIFF2_ID_STRING) && (eBiff <= BIFF4)) ? BIFF_STR_8BITLENGTH : BIFF_STR_DEFAULT ); break; case BIFF_ID_STYLE: { sal_uInt16 nFlags = dumpHex< sal_uInt16 >( "flags", "STYLE-FLAGS" ); if( getFlag( nFlags, BIFF_STYLE_BUILTIN ) ) { dumpDec< sal_Int8 >( "builtin-idx", "STYLE-BUILTIN" ); dumpDec< sal_Int8 >( "outline-level" ); } else dumpString( "style-name", BIFF_STR_8BITLENGTH ); } break; case BIFF_ID_STYLEEXT: dumpFrHeader( true, true ); dumpHex< sal_uInt8 >( "flags", "STYLEEXT-FLAGS" ); dumpDec< sal_uInt8 >( "category", "STYLEEXT-CATEGORY" ); dumpDec< sal_Int8 >( "builtin-idx", "STYLEEXT-BUILTIN" ); dumpDec< sal_Int8 >( "outline-level" ); dumpUnicodeArray( "style-name", rStrm.readuInt16() ); dumpDxfProp(); break; case BIFF_ID_TABLESTYLES: { dumpFrHeader( true, true ); dumpDec< sal_uInt32 >( "table-style-count" ); sal_uInt16 nDefTableLen, nDefPivotLen; rStrm >> nDefTableLen >> nDefPivotLen; dumpUnicodeArray( "def-table-style", nDefTableLen ); dumpUnicodeArray( "def-pivot-style", nDefPivotLen ); } break; case BIFF_ID_THEME: dumpFrHeader( true, true ); dumpDec< sal_uInt32 >( "theme-version", "THEME-VERSION" ); break; case BIFF_ID_TXO: dumpHex< sal_uInt16 >( "flags", "TXO-FLAGS" ); dumpDec< sal_uInt16 >( "orientation", "TEXTORIENTATION" ); dumpHex< sal_uInt16 >( "button-flags", "OBJ-BUTTON-FLAGS" ); dumpUnicode( "accelerator" ); dumpUnicode( "fareast-accelerator" ); dumpDec< sal_uInt16 >( "text-len" ); dumpDec< sal_uInt16 >( "format-run-size" ); dumpUnused( 4 ); break; case BIFF_ID_WINDOW1: dumpDec< sal_uInt16 >( "window-x", "CONV-TWIP-TO-CM" ); dumpDec< sal_uInt16 >( "window-y", "CONV-TWIP-TO-CM" ); dumpDec< sal_uInt16 >( "window-width", "CONV-TWIP-TO-CM" ); dumpDec< sal_uInt16 >( "window-height", "CONV-TWIP-TO-CM" ); if( eBiff <= BIFF4 ) { dumpBool< sal_uInt8 >( "hidden" ); } else { dumpHex< sal_uInt16 >( "flags", "WINDOW1-FLAGS" ); dumpDec< sal_uInt16 >( "active-tab" ); dumpDec< sal_uInt16 >( "first-visible-tab" ); dumpDec< sal_uInt16 >( "selected-tabs" ); dumpDec< sal_uInt16 >( "tabbar-ratio", "WINDOW1-TABBARRATIO" ); } break; case BIFF2_ID_WINDOW2: dumpBool< sal_uInt8 >( "show-formulas" ); dumpBool< sal_uInt8 >( "show-gridlines" ); dumpBool< sal_uInt8 >( "show-headings" ); dumpBool< sal_uInt8 >( "frozen-panes" ); dumpBool< sal_uInt8 >( "show-zeros" ); dumpAddress( "first-visible-cell" ); dumpBool< sal_uInt8 >( "auto-grid-color" ); dumpColorABGR( "grid-color" ); break; case BIFF3_ID_WINDOW2: dumpHex< sal_uInt16 >( "flags", "WINDOW2-FLAGS" ); dumpAddress( "first-visible-cell" ); if( eBiff == BIFF8 ) { dumpColorIdx( "grid-color-idx" ); dumpUnused( 2 ); if( rStrm.getRemaining() >= 8 ) { dumpDec< sal_uInt16 >( "pagebreak-zoom", "CONV-PERCENT" ); dumpDec< sal_uInt16 >( "normal-zoom", "CONV-PERCENT" ); dumpUnused( 4 ); } } else dumpColorABGR( "grid-color" ); break; case BIFF_ID_WRITEACCESS: dumpString( "user-name", BIFF_STR_8BITLENGTH ); break; case BIFF_ID_XCT: dumpDec< sal_uInt16 >( "crn-count" ); if( eBiff == BIFF8 ) dumpDec< sal_Int16 >( "sheet-idx" ); break; case BIFF2_ID_XF: case BIFF3_ID_XF: case BIFF4_ID_XF: case BIFF5_ID_XF: dumpXfRec(); break; case BIFF_ID_XFCRC: dumpFrHeader( true, true ); dumpUnused( 2 ); dumpDec< sal_uInt16 >( "xf-count" ); dumpHex< sal_uInt32 >( "xf-checksum" ); break; case BIFF_ID_XFEXT: dumpFrHeader( true, true ); dumpUnused( 2 ); dumpXfIdx( "xf-idx" ); dumpUnused( 2 ); dumpXfExtProp(); break; } } void WorkbookStreamObject::initializePerSheet() { getBiffData().initializePerSheet(); mxFontNames = cfg().createNameList< ConstList >( "FONTNAMES" ); mxFontNames->setName( 0, createFontName( CREATE_OUSTRING( "Arial" ), 200, false, false ) ); mxFormats = cfg().createNameList< ConstList >( "FORMATS" ); mxFormats->includeList( cfg().getNameList( "BUILTIN-FORMATS" ) ); mnFormatIdx = 0; mbHasCodePage = false; } OUString WorkbookStreamObject::createFontName( const OUString& rName, sal_uInt16 nHeight, bool bBold, bool bItalic ) const { OUStringBuffer aName( rName ); StringHelper::enclose( aName, OOX_DUMP_STRQUOTE ); StringHelper::appendToken( aName, cfg().getName( "CONV-TWIP-TO-PT", nHeight ), ',' ); if( bBold ) StringHelper::appendToken( aName, CREATE_OUSTRING( "bold" ), ',' ); if( bItalic ) StringHelper::appendToken( aName, CREATE_OUSTRING( "italic" ), ',' ); return aName.makeStringAndClear(); } sal_uInt16 WorkbookStreamObject::dumpPatternIdx( const String& rName, bool b16Bit ) { return dumpDec< sal_uInt16, sal_uInt8 >( b16Bit, rName( "fill-pattern" ), mxFillPatterns ); } sal_uInt16 WorkbookStreamObject::dumpColorIdx( const String& rName, bool b16Bit ) { return dumpDec< sal_uInt16, sal_uInt8 >( b16Bit, rName( "color-idx" ), mxColors ); } sal_uInt16 WorkbookStreamObject::dumpFontIdx( const String& rName, bool b16Bit ) { return dumpDec< sal_uInt16, sal_uInt8 >( b16Bit, rName( "font-idx" ), mxFontNames ); } sal_uInt16 WorkbookStreamObject::dumpFormatIdx( const String& rName ) { return dumpDec< sal_uInt16, sal_uInt8 >( getBiff() >= BIFF5, rName( "fmt-idx" ), mxFormats ); } sal_uInt16 WorkbookStreamObject::dumpXfIdx( const String& rName, bool bBiff2Style ) { String aName = rName( "xf-idx" ); sal_uInt16 nXfIdx = 0; if( bBiff2Style ) { dumpHex< sal_uInt8 >( aName, "CELL-XFINDEX" ); dumpHex< sal_uInt8 >( "fmt-font-idx", "CELL-XFFORMAT" ); dumpHex< sal_uInt8 >( "style", "CELL-XFSTYLE" ); } else nXfIdx = dumpDec< sal_uInt16 >( aName ); return nXfIdx; } void WorkbookStreamObject::dumpExtColorValue( sal_uInt32 nColorType ) { switch( nColorType ) { case 0: dumpUnused( 4 ); break; case 1: dumpDec< sal_uInt32 >( "color-idx", mxColors ); break; case 2: dumpColorABGR(); break; case 3: dumpDec< sal_uInt32 >( "theme-id" ); break; case 4: dumpUnused( 4 ); break; default: dumpUnknown( 4 ); } } void WorkbookStreamObject::dumpExtColor( const String& rName ) { MultiItemsGuard aMultiGuard( mxOut ); writeEmptyItem( rName( "color" ) ); switch( extractValue< sal_uInt8 >( dumpDec< sal_uInt8 >( "flags", "EXTCOLOR-FLAGS" ), 1, 7 ) ) { case 0: dumpUnused( 1 ); break; case 1: dumpColorIdx( "color-idx", false ); break; case 2: dumpUnused( 1 ); break; case 3: dumpDec< sal_uInt8 >( "theme-id" ); break; case 4: dumpUnused( 1 ); break; default: dumpUnknown( 1 ); } dumpDec< sal_Int16 >( "tint", "CONV-TINT" ); dumpColorABGR(); } void WorkbookStreamObject::dumpExtCfColor( const String& rName ) { MultiItemsGuard aMultiGuard( mxOut ); writeEmptyItem( rName( "color" ) ); dumpExtColorValue( dumpExtColorType< sal_uInt32 >() ); dumpDec< double >( "tint", "CONV-FLOAT-TO-PERC" ); } void WorkbookStreamObject::dumpExtGradientHead() { dumpDec< sal_Int32 >( "gradient-type", "EXTGRADIENT-TYPE" ); dumpDec< double >( "linear-angle" ); dumpDec< double >( "pos-left" ); dumpDec< double >( "pos-right" ); dumpDec< double >( "pos-top" ); dumpDec< double >( "pos-bottom" ); } sal_uInt8 WorkbookStreamObject::dumpFilterColumnOperator( const String& rName ) { sal_uInt8 nStrLen = 0; writeEmptyItem( rName ); IndentGuard aIndGuard( mxOut ); sal_uInt8 nType = dumpDec< sal_uInt8 >( "data-type", "FILTERCOLUMN-DATATYPE" ); dumpDec< sal_uInt8 >( "operator", "FILTERCOLUMN-OPERATOR" ); switch( nType ) { case 2: dumpRk( "value" ); dumpUnused( 4 ); break; case 4: dumpDec< double >( "value" ); break; case 6: dumpUnused( 4 ); nStrLen = dumpDec< sal_uInt8 >( "length" ); dumpBoolean( "simple" ); dumpUnused( 2 ); break; case 8: dumpBoolErr(); dumpUnused( 6 ); break; default: dumpUnused( 8 ); } return nStrLen; } OUString WorkbookStreamObject::dumpPivotString( const String& rName, sal_uInt16 nStrLen ) { OUString aString; if( nStrLen != BIFF_PT_NOSTRING ) { aString = (getBiff() == BIFF8) ? getBiffStream().readUniStringBody( nStrLen ) : getBiffStream().readCharArrayUC( nStrLen, getBiffData().getTextEncoding() ); writeStringItem( rName, aString ); } return aString; } OUString WorkbookStreamObject::dumpPivotString( const String& rName ) { sal_uInt16 nStrLen = dumpDec< sal_uInt16 >( "string-len", "PIVOT-NAMELEN" ); return dumpPivotString( rName, nStrLen ); } sal_uInt16 WorkbookStreamObject::dumpCellHeader( bool bBiff2Style ) { dumpAddress(); return dumpXfIdx( EMPTY_STRING, bBiff2Style ); } void WorkbookStreamObject::dumpBoolErr() { MultiItemsGuard aMultiGuard( mxOut ); sal_uInt8 nValue = dumpHex< sal_uInt8 >( "value" ); bool bErrCode = dumpBool< sal_uInt8 >( "is-error-code" ); if( bErrCode ) writeErrorCodeItem( "error-code", nValue ); else writeBooleanItem( "boolean", nValue ); } void WorkbookStreamObject::dumpCfRuleProp() { BiffInputStream& rStrm = getBiffStream(); sal_uInt32 nFlags1 = dumpHex< sal_uInt32 >( "flags-1", "CFRULE-FLAGS1" ); sal_uInt16 nFlags2 = dumpHex< sal_uInt16 >( "flags-2", "CFRULE-FLAGS2" ); if( getFlag< sal_uInt32 >( nFlags1, 0x02000000 ) ) { writeEmptyItem( "numfmt-block" ); IndentGuard aIndGuard( mxOut ); if( getFlag< sal_uInt16 >( nFlags2, 0x0001 ) ) { dumpDec< sal_uInt16 >( "size" ); dumpUniString( "numfmt" ); } else { dumpUnused( 1 ); dumpDec< sal_uInt8 >( "fmt-idx", mxFormats ); } } if( getFlag< sal_uInt32 >( nFlags1, 0x04000000 ) ) { writeEmptyItem( "font-block" ); IndentGuard aIndGuard( mxOut ); sal_Int64 nRecPos = rStrm.tell(); dumpUniString( "name", BIFF_STR_8BITLENGTH ); dumpUnused( static_cast< sal_Int32 >( nRecPos + 64 - rStrm.tell() ) ); dumpDec< sal_Int32 >( "height", "CONV-TWIP-TO-PT" ); dumpHex< sal_uInt32 >( "flags", "CFRULE-FONTFLAGS" ); dumpDec< sal_Int16 >( "weight", "CFRULE-FONTWEIGHT" ); dumpDec< sal_Int16 >( "escapement", "CFRULE-FONTESCAPEMENT" ); dumpDec< sal_Int8 >( "underline", "CFRULE-FONTUNDERLINE" ); dumpDec< sal_uInt8 >( "family", "FONT-FAMILY" ); dumpDec< sal_uInt8 >( "charset", "CHARSET" ); dumpUnused( 1 ); dumpDec< sal_Int32 >( "color", "CFRULE-FONTCOLOR" ); dumpUnused( 4 ); dumpHex< sal_uInt32 >( "used-flags", "CFRULE-FONTUSEDFLAGS" ); dumpDec< sal_uInt32 >( "escapement-used", "CFRULE-FONTUSED" ); dumpDec< sal_uInt32 >( "underline-used", "CFRULE-FONTUSED" ); dumpDec< sal_uInt32 >( "weight-used", "CFRULE-FONTUSED" ); dumpUnused( 4 ); dumpDec< sal_Int32 >( "first-char" ); dumpDec< sal_Int32 >( "char-count" ); dumpDec< sal_uInt16 >( "font-idx" ); } if( getFlag< sal_uInt32 >( nFlags1, 0x08000000 ) ) { writeEmptyItem( "alignment-block" ); IndentGuard aIndGuard( mxOut ); dumpHex< sal_uInt8 >( "alignent", "CFRULE-ALIGNMENT" ); dumpHex< sal_uInt8 >( "rotation", "TEXTROTATION" ); dumpHex< sal_uInt16 >( "indent", "CFRULE-INDENT" ); dumpDec< sal_Int32 >( "relative-indent" ); } if( getFlag< sal_uInt32 >( nFlags1, 0x10000000 ) ) { writeEmptyItem( "border-block" ); IndentGuard aIndGuard( mxOut ); dumpHex< sal_uInt16 >( "border-style", "XF-BORDERSTYLE" ); dumpHex< sal_uInt16 >( "border-color1", "XF-BORDERCOLOR1" ); dumpHex< sal_uInt32 >( "border-color2", "CFRULE-BORDERCOLOR2" ); } if( getFlag< sal_uInt32 >( nFlags1, 0x20000000 ) ) { writeEmptyItem( "pattern-block" ); IndentGuard aIndGuard( mxOut ); dumpHex< sal_uInt32 >( "pattern", "CFRULE-FILLBLOCK" ); } if( getFlag< sal_uInt32 >( nFlags1, 0x40000000 ) ) { writeEmptyItem( "protection-block" ); IndentGuard aIndGuard( mxOut ); dumpHex< sal_uInt16 >( "flags", "CFRULE-PROTECTION-FLAGS" ); } } void WorkbookStreamObject::dumpXfExtProp() { BiffInputStream& rStrm = getBiffStream(); for( sal_uInt16 nIndex = 0, nCount = dumpDec< sal_uInt16 >( "subrec-count" ); !rStrm.isEof() && (nIndex < nCount); ++nIndex ) { mxOut->startMultiItems(); sal_Int64 nStartPos = rStrm.tell(); writeEmptyItem( "SUBREC" ); sal_uInt16 nSubRecId = dumpDec< sal_uInt16 >( "id", "XFEXT-SUBREC" ); sal_uInt16 nSubRecSize = dumpDec< sal_uInt16 >( "size" ); sal_Int64 nEndPos = nStartPos + nSubRecSize; mxOut->endMultiItems(); IndentGuard aIndGuard( mxOut ); switch( nSubRecId ) { case 4: case 5: case 7: case 8: case 9: case 10: case 11: case 13: { sal_uInt16 nColorType = dumpExtColorType< sal_uInt16 >(); dumpDec< sal_Int16 >( "tint", "CONV-TINT" ); dumpExtColorValue( nColorType ); dumpUnused( 8 ); } break; case 6: dumpExtGradientHead(); mxOut->resetItemIndex(); for( sal_Int32 nStop = 0, nStopCount = dumpDec< sal_Int32 >( "stop-count" ); (nStop < nStopCount) && !mxStrm->isEof(); ++nStop ) { writeEmptyItem( "#stop" ); IndentGuard aIndGuard2( mxOut ); sal_uInt16 nColorType = dumpExtColorType< sal_uInt16 >(); dumpExtColorValue( nColorType ); dumpDec< double >( "stop-pos" ); dumpDec< double >( "tint", "CONV-FLOAT-TO-PERC" ); } break; case 14: dumpDec< sal_Int8 >( "font-scheme", "EXTFONT-SCHEME" ); break; case 15: dumpDec< sal_uInt16 >( "indent" ); break; } dumpRemainingTo( nEndPos ); } } void WorkbookStreamObject::dumpDxfProp() { BiffInputStream& rStrm = getBiffStream(); dumpUnused( 2 ); for( sal_uInt16 nIndex = 0, nCount = dumpDec< sal_uInt16 >( "subrec-count" ); !rStrm.isEof() && (nIndex < nCount); ++nIndex ) { mxOut->startMultiItems(); sal_Int64 nStartPos = rStrm.tell(); writeEmptyItem( "SUBREC" ); sal_uInt16 nSubRecId = dumpDec< sal_uInt16 >( "id", "DXF-SUBREC" ); sal_uInt16 nSubRecSize = dumpDec< sal_uInt16 >( "size" ); sal_Int64 nEndPos = nStartPos + nSubRecSize; mxOut->endMultiItems(); IndentGuard aIndGuard( mxOut ); switch( nSubRecId ) { case 0: dumpDec< sal_uInt8 >( "pattern", mxFillPatterns ); break; case 1: case 2: case 5: dumpExtColor(); break; case 3: dumpExtGradientHead(); break; case 4: dumpDec< sal_uInt16 >( "index" ); dumpDec< double >( "stop-position" ); dumpExtColor( "stop-color" ); break; case 6: case 7: case 8: case 9: case 10: case 11: case 12: dumpExtColor( "color" ); dumpDec< sal_uInt16 >( "style", mxBorderStyles ); break; case 13: case 14: dumpBoolean( "value" ); break; case 15: dumpDec< sal_uInt8 >( "alignment", "XF-HORALIGN" ); break; case 16: dumpDec< sal_uInt8 >( "alignment", "XF-VERALIGN" ); break; case 17: dumpDec< sal_uInt8 >( "rotation", "TEXTROTATION" ); break; case 18: dumpDec< sal_uInt16 >( "indent" ); break; case 19: dumpDec< sal_uInt8 >( "text-dir", "XF-TEXTDIRECTION" ); break; case 20: case 21: case 22: case 23: dumpBoolean( "value" ); break; case 24: dumpUnicodeArray( "name", rStrm.readuInt16() ); break; case 25: dumpDec< sal_uInt16 >( "weight", "FONT-WEIGHT" ); break; case 26: dumpDec< sal_uInt16 >( "underline", "FONT-UNDERLINE" ); break; case 27: dumpDec< sal_uInt16 >( "escapement", "FONT-ESCAPEMENT" ); break; case 28: case 29: case 30: case 31: case 32: case 33: dumpBoolean( "value" ); break; case 34: dumpDec< sal_uInt8 >( "charset", "CHARSET" ); break; case 35: dumpDec< sal_uInt8 >( "family", "FONT-FAMILY" ); break; case 36: dumpDec< sal_Int32 >( "height", "CONV-TWIP-TO-PT" ); break; case 37: dumpDec< sal_uInt8 >( "scheme", "EXTFONT-SCHEME" ); break; case 38: dumpUnicodeArray( "numfmt", rStrm.readuInt16() ); break; case 41: dumpDec< sal_uInt16 >( "fmt-idx", mxFormats ); break; case 42: dumpDec< sal_Int16 >( "relative-indent" ); break; case 43: case 44: dumpBoolean( "value" ); break; } dumpRemainingTo( nEndPos ); } } void WorkbookStreamObject::dumpDxf12Prop() { BiffInputStream& rStrm = getBiffStream(); writeEmptyItem( "dxf-data" ); IndentGuard aIndGuard( mxOut ); sal_uInt32 nSize = dumpDec< sal_uInt32 >( "dxf-size" ); if( nSize == 0 ) { dumpUnused( 2 ); } else { sal_Int64 nEndPos = rStrm.tell() + nSize; dumpCfRuleProp(); if( rStrm.tell() + 8 <= nEndPos ) { dumpUnused( 6 ); dumpXfExtProp(); } dumpRemainingTo( nEndPos ); } } void WorkbookStreamObject::dumpCfRule12Param( sal_uInt16 nSubType ) { sal_uInt8 nSize = dumpDec< sal_uInt8 >( "params-size" ); sal_Int64 nEndPos = getBiffStream().tell() + nSize; { writeEmptyItem( "params" ); IndentGuard aIndGuard( mxOut ); switch( nSubType ) { case 5: dumpHex< sal_uInt8 >( "flags", "CFRULE12-TOP10-FLAGS" ); dumpDec< sal_uInt16 >( "rank" ); dumpUnused( 13 ); break; case 8: dumpDec< sal_uInt16 >( "operator", "CFRULE12-TEXT-OPERATOR" ); dumpUnused( 14 ); break; case 15: case 16: case 17: case 18: case 19: case 20: case 21: case 22: case 23: case 24: dumpDec< sal_uInt16 >( "operator", "CFRULE12-DATE-OPERATOR" ); dumpUnused( 14 ); break; case 25: case 26: case 29: case 30: dumpDec< sal_uInt16 >( "std-dev" ); dumpUnused( 14 ); break; default: dumpUnused( 16 ); } } dumpRemainingTo( nEndPos ); } void WorkbookStreamObject::dumpFontRec() { sal_uInt16 nFontId = getBiffData().getFontCount(); mxOut->resetItemIndex( nFontId ); writeEmptyItem( "#font" ); sal_uInt16 nHeight = dumpDec< sal_uInt16 >( "height", "CONV-TWIP-TO-PT" ); sal_uInt16 nFlags = dumpHex< sal_uInt16 >( "flags", "FONT-FLAGS" ); bool bBold = getFlag( nFlags, BIFF_FONTFLAG_BOLD ); bool bItalic = getFlag( nFlags, BIFF_FONTFLAG_ITALIC ); rtl_TextEncoding eFontEnc = RTL_TEXTENCODING_DONTKNOW; if( getBiff() >= BIFF3 ) dumpColorIdx(); if( getBiff() >= BIFF5 ) { bBold = dumpDec< sal_uInt16 >( "weight", "FONT-WEIGHT" ) > 450; dumpDec< sal_uInt16 >( "escapement", "FONT-ESCAPEMENT" ); dumpDec< sal_uInt8 >( "underline", "FONT-UNDERLINE" ); dumpDec< sal_uInt8 >( "family", "FONT-FAMILY" ); sal_uInt8 nCharSet = dumpDec< sal_uInt8 >( "charset", "CHARSET" ); eFontEnc = rtl_getTextEncodingFromWindowsCharset( nCharSet ); dumpUnused( 1 ); } OUString aName = dumpString( "name", BIFF_STR_8BITLENGTH, BIFF_STR_8BITLENGTH ); // append font data to vector mxFontNames->setName( nFontId, createFontName( aName, nHeight, bBold, bItalic ) ); // store font encoding getBiffData().appendFontEncoding( eFontEnc ); // set font encoding as default text encoding in case of missing CODEPAGE record if( !mbHasCodePage && (nFontId == 0) ) getBiffData().setTextEncoding( eFontEnc ); } void WorkbookStreamObject::dumpFormatRec() { sal_uInt16 nFormatIdx = 0; switch( getBiff() ) { case BIFF2: case BIFF3: nFormatIdx = mnFormatIdx++; mxOut->resetItemIndex( nFormatIdx ); writeEmptyItem( "#fmt" ); break; case BIFF4: nFormatIdx = mnFormatIdx++; mxOut->resetItemIndex( nFormatIdx ); writeEmptyItem( "#fmt" ); dumpUnused( 2 ); break; case BIFF5: case BIFF8: getBiffStream() >> nFormatIdx; mxOut->resetItemIndex( nFormatIdx ); writeEmptyItem( "#fmt" ); writeDecItem( "fmt-idx", nFormatIdx ); break; case BIFF_UNKNOWN: break; } OUString aFormat = dumpString( "format", BIFF_STR_8BITLENGTH ); mxFormats->setName( nFormatIdx, aFormat ); } void WorkbookStreamObject::dumpXfRec() { sal_uInt16 nXfId = getBiffData().getXfCount(); mxOut->resetItemIndex( nXfId ); writeEmptyItem( "#xf" ); sal_uInt16 nFontId = dumpFontIdx( EMPTY_STRING, getBiff() >= BIFF5 ); switch( getBiff() ) { case BIFF2: dumpUnused( 1 ); dumpHex< sal_uInt8 >( "type-flags", "XF-TYPEFLAGS" ); dumpHex< sal_uInt8 >( "style-flags", "XF-STYLEFLAGS" ); break; case BIFF3: dumpFormatIdx(); dumpHex< sal_uInt8 >( "type-flags", "XF-TYPEFLAGS" ); dumpHex< sal_uInt8 >( "used-attributes", "XF-USEDATTRIBS-FLAGS" ); dumpHex< sal_uInt16 >( "alignment", "XF-ALIGNMENT" ); dumpHex< sal_uInt16 >( "fill-style", "XF-FILL" ); dumpHex< sal_uInt32 >( "border-style", "XF-BORDER" ); break; case BIFF4: dumpFormatIdx(); dumpHex< sal_uInt16 >( "type-flags", "XF-TYPEFLAGS" ); dumpHex< sal_uInt8 >( "alignment", "XF-ALIGNMENT" ); dumpHex< sal_uInt8 >( "used-attributes", "XF-USEDATTRIBS-FLAGS" ); dumpHex< sal_uInt16 >( "fill-style", "XF-FILL" ); dumpHex< sal_uInt32 >( "border-style", "XF-BORDER" ); break; case BIFF5: dumpFormatIdx(); dumpHex< sal_uInt16 >( "type-flags", "XF-TYPEFLAGS" ); dumpHex< sal_uInt8 >( "alignment", "XF-ALIGNMENT" ); dumpHex< sal_uInt8 >( "orientation", "XF-ORIENTATTRIBS" ); dumpHex< sal_uInt32 >( "fill-style", "XF-FILL" ); dumpHex< sal_uInt32 >( "border-style", "XF-BORDER" ); break; case BIFF8: dumpFormatIdx(); dumpHex< sal_uInt16 >( "type-flags", "XF-TYPEFLAGS" ); dumpHex< sal_uInt8 >( "alignment", "XF-ALIGNMENT" ); dumpDec< sal_uInt8 >( "rotation", "TEXTROTATION" ); dumpHex< sal_uInt8 >( "text-flags", "XF-TEXTFLAGS" ); dumpHex< sal_uInt8 >( "used-attributes", "XF-USEDATTRIBS-FLAGS" ); dumpHex< sal_uInt16 >( "border-style", "XF-BORDERSTYLE" ); dumpHex< sal_uInt16 >( "border-color1", "XF-BORDERCOLOR1" ); dumpHex< sal_uInt32 >( "border-color2", "XF-BORDERCOLOR2" ); dumpHex< sal_uInt16 >( "fill-color", "XF-FILLCOLOR" ); break; case BIFF_UNKNOWN: break; } getBiffData().appendXfFontId( nFontId ); } void WorkbookStreamObject::dumpObjRec() { switch( getBiff() ) { case BIFF3: dumpObjRecBiff3(); break; case BIFF4: dumpObjRecBiff4(); break; case BIFF5: dumpObjRecBiff5(); break; case BIFF8: // #i61786# OBJ records without DFF stream are in BIFF5 format if( mbHasDff ) dumpObjRecBiff8(); else dumpObjRecBiff5(); break; default:; } } void WorkbookStreamObject::dumpObjRecBiff3() { dumpDec< sal_uInt32 >( "obj-count" ); sal_uInt16 nObjType = dumpDec< sal_uInt16 >( "obj-type", "OBJ-TYPE" ); dumpDec< sal_uInt16 >( "obj-id" ); dumpHex< sal_uInt16 >( "flags", "OBJ-FLAGS" ); dumpDffClientRect(); sal_uInt16 nMacroSize = dumpDec< sal_uInt16 >( "macro-size" ); dumpUnused( 2 ); sal_uInt16 nTextLen = 0, nFormatSize = 0, nLinkSize = 0; switch( nObjType ) { case BIFF_OBJTYPE_GROUP: dumpUnused( 4 ); dumpDec< sal_uInt16 >( "next-ungrouped-id" ); dumpUnused( 16 ); dumpObjRecString( "macro", nMacroSize, true ); break; case BIFF_OBJTYPE_LINE: dumpObjRecLineData(); dumpHex< sal_uInt16 >( "line-end", "OBJ-LINEENDS" ); dumpDec< sal_uInt8 >( "line-direction", "OBJ-LINEDIR" ); dumpUnused( 1 ); dumpObjRecString( "macro", nMacroSize, true ); break; case BIFF_OBJTYPE_RECTANGLE: case BIFF_OBJTYPE_OVAL: dumpObjRecRectData(); dumpObjRecString( "macro", nMacroSize, true ); break; case BIFF_OBJTYPE_ARC: dumpObjRecFillData(); dumpObjRecLineData(); dumpDec< sal_uInt8 >( "quadrant", "OBJ-ARC-QUADRANT" ); dumpUnused( 1 ); dumpObjRecString( "macro", nMacroSize, true ); break; case BIFF_OBJTYPE_CHART: dumpObjRecRectData(); dumpUnused( 18 ); dumpObjRecString( "macro", nMacroSize, true ); break; case BIFF_OBJTYPE_TEXT: case BIFF_OBJTYPE_BUTTON: dumpObjRecRectData(); dumpObjRecTextDataBiff3( nTextLen, nFormatSize ); dumpObjRecString( "macro", nMacroSize, true ); dumpObjRecString( "text", nTextLen, false ); dumpObjRecTextFmt( nFormatSize ); break; case BIFF_OBJTYPE_PICTURE: dumpObjRecRectData(); dumpDec< sal_Int16 >( "image-format", "IMGDATA-FORMAT" ); dumpUnused( 4 ); nLinkSize = dumpDec< sal_uInt16 >( "pic-link-size" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "flags", "OBJ-PICTURE-FLAGS" ); dumpObjRecString( "macro", nMacroSize, true ); dumpObjRecPictFmla( nLinkSize ); break; } } void WorkbookStreamObject::dumpObjRecBiff4() { dumpDec< sal_uInt32 >( "obj-count" ); sal_uInt16 nObjType = dumpDec< sal_uInt16 >( "obj-type", "OBJ-TYPE" ); dumpDec< sal_uInt16 >( "obj-id" ); dumpHex< sal_uInt16 >( "flags", "OBJ-FLAGS" ); dumpDffClientRect(); sal_uInt16 nMacroSize = dumpDec< sal_uInt16 >( "macro-size" ); dumpUnused( 2 ); sal_uInt16 nTextLen = 0, nFormatSize = 0, nLinkSize = 0; switch( nObjType ) { case BIFF_OBJTYPE_GROUP: dumpUnused( 4 ); dumpDec< sal_uInt16 >( "next-ungrouped-id" ); dumpUnused( 16 ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_LINE: dumpObjRecLineData(); dumpHex< sal_uInt16 >( "line-end", "OBJ-LINEENDS" ); dumpDec< sal_uInt8 >( "line-direction", "OBJ-LINEDIR" ); dumpUnused( 1 ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_RECTANGLE: case BIFF_OBJTYPE_OVAL: dumpObjRecRectData(); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_ARC: dumpObjRecFillData(); dumpObjRecLineData(); dumpDec< sal_uInt8 >( "quadrant", "OBJ-ARC-QUADRANT" ); dumpUnused( 1 ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_CHART: dumpObjRecRectData(); dumpUnused( 18 ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_TEXT: case BIFF_OBJTYPE_BUTTON: dumpObjRecRectData(); dumpObjRecTextDataBiff3( nTextLen, nFormatSize ); dumpObjRecFmla( "macro", nMacroSize ); dumpObjRecString( "text", nTextLen, false ); dumpObjRecTextFmt( nFormatSize ); break; case BIFF_OBJTYPE_PICTURE: dumpObjRecRectData(); dumpDec< sal_Int16 >( "image-format", "IMGDATA-FORMAT" ); dumpUnused( 4 ); nLinkSize = dumpDec< sal_uInt16 >( "pic-link-size" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "flags", "OBJ-PICTURE-FLAGS" ); dumpObjRecFmla( "macro", nMacroSize ); dumpObjRecPictFmla( nLinkSize ); break; case BIFF_OBJTYPE_POLYGON: dumpObjRecRectData(); dumpHex< sal_uInt16 >( "flags", "OBJ-POLYGON-FLAGS" ); dumpUnused( 10 ); dumpDec< sal_uInt16 >( "point-count" ); dumpUnused( 8 ); dumpObjRecFmla( "macro", nMacroSize ); break; } } void WorkbookStreamObject::dumpObjRecBiff5() { BiffInputStream& rStrm = getBiffStream(); dumpDec< sal_uInt32 >( "obj-count" ); sal_uInt16 nObjType = dumpDec< sal_uInt16 >( "obj-type", "OBJ-TYPE" ); dumpDec< sal_uInt16 >( "obj-id" ); dumpHex< sal_uInt16 >( "flags", "OBJ-FLAGS" ); dumpDffClientRect(); sal_uInt16 nMacroSize = dumpDec< sal_uInt16 >( "macro-size" ); dumpUnused( 2 ); sal_uInt16 nNameLen = dumpDec< sal_uInt16 >( "name-len" ); dumpUnused( 2 ); sal_uInt16 nTextLen = 0, nFormatSize = 0, nLinkSize = 0; switch( nObjType ) { case BIFF_OBJTYPE_GROUP: dumpUnused( 4 ); dumpDec< sal_uInt16 >( "next-ungrouped-id" ); dumpUnused( 16 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_LINE: dumpObjRecLineData(); dumpHex< sal_uInt16 >( "line-end", "OBJ-LINEENDS" ); dumpDec< sal_uInt8 >( "line-direction", "OBJ-LINEDIR" ); dumpUnused( 1 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_RECTANGLE: case BIFF_OBJTYPE_OVAL: dumpObjRecRectData(); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_ARC: dumpObjRecFillData(); dumpObjRecLineData(); dumpDec< sal_uInt8 >( "quadrant", "OBJ-ARC-QUADRANT" ); dumpUnused( 1 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_CHART: dumpObjRecRectData(); dumpHex< sal_uInt16 >( "chart-flags", "OBJ-CHART-FLAGS" ); dumpUnused( 16 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_TEXT: case BIFF_OBJTYPE_BUTTON: case BIFF_OBJTYPE_LABEL: case BIFF_OBJTYPE_DIALOG: dumpObjRecRectData(); dumpObjRecTextDataBiff5( nTextLen, nFormatSize, nLinkSize ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); dumpObjRecString( "text", nTextLen, false ); dumpObjRecFmla( "text-link", nLinkSize ); dumpObjRecTextFmt( nFormatSize ); break; case BIFF_OBJTYPE_PICTURE: dumpObjRecRectData(); dumpDec< sal_Int16 >( "image-format", "IMGDATA-FORMAT" ); dumpUnused( 4 ); nLinkSize = dumpDec< sal_uInt16 >( "pic-link-size" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "flags", "OBJ-PICTURE-FLAGS" ); dumpUnused( 4 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); dumpObjRecPictFmla( nLinkSize ); if( rStrm.getRemaining() >= 4 ) dumpHex< sal_uInt32 >( "ole-storage-id" ); break; case BIFF_OBJTYPE_POLYGON: dumpObjRecRectData(); dumpHex< sal_uInt16 >( "flags", "OBJ-POLYGON-FLAGS" ); dumpUnused( 10 ); dumpDec< sal_uInt16 >( "point-count" ); dumpUnused( 8 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", nMacroSize ); break; case BIFF_OBJTYPE_CHECKBOX: dumpObjRecRectData(); dumpUnused( 10 ); dumpHex< sal_uInt16 >( "flags", "OBJ-TEXT-FLAGS" ); dumpUnused( 20 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", dumpDec< sal_uInt16 >( "macro-size" ) ); dumpObjRecFmla( "cell-link", dumpDec< sal_uInt16 >( "cell-link-size" ) ); dumpObjRecString( "text", dumpDec< sal_uInt16 >( "text-len" ), false ); dumpObjRecCblsData(); break; case BIFF_OBJTYPE_OPTIONBUTTON: dumpObjRecRectData(); dumpUnused( 10 ); dumpHex< sal_uInt16 >( "flags", "OBJ-TEXT-FLAGS" ); dumpUnused( 32 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", dumpDec< sal_uInt16 >( "macro-size" ) ); dumpObjRecFmla( "cell-link", dumpDec< sal_uInt16 >( "cell-link-size" ) ); dumpObjRecString( "text", dumpDec< sal_uInt16 >( "text-len" ), false ); dumpObjRecCblsData(); dumpObjRecRboData(); break; case BIFF_OBJTYPE_EDIT: dumpObjRecRectData(); dumpUnused( 10 ); dumpHex< sal_uInt16 >( "flags", "OBJ-TEXT-FLAGS" ); dumpUnused( 14 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", dumpDec< sal_uInt16 >( "macro-size" ) ); dumpObjRecString( "text", dumpDec< sal_uInt16 >( "text-len" ), false ); dumpObjRecEdoData(); break; case BIFF_OBJTYPE_SPIN: case BIFF_OBJTYPE_SCROLLBAR: dumpObjRecRectData(); dumpObjRecSbsData(); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", dumpDec< sal_uInt16 >( "macro-size" ) ); dumpObjRecFmla( "cell-link", dumpDec< sal_uInt16 >( "cell-link-size" ) ); break; case BIFF_OBJTYPE_LISTBOX: dumpObjRecRectData(); dumpObjRecSbsData(); dumpUnused( 18 ); dumpFontIdx( "font-idx" ); dumpUnused( 4 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", dumpDec< sal_uInt16 >( "macro-size" ) ); dumpObjRecFmla( "cell-link", dumpDec< sal_uInt16 >( "cell-link-size" ) ); dumpObjRecLbsData(); break; case BIFF_OBJTYPE_GROUPBOX: dumpObjRecRectData(); dumpUnused( 10 ); dumpHex< sal_uInt16 >( "flags", "OBJ-TEXT-FLAGS" ); dumpUnused( 26 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", dumpDec< sal_uInt16 >( "macro-size" ) ); dumpObjRecString( "text", dumpDec< sal_uInt16 >( "text-len" ), false ); dumpObjRecGboData(); break; case BIFF_OBJTYPE_DROPDOWN: dumpObjRecRectData(); dumpObjRecSbsData(); dumpUnused( 18 ); dumpFontIdx( "font-idx" ); dumpUnused( 14 ); dumpDec< sal_uInt16 >( "bounding-left" ); dumpDec< sal_uInt16 >( "bounding-top" ); dumpDec< sal_uInt16 >( "bounding-right" ); dumpDec< sal_uInt16 >( "bounding-bottom" ); dumpUnused( 4 ); dumpObjRecString( "obj-name", nNameLen, true ); dumpObjRecFmla( "macro", dumpDec< sal_uInt16 >( "macro-size" ) ); dumpObjRecFmla( "cell-link", dumpDec< sal_uInt16 >( "cell-link-size" ) ); dumpObjRecLbsData(); dumpDec< sal_uInt16 >( "type", "OBJ-DROPDOWN-TYPE" ); dumpDec< sal_uInt16 >( "line-count" ); dumpDec< sal_uInt16 >( "min-list-width" ); dumpObjRecString( "text", dumpDec< sal_uInt16 >( "text-len" ), false ); break; } } void WorkbookStreamObject::dumpObjRecBiff8() { BiffInputStream& rStrm = getBiffStream(); NameListRef xRecNames = cfg().getNameList( "OBJ-RECNAMES" ); sal_uInt16 nObjType = 0xFFFF; bool bControl = false; bool bCtlsStrm = false; bool bLoop = true; while( bLoop && (rStrm.getRemaining() >= 4) ) { mxOut->emptyLine(); sal_uInt16 nSubRecId, nSubRecSize; { MultiItemsGuard aMultiGuard( mxOut ); writeEmptyItem( "OBJREC" ); writeHexItem( "pos", static_cast< sal_uInt32 >( rStrm.tell() ) ); rStrm >> nSubRecId >> nSubRecSize; writeHexItem( "size", nSubRecSize ); writeHexItem( "id", nSubRecId, xRecNames ); } sal_Int64 nSubRecStart = rStrm.tell(); // sometimes the last subrecord has an invalid length sal_Int64 nRealRecSize = ::std::min< sal_Int64 >( nSubRecSize, rStrm.getRemaining() ); sal_Int64 nSubRecEnd = nSubRecStart + nRealRecSize; IndentGuard aIndGuard( mxOut ); switch( nSubRecId ) { case BIFF_ID_OBJMACRO: dumpObjRecFmlaRaw(); break; case BIFF_ID_OBJCF: dumpDec< sal_Int16 >( "clipboard-format", "IMGDATA-FORMAT" ); break; case BIFF_ID_OBJFLAGS: { sal_uInt16 nFlags = dumpHex< sal_uInt16 >( "flags", "OBJFLAGS-FLAGS" ); bControl = getFlag( nFlags, BIFF_OBJFLAGS_CONTROL ); bCtlsStrm = getFlag( nFlags, BIFF_OBJFLAGS_CTLSSTREAM ); } break; case BIFF_ID_OBJPICTFMLA: { dumpObjRecPictFmla( dumpDec< sal_uInt16 >( "pic-link-size" ) ); if( rStrm.tell() + 4 <= nSubRecEnd ) { if( bControl && bCtlsStrm ) dumpControl(); else dumpHex< sal_uInt32 >( "ole-storage-id" ); } if( bControl && (rStrm.tell() + 8 <= nSubRecEnd) ) { sal_uInt32 nKeySize = dumpDec< sal_uInt32 >( "licence-key-size" ); if( nKeySize > 0 ) { IndentGuard aIndGuard2( mxOut ); sal_Int64 nKeyEnd = rStrm.tell() + nKeySize; dumpArray( "licence-key", static_cast< sal_Int32 >( nKeySize ) ); rStrm.seek( nKeyEnd ); } dumpObjRecFmla( "cell-link", dumpDec< sal_uInt16 >( "cell-link-size" ) ); dumpObjRecFmla( "source-range", dumpDec< sal_uInt16 >( "source-range-size" ) ); } } break; case BIFF_ID_OBJCBLS: dumpDec< sal_uInt16 >( "state", "OBJ-CHECKBOX-STATE" ); dumpUnused( 4 ); dumpUnicode( "accelerator" ); dumpUnicode( "fareast-accelerator" ); dumpHex< sal_uInt16 >( "checkbox-flags", "OBJ-CHECKBOX-FLAGS" ); break; case BIFF_ID_OBJRBO: dumpUnused( 4 ); dumpBool< sal_uInt16 >( "first-in-group" ); break; case BIFF_ID_OBJSBS: dumpObjRecSbsData(); break; case BIFF_ID_OBJGBODATA: dumpObjRecGboData(); break; case BIFF_ID_OBJEDODATA: dumpObjRecEdoData(); break; case BIFF_ID_OBJRBODATA: dumpObjRecRboData(); break; case BIFF_ID_OBJCBLSDATA: dumpObjRecCblsData(); break; case BIFF_ID_OBJLBSDATA: dumpObjRecLbsData(); if( nObjType == BIFF_OBJTYPE_DROPDOWN ) { dumpHex< sal_uInt16 >( "dropdown-flags", "OBJ-DROPDOWN-FLAGS" ); dumpDec< sal_uInt16 >( "line-count" ); dumpDec< sal_uInt16 >( "min-list-width" ); dumpObjRecString( "text", dumpDec< sal_uInt16 >( "text-len" ), false ); } break; case BIFF_ID_OBJCBLSFMLA: case BIFF_ID_OBJSBSFMLA: dumpObjRecFmlaRaw(); break; case BIFF_ID_OBJCMO: nObjType = dumpDec< sal_uInt16 >( "type", "OBJ-TYPE" ); dumpDec< sal_uInt16 >( "id" ); dumpHex< sal_uInt16 >( "flags", "OBJCMO-FLAGS" ); dumpUnused( 12 ); break; } // remaining undumped data if( !rStrm.isEof() && (rStrm.tell() == nSubRecStart) ) dumpRawBinary( nRealRecSize, false ); else dumpRemainingTo( nSubRecEnd ); } } void WorkbookStreamObject::dumpObjRecLineData() { dumpColorIdx( "line-color-idx", false ); dumpDec< sal_uInt8 >( "line-type", "OBJ-LINETYPE" ); dumpDec< sal_uInt8 >( "line-weight", "OBJ-LINEWEIGHT" ); dumpHex< sal_uInt8 >( "line-flags", "OBJ-AUTO-FLAGS" ); } void WorkbookStreamObject::dumpObjRecFillData() { dumpColorIdx( "back-color-idx", false ); dumpColorIdx( "patt-color-idx", false ); dumpPatternIdx( EMPTY_STRING, false ); dumpHex< sal_uInt8 >( "area-flags", "OBJ-AUTO-FLAGS" ); } void WorkbookStreamObject::dumpObjRecRectData() { dumpObjRecFillData(); dumpObjRecLineData(); dumpHex< sal_uInt16 >( "frame-style", "OBJ-FRAMESTYLE-FLAGS" ); } void WorkbookStreamObject::dumpObjRecTextDataBiff3( sal_uInt16& ornTextLen, sal_uInt16& ornFormatSize ) { ornTextLen = dumpDec< sal_uInt16 >( "text-len" ); dumpUnused( 2 ); ornFormatSize = dumpDec< sal_uInt16 >( "format-run-size" ); dumpFontIdx( "default-font-idx" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "flags", "OBJ-TEXT-FLAGS" ); dumpDec< sal_uInt16 >( "orientation", "TEXTORIENTATION" ); dumpUnused( 8 ); } void WorkbookStreamObject::dumpObjRecTextDataBiff5( sal_uInt16& ornTextLen, sal_uInt16& ornFormatSize, sal_uInt16& ornLinkSize ) { ornTextLen = dumpDec< sal_uInt16 >( "text-len" ); dumpUnused( 2 ); ornFormatSize = dumpDec< sal_uInt16 >( "format-run-size" ); dumpFontIdx( "default-font-idx" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "flags", "OBJ-TEXT-FLAGS" ); dumpDec< sal_uInt16 >( "orientation", "TEXTORIENTATION" ); dumpUnused( 2 ); ornLinkSize = dumpDec< sal_uInt16 >( "link-size" ); dumpUnused( 2 ); dumpHex< sal_uInt16 >( "button-flags", "OBJ-BUTTON-FLAGS" ); dumpUnicode( "accelerator" ); dumpUnicode( "fareast-accelerator" ); } void WorkbookStreamObject::dumpObjRecSbsData() { dumpUnused( 4 ); dumpDec< sal_uInt16 >( "value" ); dumpDec< sal_uInt16 >( "min" ); dumpDec< sal_uInt16 >( "max" ); dumpDec< sal_uInt16 >( "step" ); dumpDec< sal_uInt16 >( "page-step" ); dumpBool< sal_uInt16 >( "horizontal" ); dumpDec< sal_uInt16 >( "thumb-width" ); dumpHex< sal_uInt16 >( "scrollbar-flags", "OBJ-SCROLLBAR-FLAGS" ); } void WorkbookStreamObject::dumpObjRecGboData() { dumpUnicode( "accelerator" ); dumpUnicode( "fareast-accelerator" ); dumpHex< sal_uInt16 >( "groupbox-flags", "OBJ-GROUPBOX-FLAGS" ); } void WorkbookStreamObject::dumpObjRecEdoData() { dumpDec< sal_uInt16 >( "type", "OBJ-EDIT-TYPE" ); dumpBool< sal_uInt16 >( "multiline" ); dumpBool< sal_uInt16 >( "scrollbar" ); dumpDec< sal_uInt16 >( "listbox-obj-id" ); } void WorkbookStreamObject::dumpObjRecRboData() { dumpDec< sal_uInt16 >( "next-in-group" ); dumpBool< sal_uInt16 >( "first-in-group" ); } void WorkbookStreamObject::dumpObjRecCblsData() { dumpDec< sal_uInt16 >( "state", "OBJ-CHECKBOX-STATE" ); dumpUnicode( "accelerator" ); dumpUnicode( "fareast-accelerator" ); dumpHex< sal_uInt16 >( "checkbox-flags", "OBJ-CHECKBOX-FLAGS" ); } void WorkbookStreamObject::dumpObjRecLbsData() { dumpObjRecFmla( "source-range", dumpDec< sal_uInt16 >( "source-range-size" ) ); dumpDec< sal_uInt16 >( "entry-count" ); dumpDec< sal_uInt16 >( "selected-entry" ); dumpHex< sal_uInt16 >( "listbox-flags", "OBJ-LISTBOX-FLAGS" ); dumpDec< sal_uInt16 >( "edit-obj-id" ); } void WorkbookStreamObject::dumpObjRecPadding() { if( getBiffStream().tell() & 1 ) { IndentGuard aIndGuard( mxOut ); dumpHex< sal_uInt8 >( "padding" ); } } void WorkbookStreamObject::dumpObjRecString( const String& rName, sal_uInt16 nTextLen, bool bRepeatLen ) { if( nTextLen > 0 ) { if( bRepeatLen ) dumpByteString( rName, BIFF_STR_8BITLENGTH ); else writeStringItem( rName, getBiffStream().readCharArrayUC( nTextLen, getBiffData().getTextEncoding() ) ); dumpObjRecPadding(); } } void WorkbookStreamObject::dumpObjRecTextFmt( sal_uInt16 nFormatSize ) { FontPortionModelList aPortions; aPortions.importPortions( getBiffStream(), nFormatSize / 8, BIFF_FONTPORTION_OBJ ); writeFontPortions( aPortions ); } void WorkbookStreamObject::dumpObjRecFmlaRaw() { sal_uInt16 nFmlaSize = dumpDec< sal_uInt16 >( "fmla-size" ); dumpUnused( 4 ); getFormulaDumper().dumpNameFormula( "fmla", nFmlaSize ); dumpObjRecPadding(); } void WorkbookStreamObject::dumpObjRecFmla( const String& rName, sal_uInt16 nFmlaSize ) { BiffInputStream& rStrm = getBiffStream(); if( nFmlaSize > 0 ) { writeEmptyItem( rName ); IndentGuard aIndGuard( mxOut ); sal_Int64 nStrmEnd = rStrm.tell() + nFmlaSize; dumpObjRecFmlaRaw(); if( rStrm.isEof() || (rStrm.tell() != nStrmEnd) ) writeEmptyItem( OOX_DUMP_ERRASCII( "fmla-size" ) ); dumpRemainingTo( nStrmEnd ); } } void WorkbookStreamObject::dumpObjRecPictFmla( sal_uInt16 nFmlaSize ) { BiffInputStream& rStrm = getBiffStream(); if( nFmlaSize > 0 ) { writeEmptyItem( "pic-link" ); IndentGuard aIndGuard( mxOut ); sal_Int64 nStrmEnd = rStrm.tell() + nFmlaSize; if( (getBiff() == BIFF3) && (nStrmEnd & 1) ) ++nStrmEnd; // BIFF3 size without padding dumpObjRecFmlaRaw(); if( rStrm.tell() + 2 <= nStrmEnd ) { dumpString( "class-name", BIFF_STR_DEFAULT, BIFF_STR_SMARTFLAGS ); dumpObjRecPadding(); } if( rStrm.isEof() || (rStrm.tell() != nStrmEnd) ) writeEmptyItem( OOX_DUMP_ERRASCII( "pic-link-size" ) ); dumpRemainingTo( nStrmEnd ); } } void WorkbookStreamObject::dumpChFrExtProps() { BiffInputStream& rStrm = getBiffStream(); bool bValid = true; while( bValid && (rStrm.getRemaining() > 4) ) { ChFrExtPropInfo aInfo = dumpChFrExtPropHeader(); IndentGuard aIndGuard( mxOut ); switch( aInfo.first ) { case 0: // start case 1: // end break; case 2: // bool dumpBoolean( "value" ); dumpUnused( 1 ); break; case 3: // double dumpUnused( 4 ); dumpDec< double >( "value", aInfo.second ); break; case 4: // int32 dumpDec< sal_Int32 >( "value", aInfo.second ); break; case 5: // string dumpUnicodeArray( "value", rStrm.readInt32() ); break; case 6: // uint16 dumpDec< sal_uInt16 >( "value", aInfo.second ); break; case 7: // blob dumpBinary( "value", rStrm.readuInt32() ); break; default: bValid = false; } } } WorkbookStreamObject::ChFrExtPropInfo WorkbookStreamObject::dumpChFrExtPropHeader() { MultiItemsGuard aMultiGuard( mxOut ); ChFrExtPropInfo aInfo; aInfo.first = dumpDec< sal_uInt8 >( "datatype", "CHFREXTPROPS-TYPE" ); dumpUnused( 1 ); sal_uInt16 nTag = dumpDec< sal_uInt16 >( "tag", "CHFREXTPROPS-TAG" ); aInfo.second = cfg().getName( "CHFREXTPROPS-TAG-NAMELIST", nTag ); return aInfo; } // ============================================================================ PivotCacheStreamObject::PivotCacheStreamObject( const ObjectBase& rParent, const BinaryInputStreamRef& rxStrm, BiffType eBiff, const ::rtl::OUString& rSysFileName ) { RecordStreamObject::construct( rParent, rxStrm, eBiff, rSysFileName ); } void PivotCacheStreamObject::implDumpRecordBody() { BiffInputStream& rStrm = getBiffStream(); sal_uInt16 nRecId = rStrm.getRecId(); switch( nRecId ) { case BIFF_ID_PCDEFINITION: dumpDec< sal_Int32 >( "source-records" ); dumpHex< sal_uInt16 >( "cache-id" ); dumpHex< sal_uInt16 >( "flags", "PCDEFINITION-FLAGS" ); dumpUnused( 2 ); dumpDec< sal_uInt16 >( "sourcedata-field-count" ); dumpDec< sal_uInt16 >( "cache-field-count" ); dumpDec< sal_uInt16 >( "report-record-count" ); dumpDec< sal_uInt16 >( "database-type", "PCDSOURCE-TYPE" ); dumpString( "user-name" ); break; case BIFF_ID_PCDEFINITION2: dumpDec< double >( "refreshed-date" ); dumpDec< sal_Int32 >( "formula-count" ); break; case BIFF_ID_PCDFDISCRETEPR: mxOut->resetItemIndex(); while( !rStrm.isEof() && (rStrm.getRemaining() >= 2) ) dumpDec< sal_uInt16 >( "#item-index" ); break; case BIFF_ID_PCDFIELD: dumpHex< sal_uInt16 >( "flags", "PCDFIELD-FLAGS" ); dumpDec< sal_uInt16 >( "group-parent-field" ); dumpDec< sal_uInt16 >( "group-base-field" ); dumpDec< sal_uInt16 >( "unique-items" ); dumpDec< sal_uInt16 >( "group-items" ); dumpDec< sal_uInt16 >( "base-items" ); dumpDec< sal_uInt16 >( "shared-items" ); if( rStrm.getRemaining() >= 3 ) dumpString( "item-name" ); break; case BIFF_ID_PCITEM_DATE: { DateTime aDateTime; aDateTime.Year = mxStrm->readuInt16(); aDateTime.Month = mxStrm->readuInt16(); aDateTime.Day = mxStrm->readuInt8(); aDateTime.Hours = mxStrm->readuInt8(); aDateTime.Minutes = mxStrm->readuInt8(); aDateTime.Seconds = mxStrm->readuInt8(); writeDateTimeItem( "value", aDateTime ); } break; case BIFF_ID_PCITEM_STRING: dumpString( "value" ); break; } } // ============================================================================ // ============================================================================ RootStorageObject::RootStorageObject( const DumperBase& rParent ) { OleStorageObject::construct( rParent ); addPreferredStream( "Book" ); addPreferredStream( "Workbook" ); } void RootStorageObject::implDumpStream( const Reference< XInputStream >& rxStrm, const OUString& rStrgPath, const OUString& rStrmName, const OUString& rSysFileName ) { if( (rStrgPath.getLength() == 0) && (rStrmName.equalsAscii( "Book" ) || rStrmName.equalsAscii( "Workbook" )) ) WorkbookStreamObject( *this, rxStrm, rSysFileName ).dump(); else if( rStrgPath.equalsAscii( "_SX_DB" ) ) PivotCacheStreamObject( *this, rxStrm, BIFF5, rSysFileName ).dump(); else if( rStrgPath.equalsAscii( "_SX_DB_CUR" ) ) PivotCacheStreamObject( *this, rxStrm, BIFF8, rSysFileName ).dump(); else OleStorageObject::implDumpStream( rxStrm, rStrgPath, rStrmName, rSysFileName ); } void RootStorageObject::implDumpStorage( const StorageRef& rxStrg, const OUString& rStrgPath, const OUString& rSysPath ) { if( rStrgPath.equalsAscii( "_VBA_PROJECT_CUR" ) ) VbaProjectStorageObject( *this, rxStrg, rSysPath ).dump(); else if( rStrgPath.matchAsciiL( RTL_CONSTASCII_STRINGPARAM( "MBD" ) ) ) VbaContainerStorageObject( *this, rxStrg, rSysPath ).dump(); else OleStorageObject::implDumpStorage( rxStrg, rStrgPath, rSysPath ); } void RootStorageObject::implDumpBaseStream( const BinaryInputStreamRef& rxStrm, const OUString& rSysFileName ) { WorkbookStreamObject( *this, rxStrm, rSysFileName ).dump(); } // ============================================================================ // ============================================================================ #define DUMP_BIFF_CONFIG_ENVVAR "OOO_BIFFDUMPER" Dumper::Dumper( const FilterBase& rFilter ) { ConfigRef xCfg( new Config( DUMP_BIFF_CONFIG_ENVVAR, rFilter ) ); DumperBase::construct( xCfg ); } Dumper::Dumper( const Reference< XComponentContext >& rxContext, const Reference< XInputStream >& rxInStrm, const OUString& rSysFileName ) { if( rxContext.is() && rxInStrm.is() ) { StorageRef xStrg( new ::oox::ole::OleStorage( rxContext, rxInStrm, true ) ); MediaDescriptor aMediaDesc; ConfigRef xCfg( new Config( DUMP_BIFF_CONFIG_ENVVAR, rxContext, xStrg, rSysFileName, aMediaDesc ) ); DumperBase::construct( xCfg ); } } void Dumper::implDump() { RootStorageObject( *this ).dump(); } // ============================================================================ // ============================================================================ } // namespace biff } // namespace dump } // namespace oox #endif