[Libreoffice-commits] .: 3 commits - basic/source framework/source oox/inc oox/Library_oox.mk oox/Package_inc.mk oox/source package/source sc/Library_scfilt.mk sc/source sfx2/source svx/source sw/qa sw/source toolkit/source unusedcode.easy xmloff/source

Caolán McNamara caolan at kemper.freedesktop.org
Fri Mar 30 06:08:01 PDT 2012


 basic/source/classes/sbunoobj.cxx                       |    4 
 framework/source/dispatch/windowcommanddispatch.cxx     |   12 
 framework/source/helper/uiconfigelementwrapperbase.cxx  |   46 -
 framework/source/inc/dispatch/windowcommanddispatch.hxx |   14 
 oox/Library_oox.mk                                      |    1 
 oox/Package_inc.mk                                      |    1 
 oox/inc/oox/dump/dffdumper.hxx                          |    2 
 oox/inc/oox/dump/dumperbase.hxx                         |    5 
 oox/inc/oox/helper/propertyset.hxx                      |    4 
 oox/inc/oox/ole/vbaprojectfilter.hxx                    |   64 --
 oox/source/dump/dffdumper.cxx                           |   11 
 oox/source/dump/dumperbase.cxx                          |   39 -
 oox/source/helper/propertyset.cxx                       |    9 
 oox/source/ole/vbaprojectfilter.cxx                     |   78 --
 package/source/manifest/Base64Codec.cxx                 |    7 
 sc/Library_scfilt.mk                                    |    1 
 sc/source/filter/ftools/fapihelper.cxx                  |   18 
 sc/source/filter/inc/biffcodec.hxx                      |    2 
 sc/source/filter/inc/biffdetector.hxx                   |   64 --
 sc/source/filter/inc/chartsheetfragment.hxx             |   15 
 sc/source/filter/inc/excelfilter.hxx                    |    1 
 sc/source/filter/inc/excelhandlers.hxx                  |   27 
 sc/source/filter/inc/externallinkfragment.hxx           |   14 
 sc/source/filter/inc/fapihelper.hxx                     |    6 
 sc/source/filter/inc/pivotcachebuffer.hxx               |    2 
 sc/source/filter/inc/sharedstringsbuffer.hxx            |    2 
 sc/source/filter/inc/sheetdatabuffer.hxx                |    5 
 sc/source/filter/inc/stylesbuffer.hxx                   |   16 
 sc/source/filter/inc/viewsettings.hxx                   |    4 
 sc/source/filter/inc/workbookhelper.hxx                 |   10 
 sc/source/filter/inc/workbooksettings.hxx               |   14 
 sc/source/filter/inc/worksheetbuffer.hxx                |    7 
 sc/source/filter/inc/worksheetfragment.hxx              |   59 --
 sc/source/filter/oox/biffcodec.cxx                      |   11 
 sc/source/filter/oox/biffdetector.cxx                   |  110 ---
 sc/source/filter/oox/chartsheetfragment.cxx             |  109 ---
 sc/source/filter/oox/excelfilter.cxx                    |    3 
 sc/source/filter/oox/excelhandlers.cxx                  |   78 --
 sc/source/filter/oox/externallinkfragment.cxx           |   27 
 sc/source/filter/oox/pivotcachebuffer.cxx               |   22 
 sc/source/filter/oox/sharedstringsbuffer.cxx            |   17 
 sc/source/filter/oox/sheetdatabuffer.cxx                |   90 ---
 sc/source/filter/oox/stylesbuffer.cxx                   |   96 ---
 sc/source/filter/oox/viewsettings.cxx                   |   44 -
 sc/source/filter/oox/workbookhelper.cxx                 |   15 
 sc/source/filter/oox/workbooksettings.cxx               |   48 -
 sc/source/filter/oox/worksheetbuffer.cxx                |   32 -
 sc/source/filter/oox/worksheetfragment.cxx              |  462 ----------------
 sfx2/source/doc/guisaveas.cxx                           |   76 +-
 svx/source/customshapes/EnhancedCustomShape3d.cxx       |   35 -
 sw/qa/core/swdoc-test.cxx                               |   89 ++-
 sw/source/core/txtnode/txtedt.cxx                       |    4 
 toolkit/source/helper/formpdfexport.cxx                 |    6 
 unusedcode.easy                                         |    3 
 xmloff/source/chart/SchXMLTableContext.cxx              |    9 
 xmloff/source/text/txtparae.cxx                         |    6 
 56 files changed, 184 insertions(+), 1772 deletions(-)

New commits:
commit 417823d4c23100713813171865d70f5e2719ace2
Author: Caolán McNamara <caolanm at redhat.com>
Date:   Fri Mar 30 12:21:14 2012 +0100

    count words in text with mixed script punctuation correctly

diff --git a/sw/qa/core/swdoc-test.cxx b/sw/qa/core/swdoc-test.cxx
index d7d453f..6106da2 100644
--- a/sw/qa/core/swdoc-test.cxx
+++ b/sw/qa/core/swdoc-test.cxx
@@ -36,6 +36,8 @@
 #include <tools/urlobj.hxx>
 #include <unotools/tempfile.hxx>
 
+#include <editeng/langitem.hxx>
+
 #include <sfx2/app.hxx>
 #include <sfx2/docfilt.hxx>
 #include <sfx2/docfile.hxx>
@@ -214,7 +216,6 @@ void SwDocTest::testUserPerceivedCharCount()
     CPPUNIT_ASSERT_MESSAGE("Surrogate Pair should be counted as single character", nCount == 1);
 }
 
-//See https://bugs.freedesktop.org/show_bug.cgi?id=40449 for motivation
 void SwDocTest::testSwScanner()
 {
     SwNodeIndex aIdx(m_pDoc->GetNodes().GetEndOfContent(), -1);
@@ -224,26 +225,80 @@ void SwDocTest::testSwScanner()
 
     CPPUNIT_ASSERT_MESSAGE("Has Text Node", pTxtNode);
 
+    //See https://bugs.freedesktop.org/show_bug.cgi?id=40449 for motivation
+    //See https://bugs.freedesktop.org/show_bug.cgi?id=39365 for motivation
     //Use a temporary rtl::OUString as the arg, as that's the trouble behind
     //fdo#40449 and fdo#39365
-    SwScanner aScanner(*pTxtNode,
-        rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Hello World")),
-        0, 0, i18n::WordType::DICTIONARY_WORD, 0,
-        RTL_CONSTASCII_LENGTH("Hello World"));
-
-    bool bFirstOk = aScanner.NextWord();
-    CPPUNIT_ASSERT_MESSAGE("First Token", bFirstOk);
-    const rtl::OUString &rHello = aScanner.GetWord();
-    CPPUNIT_ASSERT_MESSAGE("Should be Hello",
-        rHello.equalsAsciiL(RTL_CONSTASCII_STRINGPARAM("Hello")));
-
-    bool bSecondOk = aScanner.NextWord();
-    CPPUNIT_ASSERT_MESSAGE("Second Token", bSecondOk);
-    const rtl::OUString &rWorld = aScanner.GetWord();
-    CPPUNIT_ASSERT_MESSAGE("Should be World",
-        rWorld.equalsAsciiL(RTL_CONSTASCII_STRINGPARAM("World")));
+    {
+        SwScanner aScanner(*pTxtNode,
+            rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Hello World")),
+            0, 0, i18n::WordType::DICTIONARY_WORD, 0,
+            RTL_CONSTASCII_LENGTH("Hello World"));
+
+        bool bFirstOk = aScanner.NextWord();
+        CPPUNIT_ASSERT_MESSAGE("First Token", bFirstOk);
+        const rtl::OUString &rHello = aScanner.GetWord();
+        CPPUNIT_ASSERT_MESSAGE("Should be Hello",
+            rHello.equalsAsciiL(RTL_CONSTASCII_STRINGPARAM("Hello")));
+
+        bool bSecondOk = aScanner.NextWord();
+        CPPUNIT_ASSERT_MESSAGE("Second Token", bSecondOk);
+        const rtl::OUString &rWorld = aScanner.GetWord();
+        CPPUNIT_ASSERT_MESSAGE("Should be World",
+            rWorld.equalsAsciiL(RTL_CONSTASCII_STRINGPARAM("World")));
+    }
+
+    //See https://www.libreoffice.org/bugzilla/show_bug.cgi?id=45271 for motivation
+    {
+        const sal_Unicode IDEOGRAPHICFULLSTOP_D[] = { 0x3002, 'D' };
+
+        m_pDoc->InsertString(aPaM, rtl::OUString(IDEOGRAPHICFULLSTOP_D,
+            SAL_N_ELEMENTS(IDEOGRAPHICFULLSTOP_D)));
+
+        SvxLanguageItem aCJKLangItem( LANGUAGE_CHINESE_SIMPLIFIED, RES_CHRATR_CJK_LANGUAGE );
+        SvxLanguageItem aWestLangItem( LANGUAGE_ENGLISH_US, RES_CHRATR_LANGUAGE );
+        m_pDoc->InsertPoolItem(aPaM, aCJKLangItem, 0 );
+        m_pDoc->InsertPoolItem(aPaM, aWestLangItem, 0 );
+
+        SwDocStat aDocStat;
+        pTxtNode->CountWords(aDocStat, 0, SAL_N_ELEMENTS(IDEOGRAPHICFULLSTOP_D));
+
+        CPPUNIT_ASSERT_MESSAGE("Should be 2", aDocStat.nChar == 2);
+        CPPUNIT_ASSERT_MESSAGE("Should be 2", aDocStat.nCharExcludingSpaces == 2);
+    }
+
+    //See https://issues.apache.org/ooo/show_bug.cgi?id=89042 for motivation
+    {
+        SwDocStat aDocStat;
+
+        const sal_Unicode aShouldBeThree[] = {
+            0x0053, 0x0068, 0x006F, 0x0075, 0x006C, 0x0064, 0x0020,
+            0x2018, 0x0062, 0x0065, 0x0020, 0x0074, 0x0068, 0x0072,
+            0x0065, 0x0065, 0x2019
+        };
+
+        m_pDoc->AppendTxtNode(*aPaM.GetPoint());
+        m_pDoc->InsertString(aPaM, rtl::OUString(aShouldBeThree, SAL_N_ELEMENTS(aShouldBeThree)));
+        pTxtNode = aPaM.GetNode()->GetTxtNode();
+        pTxtNode->CountWords(aDocStat, 0, SAL_N_ELEMENTS(aShouldBeThree));
+        CPPUNIT_ASSERT_MESSAGE("Should be 3", aDocStat.nWord == 3);
+
+        const sal_Unicode aShouldBeFive[] = {
+            0x0046, 0x0072, 0x0065, 0x006E, 0x0063, 0x0068, 0x0020,
+            0x00AB, 0x00A0, 0x0073, 0x0061, 0x0076, 0x006F, 0x0069,
+            0x0072, 0x0020, 0x0063, 0x0061, 0x006C, 0x0063, 0x0075,
+            0x006C, 0x0065, 0x0072, 0x00A0, 0x00BB
+        };
+
+        m_pDoc->AppendTxtNode(*aPaM.GetPoint());
+        m_pDoc->InsertString(aPaM, rtl::OUString(aShouldBeFive, SAL_N_ELEMENTS(aShouldBeFive)));
+        pTxtNode = aPaM.GetNode()->GetTxtNode();
+        pTxtNode->CountWords(aDocStat, 0, SAL_N_ELEMENTS(aShouldBeFive));
+        CPPUNIT_ASSERT_MESSAGE("Should be 5", aDocStat.nWord == 5);
+    }
 }
 
+
 //See https://bugs.freedesktop.org/show_bug.cgi?id=40599 for motivation
 void SwDocTest::testGraphicAnchorDeletion()
 {
diff --git a/sw/source/core/txtnode/txtedt.cxx b/sw/source/core/txtnode/txtedt.cxx
index 71749fd..a186cc6 100644
--- a/sw/source/core/txtnode/txtedt.cxx
+++ b/sw/source/core/txtnode/txtedt.cxx
@@ -723,6 +723,10 @@ sal_Bool SwScanner::NextWord()
                 pBreakIt->GetLocale( aCurrLang ), nWordType, sal_True );
         OSL_ENSURE( aBound.endPos >= aBound.startPos, "broken aBound result" );
 
+        // we don't want to include preceeding text
+        if (aBound.startPos < nBegin)
+            aBound.startPos = nBegin;
+
         //no word boundaries could be found
         if(aBound.endPos == aBound.startPos)
             return sal_False;
commit 45e4f9e99b75ef8a125228bc42df7fb98af9d7bc
Author: Caolán McNamara <caolanm at redhat.com>
Date:   Fri Mar 30 09:24:43 2012 +0100

    callcatcher: regenerate unused code list

diff --git a/oox/Library_oox.mk b/oox/Library_oox.mk
index 4224cf1..ddd7ad7 100644
--- a/oox/Library_oox.mk
+++ b/oox/Library_oox.mk
@@ -240,7 +240,6 @@ $(eval $(call gb_Library_add_exception_objects,oox,\
     oox/source/ole/vbainputstream \
     oox/source/ole/vbamodule \
     oox/source/ole/vbaproject \
-    oox/source/ole/vbaprojectfilter \
     oox/source/ppt/animationspersist \
     oox/source/ppt/animationtypes \
     oox/source/ppt/animvariantcontext \
diff --git a/oox/Package_inc.mk b/oox/Package_inc.mk
index 19d818a..c36dbc0 100644
--- a/oox/Package_inc.mk
+++ b/oox/Package_inc.mk
@@ -92,7 +92,6 @@ $(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/olehelper.hxx,oox/ole/oleh
 $(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/oleobjecthelper.hxx,oox/ole/oleobjecthelper.hxx))
 $(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/olestorage.hxx,oox/ole/olestorage.hxx))
 $(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/vbaproject.hxx,oox/ole/vbaproject.hxx))
