4 files changed, 13 insertions, 2 deletions
diff --git a/sc/inc/column.hxx b/sc/inc/column.hxx
index aa1f4c1617d5..ba618d647d04 100644
--- a/sc/inc/column.hxx
+++ b/sc/inc/column.hxx
@@ -293,7 +293,8 @@ public:
 
     void CopyToColumn(
         sc::CopyToDocContext& rCxt, SCROW nRow1, SCROW nRow2, InsertDeleteFlags nFlags, bool bMarked,
-        ScColumn& rColumn, const ScMarkData* pMarkData = nullptr, bool bAsLink = false) const;
+        ScColumn& rColumn, const ScMarkData* pMarkData = nullptr, bool bAsLink = false,
+        bool bGlobalNamesToLocal = false ) const;
 
     void UndoToColumn(
         sc::CopyToDocContext& rCxt, SCROW nRow1, SCROW nRow2, InsertDeleteFlags nFlags, bool bMarked,
diff --git a/sc/inc/global.hxx b/sc/inc/global.hxx
index 14f4b0871d47..d06d58ba1873 100644
--- a/sc/inc/global.hxx
+++ b/sc/inc/global.hxx
@@ -241,6 +241,10 @@ const int SC_CLONECELL_NOCAPTION        = 0x0004;
 /** If set, absolute refs will not transformed to external references */
 const int SC_CLONECELL_NOMAKEABS_EXTERNAL = 0x0008;
 
+/** If set, global named expressions will be converted to sheet-local named
+    expressions. */
+const int SC_CLONECELL_NAMES_TO_LOCAL   = 0x0010;
+
 #ifndef DELETEZ
 #define DELETEZ(pPtr) { delete pPtr; pPtr = 0; }
 #endif
diff --git a/sc/inc/table.hxx b/sc/inc/table.hxx
index 6fac2cf05171..a8b30635fb4d 100644
--- a/sc/inc/table.hxx
+++ b/sc/inc/table.hxx
@@ -445,7 +445,8 @@ public:
     void CopyToTable(
         sc::CopyToDocContext& rCxt, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2,
         InsertDeleteFlags nFlags, bool bMarked, ScTable* pDestTab,
-        const ScMarkData* pMarkData = nullptr, bool bAsLink = false, bool bColRowFlags = true );
+        const ScMarkData* pMarkData = nullptr, bool bAsLink = false, bool bColRowFlags = true,
+        bool bGlobalNamesToLocal = false );
 
     void UndoToTable(
         sc::CopyToDocContext& rCxt, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2,
diff --git a/sc/inc/tokenarray.hxx b/sc/inc/tokenarray.hxx
index 18fc6e59b73e..b2b4edd896b3 100644
--- a/sc/inc/tokenarray.hxx
+++ b/sc/inc/tokenarray.hxx
@@ -141,6 +141,11 @@ public:
      */
     void AdjustSheetLocalNameReferences( SCTAB nOldTab, SCTAB nNewTab );
 
+    /** Returns true if the sheet nTab is referenced in code. Relative sheet
+        references are evaluated using nPosTab.
+     */
+    bool ReferencesSheet( SCTAB nTab, SCTAB nPosTab ) const;
+
     /**
      * Adjust all references in response to shifting of cells during cell
      * insertion and deletion.