These methods are now unused. Chuck them.

Change-Id: Ib9b0ad855142434e45bcb4d805fc32e7c76b01b8

1 files changed, 0 insertions, 347 deletions

diff --git a/sc/source/core/tool/refupdat.cxx b/sc/source/core/tool/refupdat.cxx
index ca993bdee26b..5ae57bef63ec 100644
--- a/sc/source/core/tool/refupdat.cxx
+++ b/sc/source/core/tool/refupdat.cxx
@@ -480,353 +480,6 @@ ScRefUpdateRes ScRefUpdate::Update( UpdateRefMode eUpdateRefMode,
     return eRet;
 }
 
-
-ScRefUpdateRes ScRefUpdate::Update(
-    ScDocument* pDoc, UpdateRefMode eMode, const ScAddress& rPos, const ScRange& rRange,
-    SCsCOL nDx, SCsROW nDy, SCsTAB nDz, ScComplexRefData& rRef, ScRange& rRefRange,
-    WhatType eWhat )
-{
-    ScRefUpdateRes eRet = UR_NOTHING;
-
-    // Range that shifted.
-    SCCOL nCol1 = rRange.aStart.Col();
-    SCROW nRow1 = rRange.aStart.Row();
-    SCTAB nTab1 = rRange.aStart.Tab();
-    SCCOL nCol2 = rRange.aEnd.Col();
-    SCROW nRow2 = rRange.aEnd.Row();
-    SCTAB nTab2 = rRange.aEnd.Tab();
-
-    if( eMode == URM_INSDEL )
-    {
-        // Insertion or deletion
-        bool bExpand = pDoc->IsExpandRefs();
-
-        const ScChangeTrack* pChangeTrack = pDoc->GetChangeTrack();
-        bool bInDeleteUndo =
-            ( pChangeTrack ? pChangeTrack->IsInDeleteUndo() : false );
-
-        // Store the old reference range.
-        SCCOL nOldCol1 = rRefRange.aStart.Col();
-        SCROW nOldRow1 = rRefRange.aStart.Row();
-        SCTAB nOldTab1 = rRefRange.aStart.Tab();
-        SCCOL nOldCol2 = rRefRange.aEnd.Col();
-        SCROW nOldRow2 = rRefRange.aEnd.Row();
-        SCTAB nOldTab2 = rRefRange.aEnd.Tab();
-
-        bool bRef1ColDel = rRef.Ref1.IsColDeleted();
-        bool bRef2ColDel = rRef.Ref2.IsColDeleted();
-        bool bRef1RowDel = rRef.Ref1.IsRowDeleted();
-        bool bRef2RowDel = rRef.Ref2.IsRowDeleted();
-        bool bRef1TabDel = rRef.Ref1.IsTabDeleted();
-        bool bRef2TabDel = rRef.Ref2.IsTabDeleted();
-
-        if (nDx &&
-            ((nRow1 <= rRefRange.aStart.Row() && rRefRange.aEnd.Row() <= nRow2) || (bRef1RowDel || bRef2RowDel)) &&
-            ((nTab1 <= rRefRange.aStart.Tab() && rRefRange.aEnd.Tab() <= nTab2) || (bRef1TabDel || bRef2TabDel)))
-        {
-            // Shift in the column direction, reference range has at least one
-            // deleted row or sheet, and the reference range is within the
-            // shifted region.
-            bool bExp = (bExpand && !bInDeleteUndo && IsExpand(rRefRange.aStart.Col(), rRefRange.aEnd.Col(), nCol1, nDx));
-            bool bDo1 = (eWhat == ScRefUpdate::ALL || (eWhat == ScRefUpdate::ABSOLUTE && !rRef.Ref1.IsColRel()));
-            bool bDo2 = (eWhat == ScRefUpdate::ALL || (eWhat == ScRefUpdate::ABSOLUTE && !rRef.Ref2.IsColRel()));
-            SCCOL nRefCol1 = rRefRange.aStart.Col(), nRefCol2 = rRefRange.aEnd.Col();
-            if ( lcl_MoveRefPart(nRefCol1, bRef1ColDel, bDo1,
-                                 nRefCol2, bRef2ColDel, bDo2,
-                                  nCol1, nCol2, nDx, MAXCOL ) )
-            {
-                rRefRange.aStart.SetCol(nRefCol1);
-                rRefRange.aEnd.SetCol(nRefCol2);
-
-                eRet = UR_UPDATED;
-                if ( bInDeleteUndo && (bRef1ColDel || bRef2ColDel) )
-                {
-                    if (bRef1ColDel &&
-                        nCol1 <= rRefRange.aStart.Col() && rRefRange.aStart.Col() <= nCol1 + nDx)
-                        rRef.Ref1.SetColDeleted( false );
-                    if (bRef2ColDel &&
-                        nCol1 <= rRefRange.aEnd.Col() && rRefRange.aEnd.Col() <= nCol1 + nDx)
-                        rRef.Ref2.SetColDeleted( false );
-                }
-                else
-                {
-                    if ( bRef1ColDel )
-                        rRef.Ref1.SetColDeleted( true );
-                    if ( bRef2ColDel )
-                        rRef.Ref2.SetColDeleted( true );
-                }
-            }
-            if ( bExp )
-            {
-                nRefCol1 = rRefRange.aStart.Col();
-                nRefCol2 = rRefRange.aEnd.Col();
-                Expand(nRefCol1, nRefCol2, nCol1, nDx);
-                rRefRange.aStart.SetCol(nRefCol1);
-                rRefRange.aEnd.SetCol(nRefCol2);
-
-                eRet = UR_UPDATED;
-            }
-        }
-
-        if (nDy &&
-            ((nCol1 <= rRefRange.aStart.Col() && rRefRange.aEnd.Col() <= nCol2) || (bRef1ColDel || bRef2ColDel)) &&
-            ((nTab1 <= rRefRange.aStart.Tab() && rRefRange.aEnd.Tab() <= nTab2) || (bRef1TabDel || bRef2TabDel)))
-        {
-            // Shift in the row direction, reference range has at least one
-            // deleted column or sheet, and the reference range is within the
-            // shifted region.
-            bool bExp = (bExpand && !bInDeleteUndo && IsExpand(rRefRange.aStart.Row(), rRefRange.aEnd.Row(), nRow1, nDy));
-            bool bDo1 = (eWhat == ScRefUpdate::ALL || (eWhat ==
-                        ScRefUpdate::ABSOLUTE && !rRef.Ref1.IsRowRel()));
-            bool bDo2 = (eWhat == ScRefUpdate::ALL || (eWhat ==
-                        ScRefUpdate::ABSOLUTE && !rRef.Ref2.IsRowRel()));
-            SCROW nRefRow1 = rRefRange.aStart.Row(), nRefRow2 = rRefRange.aEnd.Row();
-            if (lcl_MoveRefPart(nRefRow1, bRef1RowDel, bDo1, nRefRow2, bRef2RowDel, bDo2, nRow1, nRow2, nDy, MAXROW))
-            {
-                rRefRange.aStart.SetRow(nRefRow1);
-                rRefRange.aEnd.SetRow(nRefRow2);
-                eRet = UR_UPDATED;
-                if ( bInDeleteUndo && (bRef1RowDel || bRef2RowDel) )
-                {
-                    if (bRef1RowDel && nRow1 <= rRefRange.aStart.Row() && rRefRange.aStart.Row() <= nRow1 + nDy)
-                        rRef.Ref1.SetRowDeleted( false );
-                    if (bRef2RowDel && nRow1 <= rRefRange.aEnd.Row() && rRefRange.aEnd.Row() <= nRow1 + nDy)
-                        rRef.Ref2.SetRowDeleted( false );
-                }
-                else
-                {
-                    if ( bRef1RowDel )
-                        rRef.Ref1.SetRowDeleted( true );
-                    if ( bRef2RowDel )
-                        rRef.Ref2.SetRowDeleted( true );
-                }
-            }
-            if ( bExp )
-            {
-                nRefRow1 = rRefRange.aStart.Row();
-                nRefRow2 = rRefRange.aEnd.Row();
-                Expand(nRefRow1, nRefRow2, nRow1, nDy);
-                rRefRange.aStart.SetRow(nRefRow1);
-                rRefRange.aEnd.SetRow(nRefRow2);
-                eRet = UR_UPDATED;
-            }
-        }
-
-        if (nDz &&
-            ((nCol1 <= rRefRange.aStart.Col() && rRefRange.aEnd.Col() <= nCol2) || (bRef1ColDel || bRef2ColDel)) &&
-            ((nRow1 <= rRefRange.aStart.Row() && rRefRange.aEnd.Row() <= nRow2) || (bRef1RowDel || bRef2RowDel)))
-        {
-            // Shift in the sheet direction, reference range has at least one
-            // deleted column or row, and the reference range is within the
-            // shifted region.
-            bool bExp = (bExpand && !bInDeleteUndo && IsExpand(rRefRange.aStart.Tab(), rRefRange.aEnd.Tab(), nTab1, nDz));
-            SCTAB nMaxTab = pDoc->GetTableCount() - 1;
-            bool bDo1 = (eWhat == ScRefUpdate::ALL || (eWhat ==
-                        ScRefUpdate::ABSOLUTE && !rRef.Ref1.IsTabRel()));
-            bool bDo2 = (eWhat == ScRefUpdate::ALL || (eWhat ==
-                        ScRefUpdate::ABSOLUTE && !rRef.Ref2.IsTabRel()));
-
-            SCTAB nRefTab1 = rRefRange.aStart.Tab(), nRefTab2 = rRefRange.aEnd.Tab();
-            if (lcl_MoveRefPart(nRefTab1, bRef1TabDel, bDo1, nRefTab2, bRef2TabDel, bDo2, nTab1, nTab2, nDz, nMaxTab))
-            {
-                rRefRange.aStart.SetTab(nRefTab1);
-                rRefRange.aEnd.SetTab(nRefTab2);
-                eRet = UR_UPDATED;
-                if ( bInDeleteUndo && (bRef1TabDel || bRef2TabDel) )
-                {
-                    if (bRef1TabDel && nTab1 <= rRefRange.aStart.Tab() && rRefRange.aStart.Tab() <= nTab1 + nDz)
-                        rRef.Ref1.SetTabDeleted( false );
-                    if (bRef2TabDel && nTab1 <= rRefRange.aEnd.Tab() && rRefRange.aEnd.Tab() <= nTab1 + nDz)
-                        rRef.Ref2.SetTabDeleted( false );
-                }
-                else
-                {
-                    if ( bRef1TabDel )
-                        rRef.Ref1.SetTabDeleted( true );
-                    if ( bRef2TabDel )
-                        rRef.Ref2.SetTabDeleted( true );
-                }
-            }
-            if ( bExp )
-            {
-                nRefTab1 = rRefRange.aStart.Tab();
-                nRefTab2 = rRefRange.aEnd.Tab();
-                Expand(nRefTab1, nRefTab2, nTab1, nDz);
-                rRefRange.aStart.SetTab(nRefTab1);
-                rRefRange.aEnd.SetTab(nRefTab2);
-                eRet = UR_UPDATED;
-            }
-        }
-        if ( eRet == UR_NOTHING )
-        {
-            if (nOldCol1 != rRefRange.aStart.Col()
-             || nOldRow1 != rRefRange.aStart.Row()
-             || nOldTab1 != rRefRange.aStart.Tab()
-             || nOldCol2 != rRefRange.aEnd.Col()
-             || nOldRow2 != rRefRange.aEnd.Row()
-             || nOldTab2 != rRefRange.aEnd.Tab()
-                )
-                // Reference has changed, but the flag has not been set !?
-                eRet = UR_UPDATED;
-        }
-    }
-    else if( eMode == URM_MOVE )
-    {
-        // Move
-        if ( rRefRange.aStart.Col() >= nCol1-nDx
-          && rRefRange.aStart.Row() >= nRow1-nDy
-          && rRefRange.aStart.Tab() >= nTab1-nDz
-          && rRefRange.aEnd.Col() <= nCol2-nDx
-          && rRefRange.aEnd.Row() <= nRow2-nDy
-          && rRefRange.aEnd.Tab() <= nTab2-nDz )
-        {
-            eRet = Move(pDoc, rPos, nDx, nDy, nDz, rRef, rRefRange, false, true);        // immer verschieben
-        }
-        else if ( nDz && rRange.In( rPos ) )
-        {
-            rRef.Ref1.SetFlag3D( true );
-            rRef.Ref2.SetFlag3D( true );
-            eRet = UR_UPDATED;
-        }
-    }
-    else if( eMode == URM_COPY && rRange.In( rPos ) )
-    {
-        eRet = Move(pDoc, rPos, nDx, nDy, nDz, rRef, rRefRange, false, false);       // nur relative
-        // sollte nicht mehr verwendet werden muessen
-    }
-
-    return eRet;
-}
-
-
-ScRefUpdateRes ScRefUpdate::Move(
-    ScDocument* pDoc, const ScAddress& rPos, SCsCOL nDx, SCsROW nDy, SCsTAB nDz,
-    ScComplexRefData& rRef, ScRange& rRefRange, bool bWrap, bool bAbsolute )
-{
-    ScRefUpdateRes eRet = UR_NOTHING;
-
-    SCCOL nOldCol1 = rRef.Ref1.nCol;
-    SCROW nOldRow1 = rRef.Ref1.nRow;
-    SCTAB nOldTab1 = rRef.Ref1.nTab;
-    SCCOL nOldCol2 = rRef.Ref2.nCol;
-    SCROW nOldRow2 = rRef.Ref2.nRow;
-    SCTAB nOldTab2 = rRef.Ref2.nTab;
-
-    bool bCut1, bCut2;
-    if ( nDx )
-    {
-        bCut1 = bCut2 = false;
-        if( bAbsolute || rRef.Ref1.IsColRel() )
-        {
-            SCCOL nRefCol1 = rRefRange.aStart.Col();
-            if( bWrap )
-            {
-                lcl_MoveItWrap(nRefCol1, nDx, MAXCOL);
-            }
-            else
-            {
-                bCut1 = lcl_MoveItCut(nRefCol1, nDx, MAXCOL);
-            }
-            rRefRange.aStart.SetCol(nRefCol1);
-        }
-        if( bAbsolute || rRef.Ref2.IsColRel() )
-        {
-            SCCOL nRefCol2 = rRefRange.aEnd.Col();
-            if( bWrap )
-                lcl_MoveItWrap(nRefCol2, nDx, MAXCOL);
-            else
-                bCut2 = lcl_MoveItCut(nRefCol2, nDx, MAXCOL);
-            rRefRange.aEnd.SetCol(nRefCol2);
-        }
-        if ( bCut1 || bCut2 )
-            eRet = UR_UPDATED;
-        if ( bCut1 && bCut2 )
-        {
-            rRef.Ref1.SetColDeleted( true );
-            rRef.Ref2.SetColDeleted( true );
-        }
-    }
-    if ( nDy )
-    {
-        bCut1 = bCut2 = false;
-        if( bAbsolute || rRef.Ref1.IsRowRel() )
-        {
-            SCROW nRefRow1 = rRefRange.aStart.Row();
-            if( bWrap )
-                lcl_MoveItWrap(nRefRow1, nDy, MAXROW);
-            else
-                bCut1 = lcl_MoveItCut(nRefRow1, nDy, MAXROW);
-            rRefRange.aStart.SetRow(nRefRow1);
-        }
-        if( bAbsolute || rRef.Ref2.IsRowRel() )
-        {
-            SCROW nRefRow2 = rRefRange.aEnd.Row();
-            if( bWrap )
-                lcl_MoveItWrap(nRefRow2, nDy, MAXROW);
-            else
-                bCut2 = lcl_MoveItCut(nRefRow2, nDy, MAXROW);
-            rRefRange.aEnd.SetRow(nRefRow2);
-        }
-        if ( bCut1 || bCut2 )
-            eRet = UR_UPDATED;
-        if ( bCut1 && bCut2 )
-        {
-            rRef.Ref1.SetRowDeleted( true );
-            rRef.Ref2.SetRowDeleted( true );
-        }
-    }
-    if ( nDz )
-    {
-        bCut1 = bCut2 = false;
-        SCsTAB nMaxTab = (SCsTAB) pDoc->GetTableCount() - 1;
-        if( bAbsolute || rRef.Ref1.IsTabRel() )
-        {
-            SCTAB nRefTab1 = rRefRange.aStart.Tab();
-            if( bWrap )
-                lcl_MoveItWrap(nRefTab1, nDz, static_cast<SCTAB>(nMaxTab));
-            else
-                bCut1 = lcl_MoveItCut(nRefTab1, nDz, static_cast<SCTAB>(nMaxTab));
-            rRefRange.aStart.SetTab(nRefTab1);
-            rRef.Ref1.SetFlag3D(rPos.Tab() != rRefRange.aStart.Tab());
-        }
-        if( bAbsolute || rRef.Ref2.IsTabRel() )
-        {
-            SCTAB nRefTab2 = rRefRange.aEnd.Tab();
-            if( bWrap )
-                lcl_MoveItWrap(nRefTab2, nDz, static_cast<SCTAB>(nMaxTab));
-            else
-                bCut2 = lcl_MoveItCut(nRefTab2, nDz, static_cast<SCTAB>(nMaxTab));
-            rRefRange.aEnd.SetTab(nRefTab2);
-            rRef.Ref2.SetFlag3D(rPos.Tab() != rRefRange.aEnd.Tab());
-        }
-        if ( bCut1 || bCut2 )
-            eRet = UR_UPDATED;
-        if ( bCut1 && bCut2 )
-        {
-            rRef.Ref1.SetTabDeleted( true );
-            rRef.Ref2.SetTabDeleted( true );
-        }
-    }
-
-    if ( eRet == UR_NOTHING )
-    {
-        if (nOldCol1 != rRef.Ref1.nCol
-         || nOldRow1 != rRef.Ref1.nRow
-         || nOldTab1 != rRef.Ref1.nTab
-         || nOldCol2 != rRef.Ref2.nCol
-         || nOldRow2 != rRef.Ref2.nRow
-         || nOldTab2 != rRef.Ref2.nTab
-            )
-            eRet = UR_UPDATED;
-    }
-    if ( bWrap && eRet != UR_NOTHING )
-    {
-        rRef.PutInOrder();
-        rRefRange.PutInOrder();
-    }
-    return eRet;
-}
-
 void ScRefUpdate::MoveRelWrap( ScDocument* pDoc, const ScAddress& rPos,
                                SCCOL nMaxCol, SCROW nMaxRow, ScComplexRefData& rRef )
 {