-$(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/vbaprojectfilter.hxx,oox/ole/vbaprojectfilter.hxx))
 $(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/axcontrol.hxx,oox/ole/axcontrol.hxx))
 $(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/axbinaryreader.hxx,oox/ole/axbinaryreader.hxx))
 $(eval $(call gb_Package_add_file,oox_inc,inc/oox/ole/axfontdata.hxx,oox/ole/axfontdata.hxx))
diff --git a/oox/inc/oox/dump/dffdumper.hxx b/oox/inc/oox/dump/dffdumper.hxx
index de0913f..f961eb1 100644
--- a/oox/inc/oox/dump/dffdumper.hxx
+++ b/oox/inc/oox/dump/dffdumper.hxx
@@ -56,8 +56,6 @@ protected:
     virtual void        implDumpClientAnchor();
 
 private:
-    void                constructDffObj();
-
     sal_uInt32          dumpDffSimpleColor( const String& rName );
 
     void                dumpDffOpt();
diff --git a/oox/inc/oox/dump/dumperbase.hxx b/oox/inc/oox/dump/dumperbase.hxx
index ef95a79..7f18220 100644
--- a/oox/inc/oox/dump/dumperbase.hxx
+++ b/oox/inc/oox/dump/dumperbase.hxx
@@ -396,12 +396,9 @@ public:
 
     static void         appendToken( ::rtl::OUStringBuffer& rStr, const ::rtl::OUString& rToken, sal_Unicode cSep = OOX_DUMP_LISTSEP );
     static void         appendToken( ::rtl::OUStringBuffer& rStr, sal_Int64 nToken, sal_Unicode cSep = OOX_DUMP_LISTSEP );
-    static void         prependToken( ::rtl::OUStringBuffer& rStr, const ::rtl::OUString& rToken, sal_Unicode cSep = OOX_DUMP_LISTSEP );
 
     static void         appendIndex( ::rtl::OUStringBuffer& rStr, const ::rtl::OUString& rIdx );
     static void         appendIndex( ::rtl::OUStringBuffer& rStr, sal_Int64 nIdx );
-    static void         appendIndexedText( ::rtl::OUStringBuffer& rStr, const ::rtl::OUString& rData, const ::rtl::OUString& rIdx );
-    static void         appendIndexedText( ::rtl::OUStringBuffer& rStr, const ::rtl::OUString& rData, sal_Int64 nIdx );
 
     static ::rtl::OUString getToken( const ::rtl::OUString& rData, sal_Int32& rnPos, sal_Unicode cSep = OOX_DUMP_LISTSEP );
 
@@ -1350,8 +1347,6 @@ protected:
     void                writeCharItem( const String& rName, sal_Unicode cData );
     void                writeStringItem( const String& rName, const ::rtl::OUString& rData );
     void                writeArrayItem( const String& rName, const sal_uInt8* pnData, sal_Size nSize, sal_Unicode cSep = OOX_DUMP_LISTSEP );
-    double              writeRkItem( const String& rName, sal_Int32 nRk );
-    void                writeColorABGRItem( const String& rName, sal_Int32 nColor );
     void                writeDateTimeItem( const String& rName, const ::com::sun::star::util::DateTime& rDateTime );
     void                writeGuidItem( const String& rName, const ::rtl::OUString& rGuid );
     void                writeColIndexItem( const String& rName, sal_Int32 nCol );
diff --git a/oox/inc/oox/helper/propertyset.hxx b/oox/inc/oox/helper/propertyset.hxx
index fcdf66c..9f47f34 100644
--- a/oox/inc/oox/helper/propertyset.hxx
+++ b/oox/inc/oox/helper/propertyset.hxx
@@ -125,10 +125,6 @@ public:
         @param rPropertyMap  The property map. */
     void                setProperties( const PropertyMap& rPropertyMap );
 
-#if OSL_DEBUG_LEVEL > 0
-    void dump();
-#endif
-
     // ------------------------------------------------------------------------
 private:
     /** Gets the specified property from the property set.
diff --git a/oox/inc/oox/ole/vbaprojectfilter.hxx b/oox/inc/oox/ole/vbaprojectfilter.hxx
deleted file mode 100644
index 8cc029b..0000000
--- a/oox/inc/oox/ole/vbaprojectfilter.hxx
+++ /dev/null
@@ -1,64 +0,0 @@
-/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- *
- * Copyright 2000, 2010 Oracle and/or its affiliates.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Lesser General Public License version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-#ifndef OOX_OLE_VBAPROJECTFILTER_HXX
-#define OOX_OLE_VBAPROJECTFILTER_HXX
-
-#include "oox/core/binaryfilterbase.hxx"
-
-namespace oox {
-namespace ole {
-
-// ============================================================================
-
-class VbaProjectFilterBase : public ::oox::core::BinaryFilterBase
-{
-public:
-    explicit            VbaProjectFilterBase(
-                            const ::com::sun::star::uno::Reference< ::com::sun::star::uno::XComponentContext >& rxContext,
-                            const ::rtl::OUString& rAppName,
-                            const ::rtl::OUString& rStorageName )
-                            throw( ::com::sun::star::uno::RuntimeException );
-
-    virtual bool        importDocument() throw();
-    virtual bool        exportDocument() throw();
-
-private:
-    virtual VbaProject* implCreateVbaProject() const;
-
-private:
-    ::rtl::OUString     maAppName;
-    ::rtl::OUString     maStorageName;
-};
-
-} // namespace ole
-} // namespace oox
-
-#endif
-
-/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/oox/source/dump/dffdumper.cxx b/oox/source/dump/dffdumper.cxx
index c7abc53..9ffeddf 100644
--- a/oox/source/dump/dffdumper.cxx
+++ b/oox/source/dump/dffdumper.cxx
@@ -171,17 +171,6 @@ void DffStreamObject::implDumpClientAnchor()
 {
 }
 
-void DffStreamObject::constructDffObj()
-{
-    mnInstVer = 0;
-    mnRealSize = 0;
-    if( SequenceRecordObjectBase::implIsValid() )
-    {
-        maSimpleProps.insertFormats( cfg().getNameList( "DFFOPT-SIMPLE-PROPERTIES" ) );
-        maComplexProps.insertFormats( cfg().getNameList( "DFFOPT-COMPLEX-PROPERTIES" ) );
-    }
-}
-
 sal_uInt32 DffStreamObject::dumpDffSimpleColor( const String& rName )
 {
     return dumpHex< sal_uInt32 >( rName, "DFF-SIMPLE-COLOR" );
diff --git a/oox/source/dump/dumperbase.cxx b/oox/source/dump/dumperbase.cxx
index 481d68e..d7f8910 100644
--- a/oox/source/dump/dumperbase.cxx
+++ b/oox/source/dump/dumperbase.cxx
@@ -623,13 +623,6 @@ void StringHelper::appendToken( OUStringBuffer& rStr, sal_Int64 nToken, sal_Unic
     appendToken( rStr, aToken.makeStringAndClear(), cSep );
 }
 
-void StringHelper::prependToken( OUStringBuffer& rStr, const OUString& rToken, sal_Unicode cSep )
-{
-    if( rStr.getLength() > 0 && !rToken.isEmpty() )
-        rStr.insert( 0, cSep );
-    rStr.insert( 0, rToken );
-}
-
 void StringHelper::appendIndex( OUStringBuffer& rStr, const OUString& rIdx )
 {
     rStr.append( sal_Unicode( '[' ) ).append( rIdx ).append( sal_Unicode( ']' ) );
@@ -642,18 +635,6 @@ void StringHelper::appendIndex( OUStringBuffer& rStr, sal_Int64 nIdx )
     appendIndex( rStr, aToken.makeStringAndClear() );
 }
 
-void StringHelper::appendIndexedText( OUStringBuffer& rStr, const OUString& rData, const OUString& rIdx )
-{
-    rStr.append( rData );
-    appendIndex( rStr, rIdx );
-}
-
-void StringHelper::appendIndexedText( OUStringBuffer& rStr, const OUString& rData, sal_Int64 nIdx )
-{
-    rStr.append( rData );
-    appendIndex( rStr, nIdx );
-}
-
 OUString StringHelper::getToken( const OUString& rData, sal_Int32& rnPos, sal_Unicode cSep )
 {
     return trimSpaces( rData.getToken( 0, cSep, rnPos ) );
@@ -2227,26 +2208,6 @@ void OutputObjectBase::writeArrayItem( const String& rName, const sal_uInt8* pnD
     mxOut->writeArray( pnData, nSize, cSep );
 }
 
-double OutputObjectBase::writeRkItem( const String& rName, sal_Int32 nRk )
-{
-    MultiItemsGuard aMultiGuard( mxOut );
-    writeHexItem( rName, static_cast< sal_uInt32 >( nRk ), "RK-FLAGS" );
-#if FIXME
-    double fValue = ::oox::xls::BiffHelper::calcDoubleFromRk( nRk );
-#else
-    double fValue = 0.0;
-#endif
-    writeDecItem( "decoded", fValue );
-    return fValue;
-}
-
-void OutputObjectBase::writeColorABGRItem( const String& rName, sal_Int32 nColor )
-{
-    ItemGuard aItem( mxOut, rName );
-    writeHexItem( rName, nColor );
-    mxOut->writeColorABGR( nColor );
-}
-
 void OutputObjectBase::writeDateTimeItem( const String& rName, const DateTime& rDateTime )
 {
     ItemGuard aItem( mxOut, rName );
diff --git a/oox/source/helper/propertyset.cxx b/oox/source/helper/propertyset.cxx
index 8585a43..4b143db 100644
--- a/oox/source/helper/propertyset.cxx
+++ b/oox/source/helper/propertyset.cxx
@@ -154,15 +154,6 @@ bool PropertySet::implSetPropertyValue( const OUString& rPropName, const Any& rV
     return false;
 }
 
-#ifdef DBG_UTIL
-void PropertySet::dump()
-{
-    PropertyMap::dump( Reference< XPropertySet >( getXPropertySet(), UNO_QUERY ) );
-}
-#endif
-
-// ============================================================================
-
 } // namespace oox
 
 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/oox/source/ole/vbaprojectfilter.cxx b/oox/source/ole/vbaprojectfilter.cxx
deleted file mode 100644
index 23ca438..0000000
--- a/oox/source/ole/vbaprojectfilter.cxx
+++ /dev/null
@@ -1,78 +0,0 @@
-/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- *
- * Copyright 2000, 2010 Oracle and/or its affiliates.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Lesser General Public License version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-#include "oox/ole/vbaprojectfilter.hxx"
-
-#include "oox/ole/vbaproject.hxx"
-
-namespace oox {
-namespace ole {
-
-// ============================================================================
-
-using namespace ::com::sun::star::lang;
-using namespace ::com::sun::star::uno;
-
-using ::rtl::OUString;
-
-// ============================================================================
-
-VbaProjectFilterBase::VbaProjectFilterBase( const Reference< XComponentContext >& rxContext,
-        const OUString& rAppName, const OUString& rStorageName ) throw( RuntimeException ) :
-    BinaryFilterBase( rxContext ),
-    maAppName( rAppName ),
-    maStorageName( rStorageName )
-{
-}
-
-bool VbaProjectFilterBase::importDocument() throw()
-{
-    StorageRef xVbaPrjStrg = openSubStorage( maStorageName, false );
-    if( !xVbaPrjStrg || !xVbaPrjStrg->isStorage() )
-        return false;
-
-    getVbaProject().importVbaProject( *xVbaPrjStrg, getGraphicHelper() );
-    return true;
-}
-
-bool VbaProjectFilterBase::exportDocument() throw()
-{
-    return false;
-}
-
-VbaProject* VbaProjectFilterBase::implCreateVbaProject() const
-{
-    return new VbaProject( getComponentContext(), getModel(), maAppName );
-}
-
-// ============================================================================
-
-} // namespace ole
-} // namespace oox
-
-/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/sc/Library_scfilt.mk b/sc/Library_scfilt.mk
index 83ee7ad..b524ee0 100644
--- a/sc/Library_scfilt.mk
+++ b/sc/Library_scfilt.mk
@@ -164,7 +164,6 @@ $(eval $(call gb_Library_add_exception_objects,scfilt,\
         sc/source/filter/oox/autofilterbuffer \
         sc/source/filter/oox/autofiltercontext \
         sc/source/filter/oox/biffcodec \
-        sc/source/filter/oox/biffdetector \
         sc/source/filter/oox/biffhelper \
         sc/source/filter/oox/biffinputstream \
         sc/source/filter/oox/chartsheetfragment \
diff --git a/sc/source/filter/ftools/fapihelper.cxx b/sc/source/filter/ftools/fapihelper.cxx
index 328fb1b..0e3d73f 100644
--- a/sc/source/filter/ftools/fapihelper.cxx
+++ b/sc/source/filter/ftools/fapihelper.cxx
@@ -111,24 +111,6 @@ Reference< XInterface > ScfApiHelper::CreateInstance( const OUString& rServiceNa
     return CreateInstance( ::comphelper::getProcessServiceFactory(), rServiceName );
 }
 
-Reference< XInterface > ScfApiHelper::CreateInstanceWithArgs(
-        Reference< XMultiServiceFactory > xFactory, const OUString& rServiceName, const Sequence< Any >& rArgs )
-{
-    Reference< XInterface > xInt;
-    if( xFactory.is() )
-    {
-        try
-        {
-            xInt = xFactory->createInstanceWithArguments( rServiceName, rArgs );
-        }
-        catch( Exception& )
-        {
-            OSL_FAIL( "ScfApiHelper::CreateInstanceWithArgs - cannot create instance" );
-        }
-    }
-    return xInt;
-}
-
 uno::Sequence< beans::NamedValue > ScfApiHelper::QueryEncryptionDataForMedium( SfxMedium& rMedium,
         ::comphelper::IDocPasswordVerifier& rVerifier, const ::std::vector< OUString >* pDefaultPasswords )
 {
diff --git a/sc/source/filter/inc/biffcodec.hxx b/sc/source/filter/inc/biffcodec.hxx
index 2c3aeab..672a816 100644
--- a/sc/source/filter/inc/biffcodec.hxx
+++ b/sc/source/filter/inc/biffcodec.hxx
@@ -171,8 +171,6 @@ public:
     /** Implementation helper, reads the FILEPASS and returns a decoder object. */
     static BiffDecoderRef implReadFilePass( BiffInputStream& rStrm, BiffType eBiff );
 
