Sorting column of formulae destroys them.

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:


A22-A401 is filled with permutations like so:


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:
Sent from the GnuMeric mailing list archive at

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]