GNOME Bugzilla – Bug 381732
[win 32] pasting large selection from XCEL2002 to gnumeric --> pasted area inconsistent
Last modified: 2009-10-16 17:39:43 UTC
Please describe the problem: i am cutting large areas of data from excel files to gnumeric files. the selections are 9 columns x aproximately 18000 rows. Upon pasting into the gnumneric file, there are 2 blank lines added where I pasted the data, like this: <BLANK LINE> <BLANK LINE> <DATA> Steps to reproduce: 1. cut and paste a large ammount of data Actual results: 2 extra lines are pasted Expected results: just my data would be pasted Does this happen every time? for the few files I have done so far, yes Other information:
just figured something out. what I am doing is cutting all but the first two lines in the excel files. the paste area in gnumeric is equal to the size of the entire excel file. so, if I cut all but the first 3 lines there will be 3 blank lines pasted before my selection, etc...
i should note that it a tab delimited file
Could you please test whether this happens for small files too? This kind of behaviour really shouldn't depend on data amounts.
you are right, looks like it is any excel file. what I did: open excel v.2002 (10.2614.2625) input something in cell C22 highlight only C22 cut paste into gnumeric cell A1 RESULT: cell is pasted into position C22 of the gnueric file and range A1:C22 is highlighted EXPECTED: paste into A1
Since this has to do with copying from Excel v. 2002 it is clearly an MS Windows specific issue.
just noticed this still seems to happen with the latest and greatest excel version 2008, I believe it is.
I can still reproduce the issue in comment 4 with gnumeric-1.9.4-20090205-debug.exe and Excel 2003. It looks like the Biff8 target is being used and the Excel importer interprets the cell as a range somehow. Let me know if I can help debug this further. 291 in gui-clipboard.c (gdb) p r.start.col $5 = 0 (gdb) p r.end.col $6 = 2 (gdb) p r.start.row $7 = 0 (gdb) p r.end.row $8 = 21 (gdb) bt
+ Trace 212311
It looks like table_cellregion_read assumes that the data being read starts at A1. It would be helpful if you had a way of dumping the data. Try something like x /3584x 0x1f17578 (where 3584 is "length" and 0x1f17578 is buffer.)
Pasted data here (attached to wrong bug): http://bugzilla.gnome.org/attachment.cgi?id=128112&action=view
*** Bug 335348 has been marked as a duplicate of this bug. ***
Note that this may be the same bug as bug #388531.
It is the same. Fixed.