Sorting column of formulae destroys them.

[Peap <peahippo hotmail com>]

I'm using Gnumeric 1.6.3 in WinXPSP2.  I have a spreadsheet for simple
calculations.  Within, A1-A20 is filled with Number values like so:

0.725
2.075
3.275
4.325
5.225
...

A22-A401 is filled with permutations like so:

=A1+A2
=A1+A3
=A1+A4
...
=A20+A17
=A20+A18
=A20+A19

When I sort A22-A401, the vast majority of the cells display "#REF!". 
Within the cells, a seemingly random selection of first and second cell refs
became "#REF!".

About 5% of the sorted cells end up with values.

A few of them have wacky cell refs, like "=A234+A47".

When you try to Undo the sort, another set of "#REF!" appear in the column.

What on earth is going on?  Sorting is a basic function.
-- 
View this message in context: 
http://www.nabble.com/Sorting-column-of-formulae-destroys-them.-tp17311492p17311492.html
Sent from the GnuMeric mailing list archive at Nabble.com.