-    /** Imports the FILEPASS record, asks for a password and sets a decoder at the stream. */
-    bool                importFilePass( BiffInputStream& rStrm );
     /** Clones the contained decoder object if existing and sets it at the passed stream. */
     void                cloneDecoder( BiffInputStream& rStrm );
 
diff --git a/sc/source/filter/inc/biffdetector.hxx b/sc/source/filter/inc/biffdetector.hxx
deleted file mode 100644
index 10c026b..0000000
--- a/sc/source/filter/inc/biffdetector.hxx
+++ /dev/null
@@ -1,64 +0,0 @@
-/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- *
- * Copyright 2000, 2010 Oracle and/or its affiliates.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Lesser General Public License version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-#ifndef OOX_XLS_BIFFDETECTOR_HXX
-#define OOX_XLS_BIFFDETECTOR_HXX
-
-#include <com/sun/star/document/XExtendedFilterDetection.hpp>
-#include <com/sun/star/lang/XServiceInfo.hpp>
-#include <cppuhelper/implbase2.hxx>
-#include "oox/helper/storagebase.hxx"
-#include "biffhelper.hxx"
-
-namespace com { namespace sun { namespace star {
-    namespace beans { struct PropertyValue; }
-    namespace uno { class XComponentContext; }
-} } }
-
-namespace oox { class BinaryInputStream; }
-
-namespace oox {
-namespace xls {
-
-// ============================================================================
-
-/** Detection service for BIFF streams or storages. */
-namespace BiffDetector
-{
-    /** Detects the BIFF version of the passed stream. */
-    BiffType detectStreamBiffVersion( BinaryInputStream& rInStream );
-};
-
-// ============================================================================
-
-} // namespace xls
-} // namespace oox
-
-#endif
-
-/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/sc/source/filter/inc/chartsheetfragment.hxx b/sc/source/filter/inc/chartsheetfragment.hxx
index 504a170..0145985 100644
--- a/sc/source/filter/inc/chartsheetfragment.hxx
+++ b/sc/source/filter/inc/chartsheetfragment.hxx
@@ -60,21 +60,6 @@ private:
     void                importDrawing( SequenceInputStream& rStrm );
 };
 
-// ============================================================================
-
-class BiffChartsheetFragment : public BiffWorksheetFragmentBase
-{
-public:
-    explicit            BiffChartsheetFragment(
-                            const WorksheetHelper& rHelper,
-                            const BiffWorkbookFragmentBase& rParent );
-
-    /** Imports the entire sheet fragment, returns true, if EOF record has been reached. */
-    virtual bool        importFragment();
-};
-
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/inc/excelfilter.hxx b/sc/source/filter/inc/excelfilter.hxx
index adad96a..483249f 100644
--- a/sc/source/filter/inc/excelfilter.hxx
+++ b/sc/source/filter/inc/excelfilter.hxx
@@ -31,7 +31,6 @@
 
 #include "oox/core/binaryfilterbase.hxx"
 #include "oox/core/xmlfilterbase.hxx"
