fix fdo#79441 again and keep references to other sheets during sort

... also if other references are not updated. References to other sheets
are never to be treated as relative during sort, they are always
absolute, even if they have relative row/column part references.

Broken again during the big sort mess. Even if there was a unit test,
which didn't help as it got disabled / adapted to the change..

Change-Id: Ic0e61c5e1cb0728e20725c29e450ab0eb55c3305
(cherry picked from commit f0e7364603c9566bc158303c515c3274ccba62ca)
check that the fdo#79441 case works in both update references modes

Change-Id: I4aa997847661021af27f27e8763a89a61f185f1f
(cherry picked from commit fb2c3fec1b98b54f929d0cec64789b79306e03b1)
check internal and external sheet references in both modes

Actually fdo#77018 is not "fixed", but is a case for
UpdateReferenceOnSort=true now.

Change-Id: Ibc92c0a95749089c79787e38898bfe77fe30fb0f
(cherry picked from commit 46e6f78f2b7595e7009975a2365395a74ca2df83)