Created attachment 212305 [details]
spreadsheet demonstrating strange scatter plot problem

Sometimes when plotting a range of data series as a scatter plot the transformation to rows is unsucessfull

i.e in an XY plot of 

dataX1_1 dataX1_2 dataX1_3 dataX1_4
dataY1_1 dataY1_2 dataY1_3 dataY1_4
dataX2_1 dataX2_2 dataX2_3 dataX2_4
dataY2_1 dataY2_2 dataY2_3 dataY2_4

Gnumeric normally interprets as a column plot automatically, this can be changed to row plot, sometimes this is ok, but sometimes on this change the data is lost. Please see the attached datafile for an example with two data series with the same data values, the first data block is ok the second fails on the conversion to rows.

system info: Ubuntu lucid, Linux MEDEA 2.6.32-33-generic #72-Ubuntu SMP Fri Jul 29 21:07:13 UTC 2011 x86_64 GNU/Linux