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. _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