-#include "oox/ole/vbaprojectfilter.hxx"
 
 namespace oox {
 namespace xls {
diff --git a/sc/source/filter/inc/excelhandlers.hxx b/sc/source/filter/inc/excelhandlers.hxx
index 46cc1c2..2051a55 100644
--- a/sc/source/filter/inc/excelhandlers.hxx
+++ b/sc/source/filter/inc/excelhandlers.hxx
@@ -167,16 +167,6 @@ protected:
     /** Returns the BIFF input stream of this fragment. */
     inline BiffInputStream& getInputStream() { return *mxBiffStrm; }
 
-    /** Starts a new fragment in a workbbok stream and returns the fragment type.
-
-        The passed stream must point before a BOF record. The function will
-        try to start the next record and read the contents of the BOF record,
-        if extant.
-
-        @return  Fragment type according to the imported BOF record.
-     */
-    BiffFragmentType    startFragment( BiffType eBiff );
-
     /** Skips the current fragment up to its trailing EOF record.
 
         Skips all records until next EOF record. When this function returns,
@@ -227,23 +217,6 @@ protected:
                             const BiffWorkbookFragmentBase& rParent );
 };
 
-// ----------------------------------------------------------------------------
-
-/** Special fragment handler for worksheets that have to be skipped.
- */
-class BiffSkipWorksheetFragment : public BiffWorksheetFragmentBase
-{
-public:
-    explicit            BiffSkipWorksheetFragment(
-                            const WorksheetHelper& rHelper,
-                            const BiffWorkbookFragmentBase& rParent );
-
-    virtual bool        importFragment();
-};
-
-// ============================================================================
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/inc/externallinkfragment.hxx b/sc/source/filter/inc/externallinkfragment.hxx
index 36b1d77..8324f4f 100644
--- a/sc/source/filter/inc/externallinkfragment.hxx
+++ b/sc/source/filter/inc/externallinkfragment.hxx
@@ -142,20 +142,6 @@ private:
     bool                mbImportDefNames;
 };
 
-// ============================================================================
-
-class BiffExternalLinkFragment : public BiffWorkbookFragmentBase
-{
-public:
-    explicit            BiffExternalLinkFragment( const BiffWorkbookFragmentBase& rParent );
-
-    /** Imports all records related to external links. */
-    virtual bool        importFragment();
-};
-
-// ============================================================================
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/inc/fapihelper.hxx b/sc/source/filter/inc/fapihelper.hxx
index 7a5f4dc..f34b9b1 100644
--- a/sc/source/filter/inc/fapihelper.hxx
+++ b/sc/source/filter/inc/fapihelper.hxx
@@ -91,12 +91,6 @@ public:
     /** Creates an instance from the passed service name, using the process service factory. */
     static XInterfaceRef CreateInstance( const ::rtl::OUString& rServiceName );
 
-    /** Creates an instance from the passed service name, using the passed service factory. */
-    static XInterfaceRef CreateInstanceWithArgs(
-                            XServiceFactoryRef xFactory,
-                            const ::rtl::OUString& rServiceName,
-                            const UnoAnySequence& rArgs );
-
     /** Opens a password dialog and returns the encryption data.
         @return  The encryption data or an empty sequence on 'Cancel' or any error. */
     static ::com::sun::star::uno::Sequence< ::com::sun::star::beans::NamedValue > QueryEncryptionDataForMedium( SfxMedium& rMedium,
diff --git a/sc/source/filter/inc/pivotcachebuffer.hxx b/sc/source/filter/inc/pivotcachebuffer.hxx
index 3c33916..7e7c16f 100644
--- a/sc/source/filter/inc/pivotcachebuffer.hxx
+++ b/sc/source/filter/inc/pivotcachebuffer.hxx
@@ -501,8 +501,6 @@ public:
 
     /** Registers a pivot cache definition fragment. The fragment will be loaded on demand (OOXML/BIFF12 only). */
     void                registerPivotCacheFragment( sal_Int32 nCacheId, const ::rtl::OUString& rFragmentPath );
-    /** Reads the reference to a pivot cache stream. The stream will be loaded on demand (BIFF2-BIFF8 only). */
-    void                importPivotCacheRef( BiffInputStream& rStrm );
 
     /** Imports and stores a pivot cache definition fragment on first call,
         returns the imported cache on subsequent calls with the same identifier. */
diff --git a/sc/source/filter/inc/sharedstringsbuffer.hxx b/sc/source/filter/inc/sharedstringsbuffer.hxx
index 124213d..a546fc7 100644
--- a/sc/source/filter/inc/sharedstringsbuffer.hxx
+++ b/sc/source/filter/inc/sharedstringsbuffer.hxx
@@ -44,8 +44,6 @@ public:
 
     /** Creates and returns a new string entry. */
     RichStringRef       createRichString();
-    /** Imports the complete shared string table from a BIFF file. */
-    void                importSst( BiffInputStream& rStrm );
 
     /** Final processing after import of all strings. */
     void                finalizeImport();
diff --git a/sc/source/filter/inc/sheetdatabuffer.hxx b/sc/source/filter/inc/sheetdatabuffer.hxx
index 9046a2f..dcf42bc 100644
--- a/sc/source/filter/inc/sheetdatabuffer.hxx
+++ b/sc/source/filter/inc/sheetdatabuffer.hxx
@@ -264,14 +264,9 @@ private:
         @param nNumFmtId  If set, overrides number format of the cell XF. */
     void                setCellFormat( const CellModel& rModel, sal_Int32 nNumFmtId = -1 );
 
-    /** Writes all cell formatting attributes to the passed row range. */
-    void                writeXfIdRowRangeProperties( const XfIdRowRange& rXfIdRowRange ) const;
-
     /** Writes all cell formatting attributes to the passed cell range list. (depreciates writeXfIdRangeProperties) */
     void                writeXfIdRangeListProperties( sal_Int32 nXfId, sal_Int32 nNumFmtId, const ApiCellRangeList& rRanges ) const;
     void                applyCellMerging( const ::com::sun::star::table::CellRangeAddress& rRange );
-    /** Merges the passed merged range and updates right/bottom cell borders. */
-    void                finalizeMergedRange( const ::com::sun::star::table::CellRangeAddress& rRange );
 
 private:
     /** Stores cell range address and formula token array of an array formula. */
diff --git a/sc/source/filter/inc/stylesbuffer.hxx b/sc/source/filter/inc/stylesbuffer.hxx
index 76f90f7..22af2be 100644
--- a/sc/source/filter/inc/stylesbuffer.hxx
+++ b/sc/source/filter/inc/stylesbuffer.hxx
@@ -921,7 +921,6 @@ public:
     inline const CellStyleModel& getModel() const { return maModel; }
     /** Returns the final style name used in the document. */
     inline const ::rtl::OUString& getFinalStyleName() const { return maFinalName; }
-    ::ScStyleSheet*       createStyleSheet();
 
 private:
     CellStyleModel      maModel;
@@ -1030,19 +1029,6 @@ public:
     /** Imports the CELLSTYLE record from the passed stream. */
     void                importCellStyle( SequenceInputStream& rStrm );
 
-    /** Imports the PALETTE record from the passed stream. */
-    void                importPalette( BiffInputStream& rStrm );
-    /** Imports the FONT record from the passed stream. */
-    void                importFont( BiffInputStream& rStrm );
-    /** Imports the FONTCOLOR record from the passed stream. */
-    void                importFontColor( BiffInputStream& rStrm );
-    /** Imports the FORMAT record from the passed stream. */
-    void                importFormat( BiffInputStream& rStrm );
-    /** Imports the XF record from the passed stream. */
-    void                importXf( BiffInputStream& rStrm );
-    /** Imports the STYLE record from the passed stream. */
-    void                importStyle( BiffInputStream& rStrm );
-
     /** Final processing after import of all style settings. */
     void                finalizeImport();
 
@@ -1089,8 +1075,6 @@ public:
     void                writeFillToItemSet( SfxItemSet& rItemSet, sal_Int32 nFillId, bool bSkipPoolDefs = false ) const;
     void                writeFillToPropertyMap( PropertyMap& rPropMap, sal_Int32 nFillId ) const;
     void                writeCellXfToMarkData( ::ScMarkData& rMark, sal_Int32 nXfId, sal_Int32 nNumFmtId );
-    /** Writes the cell formatting attributes of the specified XF to the passed property map. */
-    void                writeCellXfToPropertyMap( PropertyMap& rPropMap, sal_Int32 nXfId ) const;
 
     /** Writes the cell formatting attributes of the specified XF to the passed property set. */
     void                writeCellXfToPropertySet( PropertySet& rPropSet, sal_Int32 nXfId ) const;
diff --git a/sc/source/filter/inc/viewsettings.hxx b/sc/source/filter/inc/viewsettings.hxx
index 10da445..dde5451 100644
--- a/sc/source/filter/inc/viewsettings.hxx
+++ b/sc/source/filter/inc/viewsettings.hxx
@@ -188,10 +188,6 @@ public:
     void                importWorkbookView( SequenceInputStream& rStrm );
     /** Imports the OLESIZE record containing the visible size of the workbook. */
     void                importOleSize( SequenceInputStream& rStrm );
-    /** Imports the WINDOW1 record containing workbook view settings. */
-    void                importWindow1( BiffInputStream& rStrm );
-    /** Imports the OLESIZE record containing the visible size of the workbook. */
-    void                importOleSize( BiffInputStream& rStrm );
 
     /** Stores converted view settings for a specific worksheet. */
     void                setSheetViewSettings( sal_Int16 nSheet,
diff --git a/sc/source/filter/inc/workbookhelper.hxx b/sc/source/filter/inc/workbookhelper.hxx
index 8a048c5..e1f00ae 100644
--- a/sc/source/filter/inc/workbookhelper.hxx
+++ b/sc/source/filter/inc/workbookhelper.hxx
@@ -34,9 +34,6 @@
 #include "oox/helper/storagebase.hxx"
 #include "biffhelper.hxx"
 
-// use AVOID_UNO = 1 to prefer core calls over uno
-#define AVOID_UNO 1
-
 namespace com { namespace sun { namespace star {
     namespace container { class XNameAccess; }
     namespace container { class XNameContainer; }
@@ -283,16 +280,9 @@ public:
 
     /** Returns the text encoding used to import/export byte strings. */
     rtl_TextEncoding    getTextEncoding() const;
-    /** Sets code page read from a CODEPAGE record for byte string import. */
-    void                setCodePage( sal_uInt16 nCodePage );
     /** Sets text encoding from the default application font, if CODEPAGE record is missing. */
     void                setAppFontEncoding( rtl_TextEncoding eAppFontEnc );
 
-    /** Enables workbook file mode, used for BIFF4 workspace files. */
-    void                setIsWorkbookFile();
-    /** Recreates global buffers that are used per sheet in specific BIFF versions. */
-    void                createBuffersPerSheet( sal_Int16 nSheet );
-
     /** Returns the codec helper that stores the encoder/decoder object. */
     BiffCodecHelper&    getCodecHelper() const;
 
diff --git a/sc/source/filter/inc/workbooksettings.hxx b/sc/source/filter/inc/workbooksettings.hxx
index a52ee61..07683d4 100644
--- a/sc/source/filter/inc/workbooksettings.hxx
+++ b/sc/source/filter/inc/workbooksettings.hxx
@@ -111,34 +111,20 @@ public:
 
     /** Sets the save external linked values flag, e.g. from the WSBOOL record. */
     void                setSaveExtLinkValues( bool bSaveExtLinks );
-    /** Imports the BOOKBOOL record. */
-    void                importBookBool( BiffInputStream& rStrm );
     /** Imports the CALCCOUNT record. */
     void                importCalcCount( BiffInputStream& rStrm );
     /** Imports the CALCMODE record. */
     void                importCalcMode( BiffInputStream& rStrm );
-    /** Imports the CODENAME record. */
-    void                importCodeName( BiffInputStream& rStrm );
-    /** Imports the DATEMODE record. */
-    void                importDateMode( BiffInputStream& rStrm );
     /** Imports the DELTA record. */
     void                importDelta( BiffInputStream& rStrm );
-    /** Imports the FILESHARING record. */
-    void                importFileSharing( BiffInputStream& rStrm );
-    /** Imports the HIDEOBJ record. */
-    void                importHideObj( BiffInputStream& rStrm );
     /** Imports the ITERATION record. */
     void                importIteration( BiffInputStream& rStrm );
-    /** Imports the PRECISION record. */
-    void                importPrecision( BiffInputStream& rStrm );
     /** Imports the REFMODE record. */
     void                importRefMode( BiffInputStream& rStrm );
     /** Imports the SAVERECALC record. */
     void                importSaveRecalc( BiffInputStream& rStrm );
     /** Imports the UNCALCED record. */
     void                importUncalced( BiffInputStream& rStrm );
-    /** Imports the USESELFS record. */
-    void                importUsesElfs( BiffInputStream& rStrm );
 
     /** Converts the imported workbook settings. */
     void                finalizeImport();
diff --git a/sc/source/filter/inc/worksheetbuffer.hxx b/sc/source/filter/inc/worksheetbuffer.hxx
index f653c44..f66b872 100644
--- a/sc/source/filter/inc/worksheetbuffer.hxx
+++ b/sc/source/filter/inc/worksheetbuffer.hxx
@@ -71,15 +71,10 @@ public:
     /** Returns the base file name without path and file extension. */
     static ::rtl::OUString getBaseFileName( const ::rtl::OUString& rUrl );
 
-    /** Initializes the buffer for single sheet files (BIFF2-BIFF4). */
-    void                initializeSingleSheet();
-
     /** Imports the attributes of a sheet element. */
     void                importSheet( const AttributeList& rAttribs );
     /** Imports the SHEET record from the passed BIFF12 stream. */
     void                importSheet( SequenceInputStream& rStrm );
-    /** Imports the SHEET record from the passed BIFF stream. */
-    void                importSheet( BiffInputStream& rStrm );
     /** Inserts a new empty sheet into the document. Looks for an unused name.
          @return  Index of the new sheet in the Calc document. */
     sal_Int16           insertEmptySheet( const ::rtl::OUString& rPreferredName, bool bVisible );
@@ -88,8 +83,6 @@ public:
     sal_Int32           getWorksheetCount() const;
     /** Returns the OOXML relation identifier of the specified worksheet. */
     ::rtl::OUString     getWorksheetRelId( sal_Int32 nWorksheet ) const;
-    /** Returns the BIFF record handle of the associated sheet substream. */
-    sal_Int64           getBiffRecordHandle( sal_Int32 nWorksheet ) const;
 
     /** Returns the Calc index of the specified worksheet. */
     sal_Int16           getCalcSheetIndex( sal_Int32 nWorksheet ) const;
diff --git a/sc/source/filter/inc/worksheetfragment.hxx b/sc/source/filter/inc/worksheetfragment.hxx
index 093b482..2350ec5 100644
--- a/sc/source/filter/inc/worksheetfragment.hxx
+++ b/sc/source/filter/inc/worksheetfragment.hxx
@@ -126,65 +126,6 @@ private:
     void                importEmbeddedOleData( StreamDataSequence& orEmbeddedData, const ::rtl::OUString& rRelId );
 };
 
-// ============================================================================
-
-class BiffWorksheetFragment : public BiffWorksheetFragmentBase
-{
-public:
-    explicit            BiffWorksheetFragment(
-                            const WorksheetHelper& rHelper,
-                            const BiffWorkbookFragmentBase& rParent );
-    virtual             ~BiffWorksheetFragment();
-
-    /** Imports the entire worksheet fragment, returns true, if EOF record has been reached. */
-    virtual bool        importFragment();
-
-private:
-    /** Imports the AUTOFILTER and following records with auto filter settings. */
-    void                importAutoFilter( BiffInputStream& rStrm );
-    /** Imports the COLINFO record and sets column properties and formatting. */
-    void                importColInfo( BiffInputStream& rStrm );
-    /** Imports the BIFF2 COLUMNDEFAULT record and sets column default formatting. */
-    void                importColumnDefault( BiffInputStream& rStrm );
-    /** Imports the BIFF2 COLWIDTH record and sets column width. */
-    void                importColWidth( BiffInputStream& rStrm );
-    /** Imports the DATAVALIDATION record containing cell ranges with data validation settings. */
-    void                importDataValidation( BiffInputStream& rStrm );
-    /** Imports the DATAVALIDATIONS record containing global data validation settings. */
-    void                importDataValidations( BiffInputStream& rStrm );
-    /** Imports the DEFCOLWIDTH record and sets default column width. */
-    void                importDefColWidth( BiffInputStream& rStrm );
-    /** Imports the DEFROWHEIGHT record and sets default row height and properties. */
-    void                importDefRowHeight( BiffInputStream& rStrm );
-    /** Imports the DIMENSION record containing the used area of the sheet. */
-    void                importDimension( BiffInputStream& rStrm );
-    /** Imports the HYPERLINK record and sets a cell hyperlink. */
-    void                importHyperlink( BiffInputStream& rStrm );
-    /** Imports the LABELRANGES record and sets the imported label ranges. */
-    void                importLabelRanges( BiffInputStream& rStrm );
-    /** Imports the MEREDCELLS record and merges all cells in the document. */
-    void                importMergedCells( BiffInputStream& rStrm );
-    /** Imports the NOTE record containing a cell note. */
-    void                importNote( BiffInputStream& rStrm );
-    /** Imports the HORPAGEBREAKS or VERPAGEBREAKS record and inserts page breaks. */
-    void                importPageBreaks( BiffInputStream& rStrm, bool bRowBreak );
-    /** Imports a pivot table. */
-    void                importPTDefinition( BiffInputStream& rStrm );
-    /** Imports the QUERYTABLE and following records and inserts a web query. */
-    void                importQueryTable( BiffInputStream& rStrm );
-    /** Imports the SCENARIOS record and the following scenarios. */
-    void                importScenarios( BiffInputStream& rStrm );
-    /** Imports the SHAREDFEATHEAD record. */
-    void                importSharedFeatHead( BiffInputStream& rStrm );
-    /** Imports the STANDARDWIDTH record and sets standard column width. */
-    void                importStandardWidth( BiffInputStream& rStrm );
-
-private:
-    ::boost::shared_ptr< BiffWorksheetContextBase > mxContext;
-};
-
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/oox/biffcodec.cxx b/sc/source/filter/oox/biffcodec.cxx
index 5d791cd..a5808e5 100644
--- a/sc/source/filter/oox/biffcodec.cxx
+++ b/sc/source/filter/oox/biffcodec.cxx
@@ -357,17 +357,6 @@ BiffCodecHelper::BiffCodecHelper( const WorkbookHelper& rHelper ) :
     return xDecoder;
 }
 
-bool BiffCodecHelper::importFilePass( BiffInputStream& rStrm )
-{
-    OSL_ENSURE( !mxDecoder, "BiffCodecHelper::importFilePass - multiple FILEPASS records" );
-    mxDecoder = implReadFilePass( rStrm, getBiff() );
-    // request and verify a password (decoder implements IDocPasswordVerifier)
-    if( mxDecoder.get() )
-        getBaseFilter().requestEncryptionData( *mxDecoder );
-    // correct password is indicated by isValid() function of decoder
-    return mxDecoder.get() && mxDecoder->isValid();
-}
-
 void BiffCodecHelper::cloneDecoder( BiffInputStream& rStrm )
 {
     if( mxDecoder.get() )
diff --git a/sc/source/filter/oox/biffdetector.cxx b/sc/source/filter/oox/biffdetector.cxx
deleted file mode 100644
index 14ebbcf..0000000
--- a/sc/source/filter/oox/biffdetector.cxx
+++ /dev/null
@@ -1,110 +0,0 @@
-/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- *
- * Copyright 2000, 2010 Oracle and/or its affiliates.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Lesser General Public License version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-#include "biffdetector.hxx"
-
-#include <algorithm>
-#include <com/sun/star/io/XInputStream.hpp>
-#include <com/sun/star/uno/XComponentContext.hpp>
-#include <comphelper/mediadescriptor.hxx>
-#include <rtl/strbuf.hxx>
-#include "oox/helper/binaryinputstream.hxx"
-#include "oox/ole/olestorage.hxx"
-
-namespace oox {
-namespace xls {
-namespace BiffDetector {
-
-// ============================================================================
-
-using namespace ::com::sun::star::beans;
-using namespace ::com::sun::star::io;
-using namespace ::com::sun::star::lang;
-using namespace ::com::sun::star::uno;
-
-using ::comphelper::MediaDescriptor;
-using ::rtl::OStringBuffer;
-using ::rtl::OUString;
-
-BiffType detectStreamBiffVersion( BinaryInputStream& rInStream )
-{
-    BiffType eBiff = BIFF_UNKNOWN;
-    if( !rInStream.isEof() && rInStream.isSeekable() && (rInStream.size() > 4) )
-    {
-        sal_Int64 nOldPos = rInStream.tell();
-        rInStream.seekToStart();
-        sal_uInt16 nBofId, nBofSize;
-        rInStream >> nBofId >> nBofSize;
-
-        if( (4 <= nBofSize) && (nBofSize <= 16) && (rInStream.tell() + nBofSize <= rInStream.size()) )
-        {
-            switch( nBofId )
-            {
-                case BIFF2_ID_BOF:
-                    eBiff = BIFF2;
-                break;
-                case BIFF3_ID_BOF:
-                    eBiff = BIFF3;
-                break;
-                case BIFF4_ID_BOF:
-                    eBiff = BIFF4;
-                break;
-                case BIFF5_ID_BOF:
-                {
-                    if( 6 <= nBofSize )
-                    {
-                        sal_uInt16 nVersion;
-                        rInStream >> nVersion;
-                        // #i23425# #i44031# #i62752# there are some *really* broken documents out there...
-                        switch( nVersion & 0xFF00 )
-                        {
-                            case 0:                 eBiff = BIFF5;  break;  // #i44031# #i62752#
-                            case BIFF_BOF_BIFF2:    eBiff = BIFF2;  break;
-                            case BIFF_BOF_BIFF3:    eBiff = BIFF3;  break;
-                            case BIFF_BOF_BIFF4:    eBiff = BIFF4;  break;
-                            case BIFF_BOF_BIFF5:    eBiff = BIFF5;  break;
-                            case BIFF_BOF_BIFF8:    eBiff = BIFF8;  break;
-                            default:    OSL_FAIL( OStringBuffer( "lclDetectStreamBiffVersion - unknown BIFF version: 0x" ).
-                                append( static_cast< sal_Int32 >( nVersion ), 16 ).getStr() );
-                        }
-                    }
-                }
-                break;
-                // else do nothing, no BIFF stream
-            }
-        }
-        rInStream.seek( nOldPos );
-    }
-    return eBiff;
-}
-
-} // BiffDetector
-} // namespace xls
-} // namespace oox
-
-/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/sc/source/filter/oox/chartsheetfragment.cxx b/sc/source/filter/oox/chartsheetfragment.cxx
index e6e0f0b..9fae58a 100644
--- a/sc/source/filter/oox/chartsheetfragment.cxx
+++ b/sc/source/filter/oox/chartsheetfragment.cxx
@@ -177,115 +177,6 @@ void ChartsheetFragment::importDrawing( SequenceInputStream& rStrm )
     setDrawingPath( getFragmentPathFromRelId( BiffHelper::readString( rStrm ) ) );
 }
 
-// ============================================================================
-
-BiffChartsheetFragment::BiffChartsheetFragment( const WorksheetHelper& rHelper, const BiffWorkbookFragmentBase& rParent ) :
-    BiffWorksheetFragmentBase( rHelper, rParent )
-{
-}
-
-bool BiffChartsheetFragment::importFragment()
-{
-    // initial processing in base class WorksheetHelper
-    initializeWorksheetImport();
-
-    WorksheetSettings& rWorksheetSett = getWorksheetSettings();
-    SheetViewSettings& rSheetViewSett = getSheetViewSettings();
-    PageSettings& rPageSett           = getPageSettings();
-
-    // process all record in this sheet fragment
-    BiffInputStream& rStrm = getInputStream();
-    while( rStrm.startNextRecord() && (rStrm.getRecId() != BIFF_ID_EOF) )
-    {
-        if( BiffHelper::isBofRecord( rStrm ) )
-        {
-            // skip unknown embedded fragments (BOF/EOF blocks)
-            skipFragment();
-        }
-        else
-        {
-            sal_uInt16 nRecId = rStrm.getRecId();
-            switch( nRecId )
-            {
-                // records in all BIFF versions
-                case BIFF_ID_BOTTOMMARGIN:  rPageSett.importBottomMargin( rStrm );                  break;
-                case BIFF_ID_CHBEGIN:       BiffHelper::skipRecordBlock( rStrm, BIFF_ID_CHEND );    break;
-                case BIFF_ID_FOOTER:        rPageSett.importFooter( rStrm );                        break;
-                case BIFF_ID_HEADER:        rPageSett.importHeader( rStrm );                        break;
-                case BIFF_ID_LEFTMARGIN:    rPageSett.importLeftMargin( rStrm );                    break;
-                case BIFF_ID_PASSWORD:      rWorksheetSett.importPassword( rStrm );                 break;
-                case BIFF_ID_PROTECT:       rWorksheetSett.importProtect( rStrm );                  break;
-                case BIFF_ID_RIGHTMARGIN:   rPageSett.importRightMargin( rStrm );                   break;
-                case BIFF_ID_TOPMARGIN:     rPageSett.importTopMargin( rStrm );                     break;
-
-                // BIFF specific records
-                default: switch( getBiff() )
-                {
-                    case BIFF2: switch( nRecId )
-                    {
-                        case BIFF2_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF3: switch( nRecId )
-                    {
-                        case BIFF_ID_HCENTER:       rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_OBJECTPROTECT: rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_VCENTER:       rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-
-                    }
-                    break;
-
-                    case BIFF4: switch( nRecId )
-                    {
-                        case BIFF_ID_HCENTER:       rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_OBJECTPROTECT: rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_PAGESETUP:     rPageSett.importPageSetup( rStrm );             break;
-                        case BIFF_ID_VCENTER:       rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF5: switch( nRecId )
-                    {
-                        case BIFF_ID_HCENTER:       rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_OBJECTPROTECT: rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_PAGESETUP:     rPageSett.importPageSetup( rStrm );             break;
-                        case BIFF_ID_SCENPROTECT:   rWorksheetSett.importScenProtect( rStrm );      break;
-                        case BIFF_ID_SCL:           rSheetViewSett.importScl( rStrm );              break;
-                        case BIFF_ID_VCENTER:       rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF8: switch( nRecId )
-                    {
-                        case BIFF_ID_CODENAME:      rWorksheetSett.importCodeName( rStrm );         break;
-                        case BIFF_ID_HCENTER:       rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_OBJECTPROTECT: rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_PICTURE:       rPageSett.importPicture( rStrm );               break;
-                        case BIFF_ID_PAGESETUP:     rPageSett.importPageSetup( rStrm );             break;
-                        case BIFF_ID_SCL:           rSheetViewSett.importScl( rStrm );              break;
-                        case BIFF_ID_SHEETEXT:      rWorksheetSett.importSheetExt( rStrm );         break;
-                        case BIFF_ID_VCENTER:       rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF_UNKNOWN: break;
-                }
-            }
-        }
-    }
-
-    // final processing in base class WorksheetHelper
-    finalizeWorksheetImport();
-    return rStrm.getRecId() == BIFF_ID_EOF;
-}
-
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/oox/excelfilter.cxx b/sc/source/filter/oox/excelfilter.cxx
index db15a8d..84f9331 100644
--- a/sc/source/filter/oox/excelfilter.cxx
+++ b/sc/source/filter/oox/excelfilter.cxx
@@ -29,10 +29,7 @@
 #include "excelfilter.hxx"
 
 #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
-//#include "oox/dump/biffdumper.hxx"
-//#include "oox/dump/xlsbdumper.hxx"
 #include "oox/helper/binaryinputstream.hxx"
-#include "biffdetector.hxx"
 #include "biffinputstream.hxx"
 #include "excelchartconverter.hxx"
 #include "excelvbaproject.hxx"
diff --git a/sc/source/filter/oox/excelhandlers.cxx b/sc/source/filter/oox/excelhandlers.cxx
index a3d0b51..5d05dac 100644
--- a/sc/source/filter/oox/excelhandlers.cxx
+++ b/sc/source/filter/oox/excelhandlers.cxx
@@ -107,69 +107,6 @@ BiffFragmentHandler::~BiffFragmentHandler()
 {
 }
 
-BiffFragmentType BiffFragmentHandler::startFragment( BiffType eBiff )
-{
-    BiffFragmentType eFragment = BIFF_FRAGMENT_UNKNOWN;
-    /*  #i23425# Don't rely on BOF record ID to read BOF contents, but on
-        the detected BIFF version. */
-    if( mxBiffStrm->startNextRecord() && BiffHelper::isBofRecord( *mxBiffStrm ) )
-    {
-        // BOF is always written unencrypted
-        mxBiffStrm->enableDecoder( false );
-        mxBiffStrm->skip( 2 );
-        sal_uInt16 nType = mxBiffStrm->readuInt16();
-
-        // decide which fragment types are valid for current BIFF version
-        switch( eBiff )
-        {
-            case BIFF2: switch( nType )
-            {
-                case BIFF_BOF_CHART:    eFragment = BIFF_FRAGMENT_EMPTYSHEET;   break;
-                case BIFF_BOF_MACRO:    eFragment = BIFF_FRAGMENT_MACROSHEET;   break;
-                // #i51490# Excel interprets invalid types as worksheet
-                default:                eFragment = BIFF_FRAGMENT_WORKSHEET;
-            }
-            break;
-
-            case BIFF3: switch( nType )
-            {
-                case BIFF_BOF_CHART:    eFragment = BIFF_FRAGMENT_EMPTYSHEET;   break;
-                case BIFF_BOF_MACRO:    eFragment = BIFF_FRAGMENT_MACROSHEET;   break;
-                case BIFF_BOF_WORKSPACE:eFragment = BIFF_FRAGMENT_UNKNOWN;      break;
-                // #i51490# Excel interprets invalid types as worksheet
-                default:                eFragment = BIFF_FRAGMENT_WORKSHEET;
-            };
-            break;
-
-            case BIFF4: switch( nType )
-            {
-                case BIFF_BOF_CHART:    eFragment = BIFF_FRAGMENT_EMPTYSHEET;   break;
-                case BIFF_BOF_MACRO:    eFragment = BIFF_FRAGMENT_MACROSHEET;   break;
-                case BIFF_BOF_WORKSPACE:eFragment = BIFF_FRAGMENT_WORKSPACE;    break;
-                // #i51490# Excel interprets invalid types as worksheet
-                default:                eFragment = BIFF_FRAGMENT_WORKSHEET;
-            };
-            break;
-
-            case BIFF5:
-            case BIFF8: switch( nType )
-            {
-                case BIFF_BOF_GLOBALS:  eFragment = BIFF_FRAGMENT_GLOBALS;      break;
-                case BIFF_BOF_CHART:    eFragment = BIFF_FRAGMENT_CHARTSHEET;   break;
-                case BIFF_BOF_MACRO:    eFragment = BIFF_FRAGMENT_MACROSHEET;   break;
-                case BIFF_BOF_MODULE:   eFragment = BIFF_FRAGMENT_MODULESHEET;  break;
-                case BIFF_BOF_WORKSPACE:eFragment = BIFF_FRAGMENT_UNKNOWN;      break;
-                // #i51490# Excel interprets invalid types as worksheet
-                default:                eFragment = BIFF_FRAGMENT_WORKSHEET;
-            };
-            break;
-
-            case BIFF_UNKNOWN: break;
-        }
-    }
-    return eFragment;
-}
-
 bool BiffFragmentHandler::skipFragment()
 {
     while( mxBiffStrm->startNextRecord() && (mxBiffStrm->getRecId() != BIFF_ID_EOF) )
@@ -196,21 +133,6 @@ BiffWorksheetFragmentBase::BiffWorksheetFragmentBase( const WorksheetHelper& rHe
 {
 }
 
-// ----------------------------------------------------------------------------
-
-BiffSkipWorksheetFragment::BiffSkipWorksheetFragment( const WorksheetHelper& rHelper, const BiffWorkbookFragmentBase& rParent ) :
-    BiffWorksheetFragmentBase( rHelper, rParent )
-{
-}
-
-bool BiffSkipWorksheetFragment::importFragment()
-{
-    return skipFragment();
-}
-
-// ============================================================================
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/oox/externallinkfragment.cxx b/sc/source/filter/oox/externallinkfragment.cxx
index 0b7c379..a981cf3 100644
--- a/sc/source/filter/oox/externallinkfragment.cxx
+++ b/sc/source/filter/oox/externallinkfragment.cxx
@@ -496,7 +496,7 @@ void BiffExternalSheetDataContext::importCrn( BiffInputStream& rStrm )
                 rStrm.skip( 7 );
             break;
             default:
-                OSL_FAIL( "BiffExternalLinkFragment::importCrn - unknown data type" );
+                OSL_FAIL( "BiffExternalSheetDataContext::importCrn - unknown data type" );
                 bLoop = false;
         }
     }
@@ -520,31 +520,6 @@ void BiffExternalSheetDataContext::setCellValue( const BinAddress& rBinAddr, con
     }
 }
 
-// ============================================================================
-
-BiffExternalLinkFragment::BiffExternalLinkFragment( const BiffWorkbookFragmentBase& rParent ) :
-    BiffWorkbookFragmentBase( rParent )
-{
-}
-
-bool BiffExternalLinkFragment::importFragment()
-{
-    // process all record in this sheet fragment
-    BiffExternalSheetDataContext aSheetContext( *this, false );
-    BiffInputStream& rStrm = getInputStream();
-    while( rStrm.startNextRecord() && (rStrm.getRecId() != BIFF_ID_EOF) )
-    {
-        if( BiffHelper::isBofRecord( rStrm ) )
-            skipFragment();  // skip unknown embedded fragments
-        else
-            aSheetContext.importRecord( rStrm );
-    }
-    return !rStrm.isEof() && (rStrm.getRecId() == BIFF_ID_EOF);
-}
-
-// ============================================================================
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/oox/pivotcachebuffer.cxx b/sc/source/filter/oox/pivotcachebuffer.cxx
index 4a5c321..e51cd9d 100644
--- a/sc/source/filter/oox/pivotcachebuffer.cxx
+++ b/sc/source/filter/oox/pivotcachebuffer.cxx
@@ -1506,25 +1506,6 @@ void PivotCacheBuffer::registerPivotCacheFragment( sal_Int32 nCacheId, const OUS
         maFragmentPaths[ nCacheId ] = rFragmentPath;
 }
 
-void PivotCacheBuffer::importPivotCacheRef( BiffInputStream& rStrm )
-{
-    // read the PIVOTCACHE record that contains the stream ID
-    sal_Int32 nCacheId = rStrm.readuInt16();
-    OSL_ENSURE( maFragmentPaths.count( nCacheId ) == 0, "PivotCacheBuffer::importPivotCacheRef - cache stream exists already" );
-    OUStringBuffer aStrmName;
-    static const sal_Unicode spcHexChars[] = { '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F' };
-    for( sal_uInt8 nBit = 0; nBit < 16; nBit += 4 )
-        aStrmName.insert( 0, spcHexChars[ extractValue< size_t >( nCacheId, nBit, 4 ) ] );
-    aStrmName.insert( 0, (getBiff() == BIFF8) ? CREATE_OUSTRING( "_SX_DB_CUR/" ) : CREATE_OUSTRING( "_SX_DB/" ) );
-    maFragmentPaths[ nCacheId ] = aStrmName.makeStringAndClear();
-
-    // try to read PCDSOURCE record (will read following data location records too)
-    sal_uInt16 nNextRecId = rStrm.getNextRecId();
-    OSL_ENSURE( nNextRecId == BIFF_ID_PCDSOURCE, "PivotCacheBuffer::importPivotCacheRef - PCDSOURCE record expected" );
-    if( (nNextRecId == BIFF_ID_PCDSOURCE) && rStrm.startNextRecord() )
-        createPivotCache( nCacheId ).importPCDSource( rStrm );
-}
-
 PivotCache* PivotCacheBuffer::importPivotCacheFragment( sal_Int32 nCacheId )
 {
     switch( getFilterType() )
@@ -1557,8 +1538,7 @@ PivotCache* PivotCacheBuffer::importPivotCacheFragment( sal_Int32 nCacheId )
             workbook stream). First, this index has to be resolved to the cache
             identifier that is used to manage the cache stream names (the
             maFragmentPaths member). The cache object itself exists already
-            before the first call for the cache source index (see
-            PivotCacheBuffer::importPivotCacheRef() above), because source data
+            before the first call for the cache source index, because source data
             link is part of workbook data, not of the cache stream. To detect
             subsequent calls with an already initialized cache, the entry in
             maFragmentPaths will be removed after reading the cache stream. */
diff --git a/sc/source/filter/oox/sharedstringsbuffer.cxx b/sc/source/filter/oox/sharedstringsbuffer.cxx
index c71172f..5d38794 100644
--- a/sc/source/filter/oox/sharedstringsbuffer.cxx
+++ b/sc/source/filter/oox/sharedstringsbuffer.cxx
@@ -52,23 +52,6 @@ RichStringRef SharedStringsBuffer::createRichString()
     return xString;
 }
 
-void SharedStringsBuffer::importSst( BiffInputStream& rStrm )
-{
-    rStrm.skip( 4 );
-    sal_Int32 nStringCount = rStrm.readInt32();
-    if( nStringCount > 0 )
-    {
-        maStrings.clear();
-        maStrings.reserve( static_cast< size_t >( nStringCount ) );
-        for( ; !rStrm.isEof() && (nStringCount > 0); --nStringCount )
-        {
-            RichStringRef xString( new RichString( *this ) );
-            maStrings.push_back( xString );
-            xString->importUniString( rStrm );
-        }
-    }
-}
-
 void SharedStringsBuffer::finalizeImport()
 {
     maStrings.forEachMem( &RichString::finalizeImport );
diff --git a/sc/source/filter/oox/sheetdatabuffer.cxx b/sc/source/filter/oox/sheetdatabuffer.cxx
index 05ff3bb..4abf946 100644
--- a/sc/source/filter/oox/sheetdatabuffer.cxx
+++ b/sc/source/filter/oox/sheetdatabuffer.cxx
@@ -487,7 +487,6 @@ void SheetDataBuffer::finalizeImport()
             CellRangeAddress aRange( getSheetIndex(), 0, rangeIter->mnFirst, rAddrConv.getMaxApiAddress().Column, rangeIter->mnLast );
             rangeList.push_back( aRange );
         }
-#if AVOID_UNO
         ScRangeList aList;
         for ( ApiCellRangeList::const_iterator itRange = rangeList.begin(), itRange_end = rangeList.end(); itRange!=itRange_end; ++itRange )
         {
@@ -499,10 +498,6 @@ void SheetDataBuffer::finalizeImport()
         aMark.MarkFromRangeList( aList, false );
 
         getStyles().writeCellXfToMarkData( aMark, it->first, -1 );
-#else
-        PropertySet aPropSet( getCellRangeList( rangeList ) );
-        getStyles().writeCellXfToPropertySet( aPropSet, it->first );
-#endif
     }
     std::map< std::pair< sal_Int32, sal_Int32 >, ApiCellRangeList > rangeStyleListMap;
     // gather all ranges that have the same style and apply them in bulk
@@ -512,17 +507,9 @@ void SheetDataBuffer::finalizeImport()
         writeXfIdRangeListProperties( it->first.first, it->first.second, it->second );
     // merge all cached merged ranges and update right/bottom cell borders
     for( MergedRangeList::iterator aIt = maMergedRanges.begin(), aEnd = maMergedRanges.end(); aIt != aEnd; ++aIt )
-#if AVOID_UNO
         applyCellMerging( aIt->maRange );
-#else
-        finalizeMergedRange( aIt->maRange );
-#endif
     for( MergedRangeList::iterator aIt = maCenterFillRanges.begin(), aEnd = maCenterFillRanges.end(); aIt != aEnd; ++aIt )
-#if AVOID_UNO
         applyCellMerging( aIt->maRange );
-#else
-        finalizeMergedRange( aIt->maRange );
-#endif
 }
 
 // private --------------------------------------------------------------------
@@ -770,24 +757,9 @@ void SheetDataBuffer::setCellFormat( const CellModel& rModel, sal_Int32 nNumFmtI
     }
 }
 
-void SheetDataBuffer::writeXfIdRowRangeProperties( const XfIdRowRange& rXfIdRowRange ) const
-{
-    if( (rXfIdRowRange.maRowRange.mnLast >= 0) && (rXfIdRowRange.mnXfId >= 0) )
-    {
-        AddressConverter& rAddrConv = getAddressConverter();
-        CellRangeAddress aRange( getSheetIndex(), 0, rXfIdRowRange.maRowRange.mnFirst, rAddrConv.getMaxApiAddress().Column, rXfIdRowRange.maRowRange.mnLast );
-        if( rAddrConv.validateCellRange( aRange, true, false ) )
-        {
-            PropertySet aPropSet( getCellRange( aRange ) );
-            getStyles().writeCellXfToPropertySet( aPropSet, rXfIdRowRange.mnXfId );
-        }
-    }
-}
-
 void SheetDataBuffer::writeXfIdRangeListProperties( sal_Int32 nXfId, sal_Int32 nNumFmtId, const ApiCellRangeList& rRanges ) const
 {
     StylesBuffer& rStyles = getStyles();
-#if AVOID_UNO
     ScRangeList aList;
     for ( ApiCellRangeList::const_iterator it = rRanges.begin(), it_end = rRanges.end(); it!=it_end; ++it )
     {
@@ -798,15 +770,6 @@ void SheetDataBuffer::writeXfIdRangeListProperties( sal_Int32 nXfId, sal_Int32 n
     ScMarkData aMark;
     aMark.MarkFromRangeList( aList, false );
     rStyles.writeCellXfToMarkData( aMark, nXfId, nNumFmtId );
-#else
-    PropertyMap aPropMap;
-    if( nXfId >= 0 )
-        rStyles.writeCellXfToPropertyMap( aPropMap, nXfId );
-    if( nNumFmtId >= 0 )
-        rStyles.writeNumFmtToPropertyMap( aPropMap, nNumFmtId );
-    PropertySet aPropSet( getCellRangeList( rRanges ) );
-    aPropSet.setProperties( aPropMap );
-#endif
 }
 
 void lcl_SetBorderLine( ScDocument& rDoc, ScRange& rRange, SCTAB nScTab, sal_uInt16 nLine )
@@ -857,59 +820,6 @@ void SheetDataBuffer::applyCellMerging( const CellRangeAddress& rRange )
     }
 }
 
-void SheetDataBuffer::finalizeMergedRange( const CellRangeAddress& rRange )
-{
-    bool bMultiCol = rRange.StartColumn < rRange.EndColumn;
-    bool bMultiRow = rRange.StartRow < rRange.EndRow;
-
-    if( bMultiCol || bMultiRow ) try
-    {
-        // merge the cell range
-        Reference< XMergeable > xMerge( getCellRange( rRange ), UNO_QUERY_THROW );
-
-        xMerge->merge( sal_True );
-        // if merging this range worked (no overlapping merged ranges), update cell borders
-        Reference< XCell > xTopLeft( getCell( CellAddress( getSheetIndex(), rRange.StartColumn, rRange.StartRow ) ), UNO_SET_THROW );
-        PropertySet aTopLeftProp( xTopLeft );
-
-        // copy right border of top-right cell to right border of top-left cell
-        if( bMultiCol )
-        {
-            PropertySet aTopRightProp( getCell( CellAddress( getSheetIndex(), rRange.EndColumn, rRange.StartRow ) ) );
-            BorderLine aLine;
-            if( aTopRightProp.getProperty( aLine, PROP_RightBorder ) )
-                aTopLeftProp.setProperty( PROP_RightBorder, aLine );
-        }
-
-        // copy bottom border of bottom-left cell to bottom border of top-left cell
-        if( bMultiRow )
-        {
-            PropertySet aBottomLeftProp( getCell( CellAddress( getSheetIndex(), rRange.StartColumn, rRange.EndRow ) ) );
-            BorderLine aLine;
-            if( aBottomLeftProp.getProperty( aLine, PROP_BottomBorder ) )
-                aTopLeftProp.setProperty( PROP_BottomBorder, aLine );
-        }
-
-        // #i93609# merged range in a single row: test if manual row height is needed
-        if( !bMultiRow )
-        {
-            bool bTextWrap = aTopLeftProp.getBoolProperty( PROP_IsTextWrapped );
-            if( !bTextWrap && (xTopLeft->getType() == CellContentType_TEXT) )
-            {
-                Reference< XText > xText( xTopLeft, UNO_QUERY );
-                bTextWrap = xText.is() && (xText->getString().indexOf( '\x0A' ) >= 0);
-            }
-            if( bTextWrap )
-                setManualRowHeight( rRange.StartRow );
-        }
-    }
-    catch( Exception& )
-    {
-    }
-}
-
-// ============================================================================
-
 } // namespace xls
 } // namespace oox
 
diff --git a/sc/source/filter/oox/stylesbuffer.cxx b/sc/source/filter/oox/stylesbuffer.cxx
index 4f2935b..11a5608 100644
--- a/sc/source/filter/oox/stylesbuffer.cxx
+++ b/sc/source/filter/oox/stylesbuffer.cxx
@@ -3260,7 +3260,7 @@ void CellStyle::createCellStyle()
     // #i1624# #i1768# ignore unnamed user styles
     if( !mbCreated )
         mbCreated = maFinalName.isEmpty();
-#if AVOID_UNO
+
     ::ScDocument& rDoc = getScDocument();
     if( !mbCreated && !mpStyleSheet )
     {
@@ -3290,42 +3290,6 @@ void CellStyle::createCellStyle()
         if( bCreatePattern && mpStyleSheet && pXF )
             mpStyleSheet->GetItemSet().Put( pXF->createPattern( bDefStyle ).GetItemSet() );
     }
-#else
-    /*  #i103281# do not create another style of the same name, if it exists
-        already. This is needed to prevent that styles pasted from clipboard
-        get duplicated over and over. */
-    if( !mbCreated ) try
-    {
-        Reference< XNameAccess > xCellStylesNA( getStyleFamily( false ), UNO_QUERY_THROW );
-        mbCreated = xCellStylesNA->hasByName( maFinalName );
-    }
-    catch( Exception& )
-    {
-    }
-
-    // create the style object in the document
-    if( !mbCreated ) try
-    {
-        mbCreated = true;
-        Reference< XStyle > xStyle( createStyleObject( maFinalName, false ), UNO_SET_THROW );
-        // write style formatting properties
-        PropertySet aPropSet( xStyle );
-        getStyles().writeStyleXfToPropertySet( aPropSet, maModel.mnXfId );
-        if( !maModel.isDefaultStyle() )
-            xStyle->setParentStyle( getStyles().getDefaultStyleName() );
-    }
-    catch( Exception& )
-    {
-    }
-#endif
-}
-
-ScStyleSheet*
-CellStyle::createStyleSheet()
-{
-    if ( !mpStyleSheet )
-        createCellStyle();
-    return mpStyleSheet;
 }
 
 void CellStyle::finalizeImport( const OUString& rFinalName )
@@ -3615,58 +3579,6 @@ void StylesBuffer::importCellStyle( SequenceInputStream& rStrm )
     maCellStyles.importCellStyle( rStrm );
 }
 
