diff options
author | Eike Rathke <erack@redhat.com> | 2022-09-09 12:54:14 +0200 |
---|---|---|
committer | Eike Rathke <erack@redhat.com> | 2022-09-09 15:53:46 +0200 |
commit | 9a6c350d8dff4b5228ec7451006115e387f819f2 (patch) | |
tree | d7e0b04a0150482a0ddf1bd4e4ca6147a8bf9909 | |
parent | d26faae8359ccf2e3475ef9e319c97485b76d08d (diff) |
Resolves: tdf#150312 Move base-cell-address to a valid sheet upon deletion
... and adjust references accordingly. For
ScTokenArray::AdjustReferenceOnDeletedTab() that now also moves
the base of the first deleted sheet not only after, which was a
one-off before.
Change-Id: I4c19e8b8a7318ba03b6a7d0b2dfaae5d05a51a29
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/139720
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Jenkins
-rw-r--r-- | sc/inc/rangeutl.hxx | 9 | ||||
-rw-r--r-- | sc/source/core/tool/rangenam.cxx | 4 | ||||
-rw-r--r-- | sc/source/core/tool/rangeutl.cxx | 2 | ||||
-rw-r--r-- | sc/source/core/tool/token.cxx | 4 |
4 files changed, 14 insertions, 5 deletions
diff --git a/sc/inc/rangeutl.hxx b/sc/inc/rangeutl.hxx index 33f531444280..4524226e43ca 100644 --- a/sc/inc/rangeutl.hxx +++ b/sc/inc/rangeutl.hxx @@ -276,6 +276,15 @@ struct SC_DLLPUBLIC ScRangeUpdater ScRangeUpdater() = delete; static void UpdateInsertTab(ScAddress& rAddr, const sc::RefUpdateInsertTabContext& rCxt); + + /** This is for the base-cell-address of a defined name or conditional + format, not for references. A sheet position on or after the start of + the deleted range is moved towards the beginning by the amount of + deleted sheets, within the deleted range to the front of that or set to + 0 (as there is always at least one sheet in a document) if the position + would result in a negative value, e.g. if position was 0 and (only) + sheet 0 is deleted it would had become -1. + */ static void UpdateDeleteTab(ScAddress& rAddr, const sc::RefUpdateDeleteTabContext& rCxt); }; diff --git a/sc/source/core/tool/rangenam.cxx b/sc/source/core/tool/rangenam.cxx index 66cdf2b74c9e..b5578ca26590 100644 --- a/sc/source/core/tool/rangenam.cxx +++ b/sc/source/core/tool/rangenam.cxx @@ -27,6 +27,7 @@ #include <token.hxx> #include <tokenarray.hxx> #include <rangenam.hxx> +#include <rangeutl.hxx> #include <global.hxx> #include <compiler.hxx> #include <refupdat.hxx> @@ -407,8 +408,7 @@ void ScRangeData::UpdateDeleteTab( sc::RefUpdateDeleteTabContext& rCxt, SCTAB nL if (aRes.mbReferenceModified) rCxt.maUpdatedNames.setUpdatedName(nLocalTab, nIndex); - if (rCxt.mnDeletePos <= aPos.Tab()) - aPos.IncTab(-rCxt.mnSheets); + ScRangeUpdater::UpdateDeleteTab( aPos, rCxt); } void ScRangeData::UpdateMoveTab( sc::RefUpdateMoveTabContext& rCxt, SCTAB nLocalTab ) diff --git a/sc/source/core/tool/rangeutl.cxx b/sc/source/core/tool/rangeutl.cxx index c5901c834b40..6eb1cf52ff48 100644 --- a/sc/source/core/tool/rangeutl.cxx +++ b/sc/source/core/tool/rangeutl.cxx @@ -1061,7 +1061,7 @@ void ScRangeUpdater::UpdateDeleteTab(ScAddress& rAddr, const sc::RefUpdateDelete { if (rCxt.mnDeletePos <= rAddr.Tab()) { - rAddr.IncTab(-rCxt.mnSheets); + rAddr.SetTab( std::max<SCTAB>(0, rAddr.Tab() - rCxt.mnSheets)); } } diff --git a/sc/source/core/tool/token.cxx b/sc/source/core/tool/token.cxx index 1ad3df0889ef..4315f017e67c 100644 --- a/sc/source/core/tool/token.cxx +++ b/sc/source/core/tool/token.cxx @@ -34,6 +34,7 @@ #include <formula/opcode.hxx> #include <jumpmatrix.hxx> #include <rangeseq.hxx> +#include <rangeutl.hxx> #include <externalrefmgr.hxx> #include <document.hxx> #include <refupdatecontext.hxx> @@ -4234,8 +4235,7 @@ sc::RefUpdateResult ScTokenArray::AdjustReferenceOnDeletedTab( const sc::RefUpda { sc::RefUpdateResult aRes; ScAddress aNewPos = rOldPos; - if (rCxt.mnDeletePos < rOldPos.Tab()) - aNewPos.IncTab(-1*rCxt.mnSheets); + ScRangeUpdater::UpdateDeleteTab( aNewPos, rCxt); TokenPointers aPtrs( pCode.get(), nLen, pRPN, nRPN); for (size_t j=0; j<2; ++j) |