Having selected an area of data (say A4:E20), where column E contains a formula
(in this case, A[n] (Date) plus seven, so "the week from the date in column A"),
sorting mixes up the formulas in column E. That means, that in the "new" (after
sorting) row 15 I find in column E the formula "$A[row<>15]+7". The result is
correct for the other row, but that does not help much...

So, if I sort the named area of data by column D, for example, the order of all
"fixed" data (like text, dates and numbers) rows is correct; yet the references
in the E-column containing the formula are a haddock... - Providing obviously
false results.

I have that on my office PC with Win XP and OOo 3.1. It is reproducable, but I
had not had the time yet to see whether I can find a "system in irregularity"
here. - Here at home, I run Ubuntu Linux with OOo 2.4 (shame on me, I know), and
the same procedure brings the expected result.

I made this a "P1"-priority, because this one has hit me unprepared in an
important presentation and I was in no way aware of it then. - I want to save
others from this experience...!

I have searched the archives but found no similar reports.

The .ods file can be provided if that helps; I'd like to alter some of the
"fixed" data in it first, because it is "life company business". - I will
continue examination on my side; unfortunally, at the moment, I don't have too
much time left do do that.

Thanks in advance, everybody!