-void StylesBuffer::importPalette( BiffInputStream& rStrm )
-{
-    maPalette.importPalette( rStrm );
-}
-
-void StylesBuffer::importFont( BiffInputStream& rStrm )
-{
-    /* Font with index 4 is not stored in BIFF. This means effectively, first
-        font in the BIFF file has index 0, fourth font has index 3, and fifth
-        font has index 5. Insert a dummy font to correctly map passed font
-        identifiers. */
-    if( maFonts.size() == 4 )
-        maFonts.push_back( maFonts.front() );
-
-    FontRef xFont = createFont();
-    xFont->importFont( rStrm );
-
-    /*  #i71033# Set stream text encoding from application font, if CODEPAGE
-        record is missing. Must be done now (not while finalizeImport() runs),
-        to be able to read all following byte strings correctly (e.g. cell
-        style names). */
-    if( maFonts.size() == 1 )
-        setAppFontEncoding( xFont->getFontEncoding() );
-}
-
-void StylesBuffer::importFontColor( BiffInputStream& rStrm )
-{
-    if( !maFonts.empty() )
-        maFonts.back()->importFontColor( rStrm );
-}
-
-void StylesBuffer::importFormat( BiffInputStream& rStrm )
-{
-    maNumFmts.importFormat( rStrm );
-}
-
-void StylesBuffer::importXf( BiffInputStream& rStrm )
-{
-    XfRef xXf( new Xf( *this ) );
-    xXf->importXf( rStrm );
-
-    XfRef xCellXf, xStyleXf;
-    (xXf->isCellXf() ? xCellXf : xStyleXf) = xXf;
-    maCellXfs.push_back( xCellXf );
-    maStyleXfs.push_back( xStyleXf );
-}
-
-void StylesBuffer::importStyle( BiffInputStream& rStrm )
-{
-    maCellStyles.importStyle( rStrm );
-}
-
 void StylesBuffer::finalizeImport()
 {
     // fonts first, are needed to finalize unit converter and XFs below
@@ -3906,12 +3818,6 @@ bool operator==( const Xf& rXf1, const Xf& rXf2 )
     return false;
 }
 
