Issue 101845

In the ods attached there are shown 2 different behaviours:

1 - the normal expected result is shown in example 1. If you sort the range
Timp.A1:G30 by column G for example, everything is ok, the formulas in column F
are kept intact.

2 - in example 2, identical to example 1, on column G we make a reference to
$Parametri.$B$3 instead of $N$2 (in the same sheet). If you sort now the same
range Timp.A1:G30 by column G the formulas in column F are mixed up after sorting...
You can check the same behaviour in the 3rd example, by sorting range
Salarii.A2:AD29, by column AD. You will have unexpected results on columns: X,
U, T, P, o, N, L, k, j, f, i. All these columns have in comon the reference to
another sheet ($Parametri.$d$24 for example)

So, the conclusion is that the sort doesn't modify corectly the references in
formulas containing also refrences to other sheets, but work well for refrences
in the same sheet.

This was tested with the release 3.1, and I haven't seen it on previous releases.

Please help!