diff options
Diffstat (limited to 'sc/source/filter/excel/excform.cxx')
-rw-r--r-- | sc/source/filter/excel/excform.cxx | 476 |
1 files changed, 238 insertions, 238 deletions
diff --git a/sc/source/filter/excel/excform.cxx b/sc/source/filter/excel/excform.cxx index 0652363e8822..cf22c81a38b8 100644 --- a/sc/source/filter/excel/excform.cxx +++ b/sc/source/filter/excel/excform.cxx @@ -1,7 +1,7 @@ /************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -55,14 +55,14 @@ void ImportExcel::Formula25() { XclAddress aXclPos; UINT16 nXF = 0, nFormLen; - double fCurVal; - BYTE nAttr0, nFlag0; - BOOL bShrFmla; + double fCurVal; + BYTE nAttr0, nFlag0; + BOOL bShrFmla; aIn >> aXclPos; if( GetBiff() == EXC_BIFF2 ) - {// BIFF2 + {// BIFF2 BYTE nDummy; aIn.Ignore( 3 ); @@ -72,16 +72,16 @@ void ImportExcel::Formula25() aIn >> nDummy; nFormLen = nDummy; bShrFmla = FALSE; - nAttr0 = 0x01; // Always calculate + nAttr0 = 0x01; // Always calculate } else - {// BIFF5 + {// BIFF5 aIn >> nXF >> fCurVal >> nFlag0; aIn.Ignore( 5 ); aIn >> nFormLen; - bShrFmla = nFlag0 & 0x08; // shared or not shared + bShrFmla = nFlag0 & 0x08; // shared or not shared } nLastXF = nXF; @@ -100,8 +100,8 @@ void ImportExcel::Formula4() { XclAddress aXclPos; UINT16 nXF, nFormLen; - double fCurVal; - BYTE nFlag0; + double fCurVal; + BYTE nFlag0; aIn >> aXclPos >> nXF >> fCurVal >> nFlag0; aIn.Ignore( 1 ); @@ -123,7 +123,7 @@ void ImportExcel::Formula( const XclAddress& rXclPos, { // jetzt steht Lesemarke auf Formel, Laenge in nFormLen const ScTokenArray* pErgebnis = 0; - BOOL bConvert; + BOOL bConvert; pFormConv->Reset( aScPos ); @@ -135,7 +135,7 @@ void ImportExcel::Formula( const XclAddress& rXclPos, if( bConvert ) eErr = pFormConv->Convert( pErgebnis, maStrm, nFormLen, true, FT_CellFormula); - ScFormulaCell* pZelle = NULL; + ScFormulaCell* pZelle = NULL; if( pErgebnis ) { @@ -144,8 +144,8 @@ void ImportExcel::Formula( const XclAddress& rXclPos, } else { - CellType eCellType; - ScBaseCell* pBaseCell; + CellType eCellType; + ScBaseCell* pBaseCell; pD->GetCellType( aScPos.Col(), aScPos.Row(), aScPos.Tab(), eCellType ); if( eCellType == CELLTYPE_FORMULA ) { @@ -201,20 +201,20 @@ void ExcelToSc::GetDummy( const ScTokenArray*& pErgebnis ) ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, sal_Size nFormulaLen, bool bAllowArrays, const FORMULA_TYPE eFT ) { RootData& rR = GetOldRoot(); - BYTE nOp, nLen, nByte; + BYTE nOp, nLen, nByte; UINT16 nUINT16; - INT16 nINT16; - double fDouble; - String aString; - BOOL bError = FALSE; - BOOL bArrayFormula = FALSE; - TokenId nMerk0; - const BOOL bRangeName = eFT == FT_RangeName; - const BOOL bSharedFormula = eFT == FT_SharedFormula; - const BOOL bRNorSF = bRangeName || bSharedFormula; - - ScSingleRefData aSRD; - ScComplexRefData aCRD; + INT16 nINT16; + double fDouble; + String aString; + BOOL bError = FALSE; + BOOL bArrayFormula = FALSE; + TokenId nMerk0; + const BOOL bRangeName = eFT == FT_RangeName; + const BOOL bSharedFormula = eFT == FT_SharedFormula; + const BOOL bRNorSF = bRangeName || bSharedFormula; + + ScSingleRefData aSRD; + ScComplexRefData aCRD; ExtensionTypeVec aExtensions; bExternName = FALSE; @@ -243,11 +243,11 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s aSRD.InitFlags(); aCRD.InitFlags(); - switch( nOp ) // Buch Seite: - { // SDK4 SDK5 - case 0x01: // Array Formula [325 ] - // Array Formula or Shared Formula [ 277] - case 0x02: // Data Table [325 277] + switch( nOp ) // Buch Seite: + { // SDK4 SDK5 + case 0x01: // Array Formula [325 ] + // Array Formula or Shared Formula [ 277] + case 0x02: // Data Table [325 277] nUINT16 = 3; if( meBiff != EXC_BIFF2 ) @@ -257,82 +257,82 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s bArrayFormula = TRUE; break; - case 0x03: // Addition [312 264] + case 0x03: // Addition [312 264] aStack >> nMerk0; aPool << aStack << ocAdd << nMerk0; aPool >> aStack; break; - case 0x04: // Subtraction [313 264] + case 0x04: // Subtraction [313 264] // SECOMD-TOP minus TOP aStack >> nMerk0; aPool << aStack << ocSub << nMerk0; aPool >> aStack; break; - case 0x05: // Multiplication [313 264] + case 0x05: // Multiplication [313 264] aStack >> nMerk0; aPool << aStack << ocMul << nMerk0; aPool >> aStack; break; - case 0x06: // Division [313 264] + case 0x06: // Division [313 264] // divide TOP by SECOND-TOP aStack >> nMerk0; aPool << aStack << ocDiv << nMerk0; aPool >> aStack; break; - case 0x07: // Exponetiation [313 265] + case 0x07: // Exponetiation [313 265] // raise SECOND-TOP to power of TOP aStack >> nMerk0; aPool << aStack << ocPow << nMerk0; aPool >> aStack; break; - case 0x08: // Concatenation [313 265] + case 0x08: // Concatenation [313 265] // append TOP to SECOND-TOP aStack >> nMerk0; aPool << aStack << ocAmpersand << nMerk0; aPool >> aStack; break; - case 0x09: // Less Than [313 265] + case 0x09: // Less Than [313 265] // SECOND-TOP < TOP aStack >> nMerk0; aPool << aStack << ocLess << nMerk0; aPool >> aStack; break; - case 0x0A: // Less Than or Equal [313 265] + case 0x0A: // Less Than or Equal [313 265] // SECOND-TOP <= TOP aStack >> nMerk0; aPool << aStack << ocLessEqual << nMerk0; aPool >> aStack; break; - case 0x0B: // Equal [313 265] + case 0x0B: // Equal [313 265] // SECOND-TOP == TOP aStack >> nMerk0; aPool << aStack << ocEqual << nMerk0; aPool >> aStack; break; - case 0x0C: // Greater Than or Equal [313 265] + case 0x0C: // Greater Than or Equal [313 265] // SECOND-TOP == TOP aStack >> nMerk0; aPool << aStack << ocGreaterEqual << nMerk0; aPool >> aStack; break; - case 0x0D: // Greater Than [313 265] + case 0x0D: // Greater Than [313 265] // SECOND-TOP == TOP aStack >> nMerk0; aPool << aStack << ocGreater << nMerk0; aPool >> aStack; break; - case 0x0E: // Not Equal [313 265] + case 0x0E: // Not Equal [313 265] // SECOND-TOP == TOP aStack >> nMerk0; aPool << aStack << ocNotEqual << nMerk0; aPool >> aStack; break; - case 0x0F: // Intersection [314 265] + case 0x0F: // Intersection [314 265] aStack >> nMerk0; aPool << aStack << ocIntersect << nMerk0; aPool >> aStack; break; - case 0x10: // Union [314 265] + case 0x10: // Union [314 265] // ocSep behelfsweise statt 'ocUnion' aStack >> nMerk0; //#100928# aPool << ocOpen << aStack << ocSep << nMerk0 << ocClose; @@ -340,42 +340,42 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s // doesn't fit exactly, but is more Excel-like aPool >> aStack; break; - case 0x11: // Range [314 265] + case 0x11: // Range [314 265] aStack >> nMerk0; aPool << aStack << ocRange << nMerk0; aPool >> aStack; break; - case 0x12: // Unary Plus [312 264] + case 0x12: // Unary Plus [312 264] aPool << ocAdd << aStack; aPool >> aStack; break; - case 0x13: // Unary Minus [312 264] + case 0x13: // Unary Minus [312 264] aPool << ocNegSub << aStack; aPool >> aStack; break; - case 0x14: // Percent Sign [312 264] + case 0x14: // Percent Sign [312 264] aPool << aStack << ocPercentSign; aPool >> aStack; break; - case 0x15: // Parenthesis [326 278] + case 0x15: // Parenthesis [326 278] aPool << ocOpen << aStack << ocClose; aPool >> aStack; break; - case 0x16: // Missing Argument [314 266] + case 0x16: // Missing Argument [314 266] aPool << ocMissing; aPool >> aStack; GetTracer().TraceFormulaMissingArg(); break; - case 0x17: // String Constant [314 266] + case 0x17: // String Constant [314 266] aIn >> nLen; aString = aIn.ReadRawByteString( nLen ); aStack << aPool.Store( aString ); break; - case 0x19: // Special Attribute [327 279] + case 0x19: // Special Attribute [327 279] { - UINT16 nData, nFakt; - BYTE nOpt; + UINT16 nData, nFakt; + BYTE nOpt; aIn >> nOpt; @@ -391,15 +391,15 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s } if( nOpt & 0x04 ) - {// nFakt -> Bytes oder Words ueberlesen AttrChoose + {// nFakt -> Bytes oder Words ueberlesen AttrChoose nData++; aIn.Ignore( nData * nFakt ); } - else if( nOpt & 0x10 ) // AttrSum + else if( nOpt & 0x10 ) // AttrSum DoMulArgs( ocSum, 1 ); } break; - case 0x1A: // External Reference [330 ] + case 0x1A: // External Reference [330 ] switch( meBiff ) { case EXC_BIFF2: aIn.Ignore( 7 ); break; @@ -411,7 +411,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s DBG_WARNING( "-ExcelToSc::Convert(): Ein wenig vergesslich, was?" ); } break; - case 0x1B: // End External Reference [330 ] + case 0x1B: // End External Reference [330 ] switch( meBiff ) { case EXC_BIFF2: aIn.Ignore( 3 ); break; @@ -423,13 +423,13 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s DBG_WARNING( "-ExcelToSc::Convert(): Ein wenig vergesslich, was?" ); } break; - case 0x1C: // Error Value [314 266] + case 0x1C: // Error Value [314 266] { aIn >> nByte; #if 0 // erAck aPool.StoreError( XclTools::GetScErrorCode( nByte ) ); #else - DefTokenId eOc; + DefTokenId eOc; switch( nByte ) { case EXC_ERR_NULL: @@ -448,7 +448,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s aPool >> aStack; } break; - case 0x1D: // Boolean [315 266] + case 0x1D: // Boolean [315 266] aIn >> nByte; if( nByte == 0 ) aPool << ocFalse << ocOpen << ocClose; @@ -456,17 +456,17 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s aPool << ocTrue << ocOpen << ocClose; aPool >> aStack; break; - case 0x1E: // Integer [315 266] + case 0x1E: // Integer [315 266] aIn >> nUINT16; aStack << aPool.Store( ( double ) nUINT16 ); break; - case 0x1F: // Number [315 266] + case 0x1F: // Number [315 266] aIn >> fDouble; aStack << aPool.Store( fDouble ); break; case 0x40: case 0x60: - case 0x20: // Array Constant [317 268] + case 0x20: // Array Constant [317 268] aIn >> nByte >> nUINT16; aIn.Ignore( (meBiff == EXC_BIFF2) ? 3 : 4 ); if( bAllowArrays ) @@ -482,7 +482,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x41: case 0x61: - case 0x21: // Function, Fixed Number of Arguments [333 282] + case 0x21: // Function, Fixed Number of Arguments [333 282] { sal_uInt16 nXclFunc; if( meBiff <= EXC_BIFF3 ) @@ -497,7 +497,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x42: case 0x62: - case 0x22: // Function, Variable Number of Arg. [333 283] + case 0x22: // Function, Variable Number of Arg. [333 283] { sal_uInt16 nXclFunc; sal_uInt8 nParamCount; @@ -515,7 +515,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x43: case 0x63: - case 0x23: // Name [318 269] + case 0x23: // Name [318 269] { aIn >> nUINT16; switch( meBiff ) @@ -537,10 +537,10 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x44: case 0x64: - case 0x24: // Cell Reference [319 270] + case 0x24: // Cell Reference [319 270] case 0x4A: case 0x6A: - case 0x2A: // Deleted Cell Reference [323 273] + case 0x2A: // Deleted Cell Reference [323 273] aIn >> nUINT16 >> nByte; aSRD.nCol = static_cast<SCsCOL>(nByte); aSRD.nRow = nUINT16 & 0x3FFF; @@ -554,7 +554,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s { case 0x4A: case 0x6A: - case 0x2A: // Deleted Cell Reference [323 273] + case 0x2A: // Deleted Cell Reference [323 273] // no information which part is deleted, set both aSRD.SetColDeleted( TRUE ); aSRD.SetRowDeleted( TRUE ); @@ -564,15 +564,15 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x45: case 0x65: - case 0x25: // Area Reference [320 270] + case 0x25: // Area Reference [320 270] case 0x4B: case 0x6B: - case 0x2B: // Deleted Area Refernce [323 273] + case 0x2B: // Deleted Area Refernce [323 273] { - UINT16 nRowFirst, nRowLast; - UINT8 nColFirst, nColLast; - ScSingleRefData& rSRef1 = aCRD.Ref1; - ScSingleRefData& rSRef2 = aCRD.Ref2; + UINT16 nRowFirst, nRowLast; + UINT8 nColFirst, nColLast; + ScSingleRefData& rSRef1 = aCRD.Ref1; + ScSingleRefData& rSRef2 = aCRD.Ref2; aIn >> nRowFirst >> nRowLast >> nColFirst >> nColLast; @@ -594,7 +594,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s { case 0x4B: case 0x6B: - case 0x2B: // Deleted Area Refernce [323 273] + case 0x2B: // Deleted Area Refernce [323 273] // no information which part is deleted, set all rSRef1.SetColDeleted( TRUE ); rSRef1.SetRowDeleted( TRUE ); @@ -607,13 +607,13 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x46: case 0x66: - case 0x26: // Constant Reference Subexpression [321 271] + case 0x26: // Constant Reference Subexpression [321 271] aExtensions.push_back( EXTENSION_MEMAREA ); // fall through case 0x47: case 0x67: - case 0x27: // Erroneous Constant Reference Subexpr. [322 272] + case 0x27: // Erroneous Constant Reference Subexpr. [322 272] case 0x48: case 0x68: case 0x28: // Incomplete Constant Reference Subexpr.[331 281] @@ -621,10 +621,10 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x4C: case 0x6C: - case 0x2C: // Cell Reference Within a Name [323 ] + case 0x2C: // Cell Reference Within a Name [323 ] // Cell Reference Within a Shared Formula[ 273] { - aIn >> nUINT16 >> nByte; // >> Attribute, Row >> Col + aIn >> nUINT16 >> nByte; // >> Attribute, Row >> Col aSRD.nRelTab = 0; aSRD.SetTabRel( TRUE ); @@ -637,10 +637,10 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x4D: case 0x6D: - case 0x2D: // Area Reference Within a Name [324 ] - { // Area Reference Within a Shared Formula[ 274] - UINT16 nRowFirst, nRowLast; - UINT8 nColFirst, nColLast; + case 0x2D: // Area Reference Within a Name [324 ] + { // Area Reference Within a Shared Formula[ 274] + UINT16 nRowFirst, nRowLast; + UINT8 nColFirst, nColLast; aCRD.Ref1.nRelTab = aCRD.Ref2.nRelTab = 0; aCRD.Ref1.SetTabRel( TRUE ); @@ -666,15 +666,15 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s case 0x29: // Variable Reference Subexpression [331 281] case 0x4E: case 0x6E: - case 0x2E: // Reference Subexpression Within a Name [332 282] + case 0x2E: // Reference Subexpression Within a Name [332 282] case 0x4F: case 0x6F: - case 0x2F: // Incomplete Reference Subexpression... [332 282] + case 0x2F: // Incomplete Reference Subexpression... [332 282] aIn.Ignore( (meBiff == EXC_BIFF2) ? 1 : 2 ); break; case 0x58: case 0x78: - case 0x38: // Command-Equivalent Function [333 ] + case 0x38: // Command-Equivalent Function [333 ] aString.AssignAscii( "COMM_EQU_FUNC" ); aIn >> nByte; aString += String::CreateFromInt32( nByte ); @@ -684,7 +684,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x59: case 0x79: - case 0x39: // Name or External Name [ 275] + case 0x39: // Name or External Name [ 275] aIn >> nINT16; aIn.Ignore( 8 ); aIn >> nUINT16; @@ -694,14 +694,14 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s if( pExtName && pExtName->IsDDE() && rR.pExtSheetBuff->IsLink( ( UINT16 ) nINT16 ) ) { - String aAppl, aExtDoc; - TokenId nPar1, nPar2; + String aAppl, aExtDoc; + TokenId nPar1, nPar2; rR.pExtSheetBuff->GetLink( ( UINT16 ) nINT16 , aAppl, aExtDoc ); nPar1 = aPool.Store( aAppl ); nPar2 = aPool.Store( aExtDoc ); nMerk0 = aPool.Store( pExtName->aName ); - aPool << ocDde << ocOpen << nPar1 << ocSep << nPar2 << ocSep + aPool << ocDde << ocOpen << nPar1 << ocSep << nPar2 << ocSep << nMerk0 << ocClose; GetDoc().CreateDdeLink( aAppl, aExtDoc, pExtName->aName, SC_DDE_DEFAULT ); @@ -717,36 +717,36 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x5A: case 0x7A: - case 0x3A: // 3-D Cell Reference [ 275] + case 0x3A: // 3-D Cell Reference [ 275] case 0x5C: case 0x7C: - case 0x3C: // Deleted 3-D Cell Reference [ 277] + case 0x3C: // Deleted 3-D Cell Reference [ 277] { - UINT16 nTabFirst, nTabLast, nRow; - INT16 nExtSheet; - BYTE nCol; + UINT16 nTabFirst, nTabLast, nRow; + INT16 nExtSheet; + BYTE nCol; aIn >> nExtSheet; aIn.Ignore( 8 ); aIn >> nTabFirst >> nTabLast >> nRow >> nCol; if( nExtSheet >= 0 ) - { // von extern + { // von extern if( rR.pExtSheetBuff->GetScTabIndex( nExtSheet, nTabLast ) ) { nTabFirst = nTabLast; - nExtSheet = 0; // gefunden + nExtSheet = 0; // gefunden } else { aPool << ocBad; aPool >> aStack; - nExtSheet = 1; // verhindert Erzeugung einer SingleRef + nExtSheet = 1; // verhindert Erzeugung einer SingleRef } } if( nExtSheet <= 0 ) - { // in aktuellem Workbook + { // in aktuellem Workbook aSRD.nTab = static_cast<SCTAB>(nTabFirst); aSRD.SetFlag3D( TRUE ); aSRD.SetTabRel( FALSE ); @@ -757,7 +757,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s { case 0x5C: case 0x7C: - case 0x3C: // Deleted 3-D Cell Reference [ 277] + case 0x3C: // Deleted 3-D Cell Reference [ 277] // no information which part is deleted, set both aSRD.SetColDeleted( TRUE ); aSRD.SetRowDeleted( TRUE ); @@ -780,14 +780,14 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s break; case 0x5B: case 0x7B: - case 0x3B: // 3-D Area Reference [ 276] + case 0x3B: // 3-D Area Reference [ 276] case 0x5D: case 0x7D: - case 0x3D: // Deleted 3-D Area Reference [ 277] + case 0x3D: // Deleted 3-D Area Reference [ 277] { - UINT16 nTabFirst, nTabLast, nRowFirst, nRowLast; - INT16 nExtSheet; - BYTE nColFirst, nColLast; + UINT16 nTabFirst, nTabLast, nRowFirst, nRowLast; + INT16 nExtSheet; + BYTE nColFirst, nColLast; aIn >> nExtSheet; aIn.Ignore( 8 ); @@ -800,21 +800,21 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s if( rR.pExtSheetBuff->GetScTabIndex( nExtSheet, nTabLast ) ) { nTabFirst = nTabLast; - nExtSheet = 0; // gefunden + nExtSheet = 0; // gefunden } else { aPool << ocBad; aPool >> aStack; - nExtSheet = 1; // verhindert Erzeugung einer CompleteRef + nExtSheet = 1; // verhindert Erzeugung einer CompleteRef } } if( nExtSheet <= 0 ) {// in aktuellem Workbook // erster Teil des Bereichs - ScSingleRefData& rR1 = aCRD.Ref1; - ScSingleRefData& rR2 = aCRD.Ref2; + ScSingleRefData& rR1 = aCRD.Ref1; + ScSingleRefData& rR2 = aCRD.Ref2; rR1.nTab = static_cast<SCTAB>(nTabFirst); rR2.nTab = static_cast<SCTAB>(nTabLast); @@ -835,7 +835,7 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s { case 0x5D: case 0x7D: - case 0x3D: // Deleted 3-D Area Reference [ 277] + case 0x3D: // Deleted 3-D Area Reference [ 277] // no information which part is deleted, set all rR1.SetColDeleted( TRUE ); rR1.SetRowDeleted( TRUE ); @@ -901,18 +901,18 @@ ConvErr ExcelToSc::Convert( const ScTokenArray*& pErgebnis, XclImpStream& aIn, s ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal_Size nFormulaLen, const FORMULA_TYPE eFT ) { RootData& rR = GetOldRoot(); - BYTE nOp, nLen; + BYTE nOp, nLen; sal_Size nIgnore; - UINT16 nUINT16; - UINT8 nByte; - BOOL bError = FALSE; - BOOL bArrayFormula = FALSE; - const BOOL bRangeName = eFT == FT_RangeName; - const BOOL bSharedFormula = eFT == FT_SharedFormula; - const BOOL bRNorSF = bRangeName || bSharedFormula; - - ScSingleRefData aSRD; - ScComplexRefData aCRD; + UINT16 nUINT16; + UINT8 nByte; + BOOL bError = FALSE; + BOOL bArrayFormula = FALSE; + const BOOL bRangeName = eFT == FT_RangeName; + const BOOL bSharedFormula = eFT == FT_SharedFormula; + const BOOL bRNorSF = bRangeName || bSharedFormula; + + ScSingleRefData aSRD; + ScComplexRefData aCRD; aCRD.Ref1.nTab = aCRD.Ref2.nTab = aEingPos.Tab(); bExternName = FALSE; @@ -937,42 +937,42 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal aSRD.InitFlags(); aCRD.InitFlags(); - switch( nOp ) // Buch Seite: - { // SDK4 SDK5 - case 0x01: // Array Formula [325 ] - // Array Formula or Shared Formula [ 277] + switch( nOp ) // Buch Seite: + { // SDK4 SDK5 + case 0x01: // Array Formula [325 ] + // Array Formula or Shared Formula [ 277] nIgnore = (meBiff == EXC_BIFF2) ? 3 : 4; bArrayFormula = TRUE; break; - case 0x02: // Data Table [325 277] + case 0x02: // Data Table [325 277] nIgnore = (meBiff == EXC_BIFF2) ? 3 : 4; break; - case 0x03: // Addition [312 264] - case 0x04: // Subtraction [313 264] - case 0x05: // Multiplication [313 264] - case 0x06: // Division [313 264] - case 0x07: // Exponetiation [313 265] - case 0x08: // Concatenation [313 265] - case 0x09: // Less Than [313 265] - case 0x0A: // Less Than or Equal [313 265] - case 0x0B: // Equal [313 265] - case 0x0C: // Greater Than or Equal [313 265] - case 0x0D: // Greater Than [313 265] - case 0x0E: // Not Equal [313 265] - case 0x0F: // Intersection [314 265] - case 0x10: // Union [314 265] - case 0x11: // Range [314 265] - case 0x12: // Unary Plus [312 264] - case 0x13: // Unary Minus [312 264] - case 0x14: // Percent Sign [312 264] - case 0x15: // Parenthesis [326 278] - case 0x16: // Missing Argument [314 266] - break; - case 0x17: // String Constant [314 266] + case 0x03: // Addition [312 264] + case 0x04: // Subtraction [313 264] + case 0x05: // Multiplication [313 264] + case 0x06: // Division [313 264] + case 0x07: // Exponetiation [313 265] + case 0x08: // Concatenation [313 265] + case 0x09: // Less Than [313 265] + case 0x0A: // Less Than or Equal [313 265] + case 0x0B: // Equal [313 265] + case 0x0C: // Greater Than or Equal [313 265] + case 0x0D: // Greater Than [313 265] + case 0x0E: // Not Equal [313 265] + case 0x0F: // Intersection [314 265] + case 0x10: // Union [314 265] + case 0x11: // Range [314 265] + case 0x12: // Unary Plus [312 264] + case 0x13: // Unary Minus [312 264] + case 0x14: // Percent Sign [312 264] + case 0x15: // Parenthesis [326 278] + case 0x16: // Missing Argument [314 266] + break; + case 0x17: // String Constant [314 266] aIn >> nLen; nIgnore = nLen; break; - case 0x19: // Special Attribute [327 279] + case 0x19: // Special Attribute [327 279] { UINT16 nData, nFakt; BYTE nOpt; @@ -991,13 +991,13 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal } if( nOpt & 0x04 ) - {// nFakt -> Bytes oder Words ueberlesen AttrChoose + {// nFakt -> Bytes oder Words ueberlesen AttrChoose nData++; aIn.Ignore( nData * nFakt ); } } break; - case 0x1A: // External Reference [330 ] + case 0x1A: // External Reference [330 ] switch( meBiff ) { case EXC_BIFF2: nIgnore = 7; break; @@ -1007,7 +1007,7 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal default: DBG_WARNING( "-ExcelToSc::Convert(): Ein wenig vergesslich, was?" ); } break; - case 0x1B: // End External Reference [330 ] + case 0x1B: // End External Reference [330 ] switch( meBiff ) { case EXC_BIFF2: nIgnore = 3; break; @@ -1017,34 +1017,34 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal default: DBG_WARNING( "-ExcelToSc::Convert(): Ein wenig vergesslich, was?" ); } break; - case 0x1C: // Error Value [314 266] - case 0x1D: // Boolean [315 266] + case 0x1C: // Error Value [314 266] + case 0x1D: // Boolean [315 266] nIgnore = 1; break; - case 0x1E: // Integer [315 266] + case 0x1E: // Integer [315 266] nIgnore = 2; break; - case 0x1F: // Number [315 266] + case 0x1F: // Number [315 266] nIgnore = 8; break; case 0x40: case 0x60: - case 0x20: // Array Constant [317 268] + case 0x20: // Array Constant [317 268] nIgnore = (meBiff == EXC_BIFF2) ? 6 : 7; break; case 0x41: case 0x61: - case 0x21: // Function, Fixed Number of Arguments [333 282] + case 0x21: // Function, Fixed Number of Arguments [333 282] nIgnore = (meBiff <= EXC_BIFF3) ? 1 : 2; break; case 0x42: case 0x62: - case 0x22: // Function, Variable Number of Arg. [333 283] + case 0x22: // Function, Variable Number of Arg. [333 283] nIgnore = (meBiff <= EXC_BIFF3) ? 2 : 3; break; case 0x43: case 0x63: - case 0x23: // Name [318 269] + case 0x23: // Name [318 269] switch( meBiff ) { case EXC_BIFF2: nIgnore = 7; break; @@ -1056,7 +1056,7 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal break; case 0x44: case 0x64: - case 0x24: // Cell Reference [319 270] + case 0x24: // Cell Reference [319 270] aIn >> nUINT16 >> nByte; aSRD.nCol = static_cast<SCsCOL>(nByte); aSRD.nRow = nUINT16 & 0x3FFF; @@ -1070,12 +1070,12 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal break; case 0x45: case 0x65: - case 0x25: // Area Reference [320 270] + case 0x25: // Area Reference [320 270] { - UINT16 nRowFirst, nRowLast; - UINT8 nColFirst, nColLast; - ScSingleRefData &rSRef1 = aCRD.Ref1; - ScSingleRefData &rSRef2 = aCRD.Ref2; + UINT16 nRowFirst, nRowLast; + UINT8 nColFirst, nColLast; + ScSingleRefData &rSRef1 = aCRD.Ref1; + ScSingleRefData &rSRef2 = aCRD.Ref2; aIn >> nRowFirst >> nRowLast >> nColFirst >> nColLast; @@ -1098,10 +1098,10 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal break; case 0x46: case 0x66: - case 0x26: // Constant Reference Subexpression [321 271] + case 0x26: // Constant Reference Subexpression [321 271] case 0x47: case 0x67: - case 0x27: // Erroneous Constant Reference Subexpr. [322 272] + case 0x27: // Erroneous Constant Reference Subexpr. [322 272] case 0x48: case 0x68: case 0x28: // Incomplete Constant Reference Subexpr.[331 281] @@ -1109,20 +1109,20 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal break; case 0x4A: case 0x6A: - case 0x2A: // Deleted Cell Reference [323 273] + case 0x2A: // Deleted Cell Reference [323 273] nIgnore = 3; break; case 0x4B: case 0x6B: - case 0x2B: // Deleted Area Refernce [323 273] + case 0x2B: // Deleted Area Refernce [323 273] nIgnore = 6; break; case 0x4C: case 0x6C: - case 0x2C: // Cell Reference Within a Name [323 ] + case 0x2C: // Cell Reference Within a Name [323 ] // Cell Reference Within a Shared Formula[ 273] { - aIn >> nUINT16 >> nByte; // >> Attribute, Row >> Col + aIn >> nUINT16 >> nByte; // >> Attribute, Row >> Col aSRD.nRelTab = 0; aSRD.SetTabRel( TRUE ); @@ -1135,10 +1135,10 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal break; case 0x4D: case 0x6D: - case 0x2D: // Area Reference Within a Name [324 ] - { // Area Reference Within a Shared Formula[ 274] - UINT16 nRowFirst, nRowLast; - UINT8 nColFirst, nColLast; + case 0x2D: // Area Reference Within a Name [324 ] + { // Area Reference Within a Shared Formula[ 274] + UINT16 nRowFirst, nRowLast; + UINT8 nColFirst, nColLast; aCRD.Ref1.nRelTab = aCRD.Ref2.nRelTab = 0; aCRD.Ref1.SetTabRel( TRUE ); @@ -1164,29 +1164,29 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal case 0x29: // Variable Reference Subexpression [331 281] case 0x4E: case 0x6E: - case 0x2E: // Reference Subexpression Within a Name [332 282] + case 0x2E: // Reference Subexpression Within a Name [332 282] case 0x4F: case 0x6F: - case 0x2F: // Incomplete Reference Subexpression... [332 282] + case 0x2F: // Incomplete Reference Subexpression... [332 282] nIgnore = (meBiff == EXC_BIFF2) ? 1 : 2; break; case 0x58: case 0x78: - case 0x38: // Command-Equivalent Function [333 ] + case 0x38: // Command-Equivalent Function [333 ] nIgnore = 2; break; case 0x59: case 0x79: - case 0x39: // Name or External Name [ 275] + case 0x39: // Name or External Name [ 275] nIgnore = 24; break; case 0x5A: case 0x7A: - case 0x3A: // 3-D Cell Reference [ 275] + case 0x3A: // 3-D Cell Reference [ 275] { - UINT16 nTabFirst, nTabLast, nRow; - INT16 nExtSheet; - BYTE nCol; + UINT16 nTabFirst, nTabLast, nRow; + INT16 nExtSheet; + BYTE nCol; aIn >> nExtSheet; aIn.Ignore( 8 ); @@ -1198,13 +1198,13 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal if( rR.pExtSheetBuff->GetScTabIndex( nExtSheet, nTabLast ) ) { nTabFirst = nTabLast; - nExtSheet = 0; // gefunden + nExtSheet = 0; // gefunden } else { aPool << ocBad; aPool >> aStack; - nExtSheet = 1; // verhindert Erzeugung einer SingleRef + nExtSheet = 1; // verhindert Erzeugung einer SingleRef } } @@ -1236,11 +1236,11 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal break; case 0x5B: case 0x7B: - case 0x3B: // 3-D Area Reference [ 276] + case 0x3B: // 3-D Area Reference [ 276] { - UINT16 nTabFirst, nTabLast, nRowFirst, nRowLast; - INT16 nExtSheet; - BYTE nColFirst, nColLast; + UINT16 nTabFirst, nTabLast, nRowFirst, nRowLast; + INT16 nExtSheet; + BYTE nColFirst, nColLast; aIn >> nExtSheet; aIn.Ignore( 8 ); @@ -1253,21 +1253,21 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal if( rR.pExtSheetBuff->GetScTabIndex( nExtSheet, nTabLast ) ) { nTabFirst = nTabLast; - nExtSheet = 0; // gefunden + nExtSheet = 0; // gefunden } else { aPool << ocBad; aPool >> aStack; - nExtSheet = 1; // verhindert Erzeugung einer CompleteRef + nExtSheet = 1; // verhindert Erzeugung einer CompleteRef } } if( nExtSheet <= 0 ) {// in aktuellem Workbook // erster Teil des Bereichs - ScSingleRefData &rR1 = aCRD.Ref1; - ScSingleRefData &rR2 = aCRD.Ref2; + ScSingleRefData &rR1 = aCRD.Ref1; + ScSingleRefData &rR2 = aCRD.Ref2; rR1.nTab = static_cast<SCTAB>(nTabFirst); rR2.nTab = static_cast<SCTAB>(nTabLast); @@ -1290,12 +1290,12 @@ ConvErr ExcelToSc::Convert( _ScRangeListTabs& rRangeList, XclImpStream& aIn, sal break; case 0x5C: case 0x7C: - case 0x3C: // Deleted 3-D Cell Reference [ 277] + case 0x3C: // Deleted 3-D Cell Reference [ 277] nIgnore = 17; break; case 0x5D: case 0x7D: - case 0x3D: // Deleted 3-D Area Reference [ 277] + case 0x3D: // Deleted 3-D Area Reference [ 277] nIgnore = 20; break; default: bError = TRUE; @@ -1536,12 +1536,12 @@ BOOL ExcelToSc::GetAbsRefs( ScRangeList& rRangeList, XclImpStream& rStrm, sal_Si void ExcelToSc::DoMulArgs( DefTokenId eId, sal_uInt8 nAnz, sal_uInt8 nMinParamCount ) { - TokenId eParam[ 256 ]; - INT32 nLauf; + TokenId eParam[ 256 ]; + INT32 nLauf; if( eId == ocCeil || eId == ocFloor ) { - aStack << aPool.Store( 1.0 ); // default, da in Excel nicht vorhanden + aStack << aPool.Store( 1.0 ); // default, da in Excel nicht vorhanden nAnz++; } @@ -1553,7 +1553,7 @@ void ExcelToSc::DoMulArgs( DefTokenId eId, sal_uInt8 nAnz, sal_uInt8 nMinParamCo if( nAnz > 0 && eId == ocExternal ) { - TokenId n = eParam[ nAnz - 1 ]; + TokenId n = eParam[ nAnz - 1 ]; //##### GRUETZE FUER BASIC-FUNCS RICHTEN! if( const String* pExt = aPool.GetExternal( n ) ) { @@ -1574,19 +1574,19 @@ void ExcelToSc::DoMulArgs( DefTokenId eId, sal_uInt8 nAnz, sal_uInt8 nMinParamCo if( nAnz > 0 ) { // attention: 0 = last parameter, nAnz-1 = first parameter - INT16 nNull = -1; // skip this parameter - INT16 nSkipEnd = -1; // skip all parameters <= nSkipEnd + INT16 nNull = -1; // skip this parameter + INT16 nSkipEnd = -1; // skip all parameters <= nSkipEnd INT16 nLast = nAnz - 1; // Funktionen, bei denen Parameter wegfallen muessen if( eId == ocPercentrank && nAnz == 3 ) - nSkipEnd = 0; // letzten Parameter bei Bedarf weglassen + nSkipEnd = 0; // letzten Parameter bei Bedarf weglassen // Joost-Spezialfaelle else if( eId == ocIf ) { - UINT16 nNullParam = 0; + UINT16 nNullParam = 0; for( nLauf = 0 ; nLauf < nAnz ; nLauf++ ) { if( aPool.IsSingleOp( eParam[ nLauf ], ocMissing ) ) @@ -1608,8 +1608,8 @@ void ExcelToSc::DoMulArgs( DefTokenId eId, sal_uInt8 nAnz, sal_uInt8 nMinParamCo aPool.IsSingleOp( eParam[ nSkipEnd + 1 ], ocMissing ) ) nSkipEnd++; -// fprintf (stderr, "Fn %d nSkipEnd %d nLast %d nMinParamCnt %d %d\n", -// eId, nSkipEnd, nLast, nMinParamCount, nLastRemovable); +// fprintf (stderr, "Fn %d nSkipEnd %d nLast %d nMinParamCnt %d %d\n", +// eId, nSkipEnd, nLast, nMinParamCount, nLastRemovable); // [Parameter{;Parameter}] if( nLast > nSkipEnd ) @@ -1634,29 +1634,29 @@ void ExcelToSc::ExcRelToScRel( UINT16 nRow, UINT8 nCol, ScSingleRefData &rSRD, c { // C O L if( nRow & 0x4000 ) - {// rel Col + {// rel Col rSRD.SetColRel( TRUE ); rSRD.nRelCol = static_cast<SCsCOL>(static_cast<INT8>(nCol)); } else - {// abs Col + {// abs Col rSRD.SetColRel( FALSE ); rSRD.nCol = static_cast<SCCOL>(nCol); } // R O W if( nRow & 0x8000 ) - {// rel Row + {// rel Row rSRD.SetRowRel( TRUE ); - if( nRow & 0x2000 ) // Bit 13 gesetzt? - // -> Row negativ + if( nRow & 0x2000 ) // Bit 13 gesetzt? + // -> Row negativ rSRD.nRelRow = static_cast<SCsROW>(static_cast<INT16>(nRow | 0xC000)); else - // -> Row positiv + // -> Row positiv rSRD.nRelRow = static_cast<SCsROW>(nRow & nRowMask); } else - {// abs Row + {// abs Row rSRD.SetRowRel( FALSE ); rSRD.nRow = static_cast<SCROW>(nRow & nRowMask); } @@ -1691,11 +1691,11 @@ void ExcelToSc::ExcRelToScRel( UINT16 nRow, UINT8 nCol, ScSingleRefData &rSRD, c const ScTokenArray* ExcelToSc::GetBoolErr( XclBoolError eType ) { - UINT16 nError; + UINT16 nError; aPool.Reset(); aStack.Reset(); - DefTokenId eOc; + DefTokenId eOc; switch( eType ) { @@ -1721,7 +1721,7 @@ const ScTokenArray* ExcelToSc::GetBoolErr( XclBoolError eType ) aPool >> aStack; - const ScTokenArray* pErgebnis = aPool[ aStack.Get() ]; + const ScTokenArray* pErgebnis = aPool[ aStack.Get() ]; if( nError ) ( ( ScTokenArray* ) pErgebnis )->SetCodeError( nError ); @@ -1735,8 +1735,8 @@ const ScTokenArray* ExcelToSc::GetBoolErr( XclBoolError eType ) // else stream pointer stays unchanged BOOL ExcelToSc::GetShrFmla( const ScTokenArray*& rpErgebnis, XclImpStream& aIn, sal_Size nFormulaLen ) { - BYTE nOp; - BOOL bRet = TRUE; + BYTE nOp; + BOOL bRet = TRUE; if( nFormulaLen == 0 ) bRet = FALSE; @@ -1746,7 +1746,7 @@ BOOL ExcelToSc::GetShrFmla( const ScTokenArray*& rpErgebnis, XclImpStream& aIn, aIn >> nOp; - if( nOp == 0x01 ) // Shared Formula [ 277] + if( nOp == 0x01 ) // Shared Formula [ 277] { UINT16 nCol, nRow; @@ -1778,10 +1778,10 @@ BOOL ExcelToSc::GetShrFmla( const ScTokenArray*& rpErgebnis, XclImpStream& aIn, #if 0 BOOL ExcelToSc::SetCurVal( ScFormulaCell &rCell, double &rfCurVal ) { - UINT16 nInd; - BYTE nType; - BYTE nVal; - BOOL bString = FALSE; + UINT16 nInd; + BYTE nType; + BYTE nVal; + BOOL bString = FALSE; #ifdef OSL_BIGENDIAN // Code fuer alle anstaendigen Prozessoren @@ -1802,17 +1802,17 @@ BOOL ExcelToSc::SetCurVal( ScFormulaCell &rCell, double &rfCurVal ) { switch( nType ) { - case 0: // String + case 0: // String bString = TRUE; break; - case 1: // Bool + case 1: // Bool if( nVal ) rfCurVal = 1.0; else rfCurVal = 0.0; rCell.SetHybridDouble( rfCurVal ); break; - case 2: // Error + case 2: // Error rCell.SetErrCode( XclTools::GetScErrorCode( nVal ) ); break; } @@ -1825,15 +1825,15 @@ BOOL ExcelToSc::SetCurVal( ScFormulaCell &rCell, double &rfCurVal ) void ExcelToSc::SetError( ScFormulaCell &rCell, const ConvErr eErr ) { - UINT16 nInd; + UINT16 nInd; switch( eErr ) { - case ConvErrNi: nInd = errUnknownToken; break; - case ConvErrNoMem: nInd = errCodeOverflow; break; - case ConvErrExternal: nInd = errNoName; break; - case ConvErrCount: nInd = errCodeOverflow; break; - default: nInd = errNoCode; // hier fiel mir nichts + case ConvErrNi: nInd = errUnknownToken; break; + case ConvErrNoMem: nInd = errCodeOverflow; break; + case ConvErrExternal: nInd = errNoName; break; + case ConvErrCount: nInd = errCodeOverflow; break; + default: nInd = errNoCode; // hier fiel mir nichts // Besseres ein... } @@ -1843,7 +1843,7 @@ void ExcelToSc::SetError( ScFormulaCell &rCell, const ConvErr eErr ) void ExcelToSc::SetComplCol( ScComplexRefData &rCRD ) { - ScSingleRefData &rSRD = rCRD.Ref2; + ScSingleRefData &rSRD = rCRD.Ref2; if( rSRD.IsColRel() ) rSRD.nRelCol = MAXCOL - aEingPos.Col(); else @@ -1853,7 +1853,7 @@ void ExcelToSc::SetComplCol( ScComplexRefData &rCRD ) void ExcelToSc::SetComplRow( ScComplexRefData &rCRD ) { - ScSingleRefData &rSRD = rCRD.Ref2; + ScSingleRefData &rSRD = rCRD.Ref2; if( rSRD.IsRowRel() ) rSRD.nRelRow = MAXROW - aEingPos.Row(); else |