-void StylesBuffer::writeCellXfToPropertyMap( PropertyMap& rPropMap, sal_Int32 nXfId ) const
-{
-    if( Xf* pXf = maCellXfs.get( nXfId ).get() )
-        pXf->writeToPropertyMap( rPropMap );
-}
-
 void StylesBuffer::writeCellXfToPropertySet( PropertySet& rPropSet, sal_Int32 nXfId ) const
 {
     if( Xf* pXf = maCellXfs.get( nXfId ).get() )
diff --git a/sc/source/filter/oox/viewsettings.cxx b/sc/source/filter/oox/viewsettings.cxx
index ec954fc..10e9f9f 100644
--- a/sc/source/filter/oox/viewsettings.cxx
+++ b/sc/source/filter/oox/viewsettings.cxx
@@ -674,50 +674,6 @@ void ViewSettings::importOleSize( SequenceInputStream& rStrm )
     mbValidOleSize = getAddressConverter().convertToCellRange( maOleSize, aBinRange, 0, true, false );
 }
 
-void ViewSettings::importWindow1( BiffInputStream& rStrm )
-{
-    sal_uInt16 nWinX, nWinY, nWinWidth, nWinHeight;
-    rStrm >> nWinX >> nWinY >> nWinWidth >> nWinHeight;
-
-    // WINDOW1 record occures in every sheet in BIFF4W
-    OSL_ENSURE( maBookViews.empty() || ((getBiff() == BIFF4) && isWorkbookFile()),
-        "ViewSettings::importWindow1 - multiple WINDOW1 records" );
-    WorkbookViewModel& rModel = createWorkbookView();
-    rModel.mnWinX = nWinX;
-    rModel.mnWinY = nWinY;
-    rModel.mnWinWidth = nWinWidth;
-    rModel.mnWinHeight = nWinHeight;
-
-    if( getBiff() <= BIFF4 )
-    {
-        sal_uInt8 nHidden;
-        rStrm >> nHidden;
-        rModel.mnVisibility = (nHidden == 0) ? XML_visible : XML_hidden;
-    }
-    else
-    {
-        sal_uInt16 nFlags, nActiveTab, nFirstVisTab, nSelectCnt, nTabBarWidth;
-        rStrm >> nFlags >> nActiveTab >> nFirstVisTab >> nSelectCnt >> nTabBarWidth;
-
-        rModel.mnActiveSheet = nActiveTab;
-        rModel.mnFirstVisSheet = nFirstVisTab;
-        rModel.mnTabBarWidth = nTabBarWidth;
-        rModel.mnVisibility = getFlagValue( nFlags, BIFF_WINDOW1_HIDDEN, XML_hidden, XML_visible );
-        rModel.mbMinimized = getFlag( nFlags, BIFF_WINDOW1_MINIMIZED );
-        rModel.mbShowHorScroll = getFlag( nFlags, BIFF_WINDOW1_SHOWHORSCROLL );
-        rModel.mbShowVerScroll = getFlag( nFlags, BIFF_WINDOW1_SHOWVERSCROLL );
-        rModel.mbShowTabBar = getFlag( nFlags, BIFF_WINDOW1_SHOWTABBAR );
-    }
-}
-
-void ViewSettings::importOleSize( BiffInputStream& rStrm )
-{
-    rStrm.skip( 2 );
-    BinRange aBinRange;
-    aBinRange.read( rStrm, false );
-    mbValidOleSize = getAddressConverter().convertToCellRange( maOleSize, aBinRange, 0, true, false );
-}
-
 void ViewSettings::setSheetViewSettings( sal_Int16 nSheet, const SheetViewModelRef& rxSheetView, const Any& rProperties )
 {
     maSheetViews[ nSheet ] = rxSheetView;
diff --git a/sc/source/filter/oox/workbookhelper.cxx b/sc/source/filter/oox/workbookhelper.cxx
index c3c5134..5958d7b 100644
--- a/sc/source/filter/oox/workbookhelper.cxx
+++ b/sc/source/filter/oox/workbookhelper.cxx
@@ -962,26 +962,11 @@ rtl_TextEncoding WorkbookHelper::getTextEncoding() const
     return mrBookGlob.getTextEncoding();
 }
 
-void WorkbookHelper::setCodePage( sal_uInt16 nCodePage )
-{
-    mrBookGlob.setCodePage( nCodePage );
-}
-
 void WorkbookHelper::setAppFontEncoding( rtl_TextEncoding eAppFontEnc )
 {
     mrBookGlob.setAppFontEncoding( eAppFontEnc );
 }
 
-void WorkbookHelper::setIsWorkbookFile()
-{
-    mrBookGlob.setIsWorkbookFile();
-}
-
-void WorkbookHelper::createBuffersPerSheet( sal_Int16 nSheet )
-{
-    mrBookGlob.createBuffersPerSheet( nSheet );
-}
-
 BiffCodecHelper& WorkbookHelper::getCodecHelper() const
 {
     return mrBookGlob.getCodecHelper();
diff --git a/sc/source/filter/oox/workbooksettings.cxx b/sc/source/filter/oox/workbooksettings.cxx
index b07fa83..0bdbf41 100644
--- a/sc/source/filter/oox/workbooksettings.cxx
+++ b/sc/source/filter/oox/workbooksettings.cxx
@@ -195,12 +195,6 @@ void WorkbookSettings::setSaveExtLinkValues( bool bSaveExtLinks )
     maBookSettings.mbSaveExtLinkValues = bSaveExtLinks;
 }
 
-void WorkbookSettings::importBookBool( BiffInputStream& rStrm )
-{
-    // value of 0 means save external values, value of 1 means strip external values
-    maBookSettings.mbSaveExtLinkValues = rStrm.readuInt16() == 0;
-}
-
 void WorkbookSettings::importCalcCount( BiffInputStream& rStrm )
 {
     maCalcSettings.mnIterateCount = rStrm.readuInt16();
@@ -213,53 +207,16 @@ void WorkbookSettings::importCalcMode( BiffInputStream& rStrm )
     maCalcSettings.mnCalcMode = STATIC_ARRAY_SELECT( spnCalcModes, nCalcMode, XML_auto );
 }
 
-void WorkbookSettings::importCodeName( BiffInputStream& rStrm )
-{
-    maBookSettings.maCodeName = rStrm.readUniString();
-}
-
-void WorkbookSettings::importDateMode( BiffInputStream& rStrm )
-{
-    setDateMode( rStrm.readuInt16() != 0 );
-}
-
 void WorkbookSettings::importDelta( BiffInputStream& rStrm )
 {
     rStrm >> maCalcSettings.mfIterateDelta;
 }
 
-void WorkbookSettings::importFileSharing( BiffInputStream& rStrm )
-{
-    maFileSharing.mbRecommendReadOnly = rStrm.readuInt16() != 0;
-    rStrm >> maFileSharing.mnPasswordHash;
-    if( getBiff() == BIFF8 )
-    {
-        sal_uInt16 nStrLen = rStrm.readuInt16();
-        // there is no string flags field if string is empty
-        if( nStrLen > 0 )
-            maFileSharing.maUserName = rStrm.readUniStringBody( nStrLen );
-    }
-    else
-    {
-        maFileSharing.maUserName = rStrm.readByteStringUC( false, getTextEncoding() );
-    }
-}
-
-void WorkbookSettings::importHideObj( BiffInputStream& rStrm )
-{
-    maBookSettings.setBiffObjectMode( rStrm.readuInt16() );
-}
-
 void WorkbookSettings::importIteration( BiffInputStream& rStrm )
 {
     maCalcSettings.mbIterate = rStrm.readuInt16() != 0;
 }
 
-void WorkbookSettings::importPrecision( BiffInputStream& rStrm )
-{
-    maCalcSettings.mbFullPrecision = rStrm.readuInt16() != 0;
-}
-
 void WorkbookSettings::importRefMode( BiffInputStream& rStrm )
 {
     maCalcSettings.mnRefMode = (rStrm.readuInt16() == 0) ? XML_R1C1 : XML_A1;
@@ -276,11 +233,6 @@ void WorkbookSettings::importUncalced( BiffInputStream& )
     maCalcSettings.mbCalcCompleted = false;
 }
 
-void WorkbookSettings::importUsesElfs( BiffInputStream& rStrm )
-{
-    maCalcSettings.mbUseNlr = rStrm.readuInt16() != 0;
-}
-
 void WorkbookSettings::finalizeImport()
 {
     // default settings
diff --git a/sc/source/filter/oox/worksheetbuffer.cxx b/sc/source/filter/oox/worksheetbuffer.cxx
index 5178143..36ee6e3 100644
--- a/sc/source/filter/oox/worksheetbuffer.cxx
+++ b/sc/source/filter/oox/worksheetbuffer.cxx
@@ -78,14 +78,6 @@ WorksheetBuffer::WorksheetBuffer( const WorkbookHelper& rHelper ) :
     return rUrl.copy( nFileNamePos, nExtPos - nFileNamePos );
 }
 
-void WorksheetBuffer::initializeSingleSheet()
-{
-    OSL_ENSURE( maSheetInfos.empty(), "WorksheetBuffer::initializeSingleSheet - invalid call" );
-    SheetInfoModel aModel;
-    aModel.maName = getBaseFileName( getBaseFilter().getFileUrl() );
-    insertSheet( aModel );
-}
-
 void WorksheetBuffer::importSheet( const AttributeList& rAttribs )
 {
     SheetInfoModel aModel;
@@ -106,24 +98,6 @@ void WorksheetBuffer::importSheet( SequenceInputStream& rStrm )
     insertSheet( aModel );
 }
 
-void WorksheetBuffer::importSheet( BiffInputStream& rStrm )
-{
-    SheetInfoModel aModel;
-    if( getBiff() >= BIFF5 )
-    {
-        rStrm.enableDecoder( false );
-        aModel.mnBiffHandle = rStrm.readuInt32();
-        rStrm.enableDecoder( true );
-        sal_uInt16 nState = rStrm.readuInt16();
-        static const sal_Int32 spnStates[] = { XML_visible, XML_hidden, XML_veryHidden };
-        aModel.mnState = STATIC_ARRAY_SELECT( spnStates, nState, XML_visible );
-    }
-    aModel.maName = (getBiff() == BIFF8) ?
-        rStrm.readUniStringBody( rStrm.readuInt8() ) :
-        rStrm.readByteStringUC( false, getTextEncoding() );
-    insertSheet( aModel );
-}
-
 sal_Int16 WorksheetBuffer::insertEmptySheet( const OUString& rPreferredName, bool bVisible )
 {
     return createSheet( rPreferredName, SAL_MAX_INT32, bVisible ).first;
@@ -140,12 +114,6 @@ OUString WorksheetBuffer::getWorksheetRelId( sal_Int32 nWorksheet ) const
     return pSheetInfo ? pSheetInfo->maRelId : OUString();
 }
 
-sal_Int64 WorksheetBuffer::getBiffRecordHandle( sal_Int32 nWorksheet ) const
-{
-    const SheetInfo* pSheetInfo = maSheetInfos.get( nWorksheet ).get();
-    return pSheetInfo ? pSheetInfo->mnBiffHandle : -1;
-}
-
 sal_Int16 WorksheetBuffer::getCalcSheetIndex( sal_Int32 nWorksheet ) const
 {
     const SheetInfo* pSheetInfo = maSheetInfos.get( nWorksheet ).get();
diff --git a/sc/source/filter/oox/worksheetfragment.cxx b/sc/source/filter/oox/worksheetfragment.cxx
index b4484bd..8091112 100644
--- a/sc/source/filter/oox/worksheetfragment.cxx
+++ b/sc/source/filter/oox/worksheetfragment.cxx
@@ -735,286 +735,6 @@ void WorksheetFragment::importEmbeddedOleData( StreamDataSequence& orEmbeddedDat
         getBaseFilter().importBinaryData( orEmbeddedData, aFragmentPath );
 }
 
-// ============================================================================
-
-BiffWorksheetFragment::BiffWorksheetFragment( const WorksheetHelper& rHelper, const BiffWorkbookFragmentBase& rParent ) :
-    BiffWorksheetFragmentBase( rHelper, rParent )
-{
-}
-
-BiffWorksheetFragment::~BiffWorksheetFragment()
-{
-}
-
-bool BiffWorksheetFragment::importFragment()
-{
-    // initial processing in base class WorksheetHelper
-    initializeWorksheetImport();
-
-    // create a SheetDataContext object that implements cell import
-    BiffSheetDataContext aSheetData( *this );
-
-    WorkbookSettings& rWorkbookSett   = getWorkbookSettings();
-    WorksheetSettings& rWorksheetSett = getWorksheetSettings();
-    SheetViewSettings& rSheetViewSett = getSheetViewSettings();
-    CondFormatBuffer& rCondFormats    = getCondFormats();
-    PageSettings& rPageSett           = getPageSettings();
-    BiffSheetDrawing& rDrawing        = getBiffDrawing();
-
-    // process all record in this sheet fragment
-    BiffInputStream& rStrm = getInputStream();
-    while( rStrm.startNextRecord() && (rStrm.getRecId() != BIFF_ID_EOF) )
-    {
-        if( BiffHelper::isBofRecord( rStrm ) )
-        {
-            // skip unknown embedded fragments (BOF/EOF blocks)
-            skipFragment();
-        }
-        else
-        {
-            // cache base stream position to detect if record is already processed
-            sal_Int64 nStrmPos = rStrm.tellBase();
-            sal_uInt16 nRecId = rStrm.getRecId();
-
-            switch( nRecId )
-            {
-                // records in all BIFF versions
-                case BIFF_ID_BOTTOMMARGIN:      rPageSett.importBottomMargin( rStrm );      break;
-                case BIFF_ID_CALCCOUNT:         rWorkbookSett.importCalcCount( rStrm );     break;
-                case BIFF_ID_CALCMODE:          rWorkbookSett.importCalcMode( rStrm );      break;
-                case BIFF_ID_DEFCOLWIDTH:       importDefColWidth( rStrm );                 break;
-                case BIFF_ID_DELTA:             rWorkbookSett.importDelta( rStrm );         break;
-                case BIFF2_ID_DIMENSION:        importDimension( rStrm );                   break;
-                case BIFF3_ID_DIMENSION:        importDimension( rStrm );                   break;
-                case BIFF_ID_FOOTER:            rPageSett.importFooter( rStrm );            break;
-                case BIFF_ID_HEADER:            rPageSett.importHeader( rStrm );            break;
-                case BIFF_ID_HORPAGEBREAKS:     importPageBreaks( rStrm, true );            break;
-                case BIFF_ID_ITERATION:         rWorkbookSett.importIteration( rStrm );     break;
-                case BIFF_ID_LEFTMARGIN:        rPageSett.importLeftMargin( rStrm );        break;
-                case BIFF_ID_NOTE:              importNote( rStrm );                        break;
-                case BIFF_ID_PANE:              rSheetViewSett.importPane( rStrm );         break;
-                case BIFF_ID_PASSWORD:          rWorksheetSett.importPassword( rStrm );     break;
-                case BIFF_ID_PRINTGRIDLINES:    rPageSett.importPrintGridLines( rStrm );    break;
-                case BIFF_ID_PRINTHEADERS:      rPageSett.importPrintHeaders( rStrm );      break;
-                case BIFF_ID_PROTECT:           rWorksheetSett.importProtect( rStrm );      break;
-                case BIFF_ID_REFMODE:           rWorkbookSett.importRefMode( rStrm );       break;
-                case BIFF_ID_RIGHTMARGIN:       rPageSett.importRightMargin( rStrm );       break;
-                case BIFF_ID_SELECTION:         rSheetViewSett.importSelection( rStrm );    break;
-                case BIFF_ID_TOPMARGIN:         rPageSett.importTopMargin( rStrm );         break;
-                case BIFF_ID_VERPAGEBREAKS:     importPageBreaks( rStrm, false );           break;
-
-                // BIFF specific records
-                default: switch( getBiff() )
-                {
-                    case BIFF2: switch( nRecId )
-                    {
-                        case BIFF_ID_COLUMNDEFAULT: importColumnDefault( rStrm );           break;
-                        case BIFF_ID_COLWIDTH:      importColWidth( rStrm );                break;
-                        case BIFF2_ID_DEFROWHEIGHT: importDefRowHeight( rStrm );            break;
-                        case BIFF2_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );  break;
-                    }
-                    break;
-
-                    case BIFF3: switch( nRecId )
-                    {
-                        case BIFF_ID_COLINFO:       importColInfo( rStrm );                         break;
-                        case BIFF_ID_DEFCOLWIDTH:   importDefColWidth( rStrm );                     break;
-                        case BIFF3_ID_DEFROWHEIGHT: importDefRowHeight( rStrm );                    break;
-                        case BIFF_ID_HCENTER:       rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_OBJ:           rDrawing.importObj( rStrm );                    break;
-                        case BIFF_ID_OBJECTPROTECT: rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_SAVERECALC:    rWorkbookSett.importSaveRecalc( rStrm );        break;
-                        case BIFF_ID_SHEETPR:       rWorksheetSett.importSheetPr( rStrm );          break;
-                        case BIFF_ID_UNCALCED:      rWorkbookSett.importUncalced( rStrm );          break;
-                        case BIFF_ID_VCENTER:       rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF4: switch( nRecId )
-                    {
-                        case BIFF_ID_COLINFO:       importColInfo( rStrm );                         break;
-                        case BIFF3_ID_DEFROWHEIGHT: importDefRowHeight( rStrm );                    break;
-                        case BIFF_ID_HCENTER:       rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_OBJ:           rDrawing.importObj( rStrm );                    break;
-                        case BIFF_ID_OBJECTPROTECT: rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_PAGESETUP:     rPageSett.importPageSetup( rStrm );             break;
-                        case BIFF_ID_SAVERECALC:    rWorkbookSett.importSaveRecalc( rStrm );        break;
-                        case BIFF_ID_SHEETPR:       rWorksheetSett.importSheetPr( rStrm );          break;
-                        case BIFF_ID_STANDARDWIDTH: importStandardWidth( rStrm );                   break;
-                        case BIFF_ID_UNCALCED:      rWorkbookSett.importUncalced( rStrm );          break;
-                        case BIFF_ID_VCENTER:       rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF5: switch( nRecId )
-                    {
-                        case BIFF_ID_AUTOFILTER:    importAutoFilter( rStrm );                      break;
-                        case BIFF_ID_COLINFO:       importColInfo( rStrm );                         break;
-                        case BIFF3_ID_DEFROWHEIGHT: importDefRowHeight( rStrm );                    break;
-                        case BIFF_ID_HCENTER:       rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_MERGEDCELLS:   importMergedCells( rStrm );                     break;  // #i62300# also in BIFF5
-                        case BIFF_ID_OBJ:           rDrawing.importObj( rStrm );                    break;
-                        case BIFF_ID_OBJECTPROTECT: rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_PAGESETUP:     rPageSett.importPageSetup( rStrm );             break;
-                        case BIFF_ID_PTDEFINITION:  importPTDefinition( rStrm );                    break;
-                        case BIFF_ID_SAVERECALC:    rWorkbookSett.importSaveRecalc( rStrm );        break;
-                        case BIFF_ID_SCENPROTECT:   rWorksheetSett.importScenProtect( rStrm );      break;
-                        case BIFF_ID_SCL:           rSheetViewSett.importScl( rStrm );              break;
-                        case BIFF_ID_SHEETPR:       rWorksheetSett.importSheetPr( rStrm );          break;
-                        case BIFF_ID_STANDARDWIDTH: importStandardWidth( rStrm );                   break;
-                        case BIFF_ID_UNCALCED:      rWorkbookSett.importUncalced( rStrm );          break;
-                        case BIFF_ID_VCENTER:       rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:      rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF8: switch( nRecId )
-                    {
-                        case BIFF_ID_AUTOFILTER:        importAutoFilter( rStrm );                      break;
-                        case BIFF_ID_CFHEADER:          rCondFormats.importCfHeader( rStrm );           break;
-                        case BIFF_ID_CODENAME:          rWorksheetSett.importCodeName( rStrm );         break;
-                        case BIFF_ID_COLINFO:           importColInfo( rStrm );                         break;
-                        case BIFF_ID_DATAVALIDATION:    importDataValidation( rStrm );                  break;
-                        case BIFF_ID_DATAVALIDATIONS:   importDataValidations( rStrm );                 break;
-                        case BIFF3_ID_DEFROWHEIGHT:     importDefRowHeight( rStrm );                    break;
-                        case BIFF_ID_HCENTER:           rPageSett.importHorCenter( rStrm );             break;
-                        case BIFF_ID_HYPERLINK:         importHyperlink( rStrm );                       break;
-                        case BIFF_ID_LABELRANGES:       importLabelRanges( rStrm );                     break;
-                        case BIFF_ID_MERGEDCELLS:       importMergedCells( rStrm );                     break;
-                        case BIFF_ID_OBJ:               rDrawing.importObj( rStrm );                    break;
-                        case BIFF_ID_OBJECTPROTECT:     rWorksheetSett.importObjectProtect( rStrm );    break;
-                        case BIFF_ID_PAGESETUP:         rPageSett.importPageSetup( rStrm );             break;
-                        case BIFF_ID_PHONETICPR:        rWorksheetSett.importPhoneticPr( rStrm );       break;
-                        case BIFF_ID_PICTURE:           rPageSett.importPicture( rStrm );               break;
-                        case BIFF_ID_PTDEFINITION:      importPTDefinition( rStrm );                    break;
-                        case BIFF_ID_QUERYTABLE:        importQueryTable( rStrm );                      break;
-                        case BIFF_ID_SAVERECALC:        rWorkbookSett.importSaveRecalc( rStrm );        break;
-                        case BIFF_ID_SCENARIOS:         importScenarios( rStrm );                       break;
-                        case BIFF_ID_SCENPROTECT:       rWorksheetSett.importScenProtect( rStrm );      break;
-                        case BIFF_ID_SCL:               rSheetViewSett.importScl( rStrm );              break;
-                        case BIFF_ID_SHEETEXT:          rWorksheetSett.importSheetExt( rStrm );         break;
-                        case BIFF_ID_SHEETPR:           rWorksheetSett.importSheetPr( rStrm );          break;
-                        case BIFF_ID_SHAREDFEATHEAD:    importSharedFeatHead( rStrm );                  break;
-                        case BIFF_ID_STANDARDWIDTH:     importStandardWidth( rStrm );                   break;
-                        case BIFF_ID_UNCALCED:          rWorkbookSett.importUncalced( rStrm );          break;
-                        case BIFF_ID_VCENTER:           rPageSett.importVerCenter( rStrm );             break;
-                        case BIFF3_ID_WINDOW2:          rSheetViewSett.importWindow2( rStrm );          break;
-                    }
-                    break;
-
-                    case BIFF_UNKNOWN: break;
-                }
-            }
-
-            // record not processed, try record context objects
-            if( rStrm.tellBase() == nStrmPos )
-            {
-                // first, try cell table records
-                aSheetData.importRecord( rStrm );
-                // handle another open record context
-                if( mxContext.get() )
-                {
-                    // if it was a cell table record, forget the other record context
-                    if( rStrm.tellBase() == nStrmPos )
-                        mxContext->importRecord( rStrm );
-                    else
-                        mxContext.reset();
-                }
-            }
-        }
-    }
-
-    // final processing in base class WorksheetHelper
-    finalizeWorksheetImport();
-    return rStrm.getRecId() == BIFF_ID_EOF;
-}
-
-// private --------------------------------------------------------------------
-
-void BiffWorksheetFragment::importAutoFilter( BiffInputStream& rStrm )
-{
-    mxContext.reset( new BiffAutoFilterContext( *this, getAutoFilters().createAutoFilter() ) );
-    mxContext->importRecord( rStrm );
-}
-
-void BiffWorksheetFragment::importColInfo( BiffInputStream& rStrm )
-{
-    sal_uInt16 nFirstCol, nLastCol, nWidth, nXfId, nFlags;
-    rStrm >> nFirstCol >> nLastCol >> nWidth >> nXfId >> nFlags;
-
-    ColumnModel aModel;
-    // column indexes are 0-based in BIFF, but ColumnModel expects 1-based
-    aModel.maRange.mnFirst = static_cast< sal_Int32 >( nFirstCol ) + 1;
-    aModel.maRange.mnLast  = static_cast< sal_Int32 >( nLastCol ) + 1;
-    // width is stored as 1/256th of a character in BIFF, convert to entire character
-    aModel.mfWidth         = static_cast< double >( nWidth ) / 256.0;
-    aModel.mnXfId          = nXfId;
-    aModel.mnLevel         = extractValue< sal_Int32 >( nFlags, 8, 3 );
-    aModel.mbShowPhonetic  = getFlag( nFlags, BIFF_COLINFO_SHOWPHONETIC );
-    aModel.mbHidden        = getFlag( nFlags, BIFF_COLINFO_HIDDEN );
-    aModel.mbCollapsed     = getFlag( nFlags, BIFF_COLINFO_COLLAPSED );
-    // set column properties in the current sheet
-    setColumnModel( aModel );
-}
-
-void BiffWorksheetFragment::importColumnDefault( BiffInputStream& rStrm )
-{
-    sal_uInt16 nFirstCol, nLastCol, nXfId;
-    rStrm >> nFirstCol >> nLastCol >> nXfId;
-    setDefaultColumnFormat( nFirstCol, nLastCol, nXfId );
-}
-
-void BiffWorksheetFragment::importColWidth( BiffInputStream& rStrm )
-{
-    sal_uInt8 nFirstCol, nLastCol;
-    sal_uInt16 nWidth;
-    rStrm >> nFirstCol >> nLastCol >> nWidth;
-
-    ColumnModel aModel;
-    // column indexes are 0-based in BIFF, but ColumnModel expects 1-based
-    aModel.maRange.mnFirst = static_cast< sal_Int32 >( nFirstCol ) + 1;
-    aModel.maRange.mnLast = static_cast< sal_Int32 >( nLastCol ) + 1;

... etc. - the rest is truncated


More information about the Libreoffice-commits mailing list