After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 580930 - GTK+ 2.16.x ABI break for spinbuttons
GTK+ 2.16.x ABI break for spinbuttons
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export Text
1.8.x
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
: 581014 581493 593703 594186 596868 608638 627989 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2009-04-30 19:53 UTC by Luke Hutchison
Modified: 2010-08-26 00:09 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
The dataset that gets truncated when pasted into Gnumeric. (4.09 KB, text/plain)
2009-04-30 20:04 UTC, Luke Hutchison
Details
Script to fixup glade files (958 bytes, text/plain)
2009-05-01 00:28 UTC, Morten Welinder
Details

Description Luke Hutchison 2009-04-30 19:53:03 UTC
Please describe the problem:
When pasting CSV data into Gnumeric, sometimes it truncates the rows.

Steps to reproduce:
1. Load the attached file into Gedit, do Ctrl-A Ctrl-C to copy.
2. Open Gnumeric, press Ctrl-V to paste.
3. Do Alt-F Alt-F Alt-I for "Forward -> Forward -> Finish"
4. Only the first 490 out of 500 rows are pasted.

You will notice that in the first import screen of step 3 above, in the "From line / To line" settings, "To line" is set at 490, and cannot be increased to 500.

Additionally, if you go back to Gedit and copy only the last 10 lines of the file, and try to paste them at row 491 of the spreadsheet, the "To line" setting cannot be increased beyond 1, so you can only paste one more line at a time to the end of the first 490 lines.

Curiously, for some other datasets (even ones with more lines), none of the above is a problem...


Actual results:


Expected results:


Does this happen every time?


Other information:
Comment 1 Luke Hutchison 2009-04-30 20:04:57 UTC
Created attachment 133688 [details]
The dataset that gets truncated when pasted into Gnumeric.
Comment 2 Morten Welinder 2009-04-30 20:11:00 UTC
I cannot reproduce this with either 1.9.6 or 1.8.2.  The bahaviour with
490 strongly suggests that Gnumeric only gets the first 490 lines in your
case.  Could you please try another editor?  Or the terminal window.
Comment 3 Andreas J. Guelzow 2009-04-30 20:20:04 UTC
There is some discussion of this at:

https://bugs.launchpad.net/ubuntu/+source/gnumeric/+bug/264167
Comment 4 Andreas J. Guelzow 2009-04-30 20:23:30 UTC
See also https://bugs.launchpad.net/ubuntu/+source/gnumeric/+bug/369650

in brief this is the result of changes to gtk 2.14.
Comment 5 Luke Hutchison 2009-04-30 20:44:31 UTC
Yes, that looks like the problem.
Comment 6 Morten Welinder 2009-04-30 23:12:03 UTC
I have pushed workarounds to this problem
http://git.gnome.org/cgit/gnumeric/log/?h=origin/gnumeric-1-8
Comment 7 Morten Welinder 2009-05-01 00:28:19 UTC
Created attachment 133712 [details]
Script to fixup glade files

The script can, I hope, fixup glade files.  It zeros the last adjustment
number for every GtkSpinbutton.
Comment 8 Andreas J. Guelzow 2009-05-01 06:54:49 UTC
This is now fixed in both branches (HEAD and 1.8).
Comment 9 Morten Welinder 2009-05-01 15:21:21 UTC
*** Bug 581014 has been marked as a duplicate of this bug. ***
Comment 10 Morten Welinder 2009-05-05 18:02:07 UTC
*** Bug 581493 has been marked as a duplicate of this bug. ***
Comment 11 Andreas J. Guelzow 2009-08-31 22:37:59 UTC
*** Bug 593703 has been marked as a duplicate of this bug. ***
Comment 12 Morten Welinder 2009-09-04 23:50:11 UTC
*** Bug 594186 has been marked as a duplicate of this bug. ***
Comment 13 Andreas J. Guelzow 2009-09-30 18:32:22 UTC
*** Bug 596868 has been marked as a duplicate of this bug. ***
Comment 14 Luke Hutchison 2009-10-20 17:41:25 UTC
This is still an issue with Fedora 12 beta.  It has survived three Fedora releases (along with bug 566652).  Does anyone have sway with RedHat that can help get the upstream fixes pushed into F12 in time for release?  Thanks!

See: https://bugzilla.redhat.com/show_bug.cgi?id=505001
Comment 15 Andreas J. Guelzow 2009-10-20 17:48:33 UTC
Well, I assume that GTK wanted to break Gnome productivity apps for years to come, so RedHat just follows their intent.
Comment 16 Morten Welinder 2009-10-20 17:50:45 UTC
They need to pick patches from
http://git.gnome.org/cgit/gnumeric/log/?h=gnumeric-1-8
Comment 17 Luke Hutchison 2009-10-20 17:59:50 UTC
Yes, but who inside RedHat is likely to be responsive to a request to pick those patches (and/or move to Gnumeric-1.9.x) before Fedora 12 is released?  I reported the RH bug months ago and there's only one guy CC'd.  I don't want to be the annoying guy with the pet bug -- but this one makes Gnumeric pretty annoying to use on Fedora systems.  Thanks.
Comment 18 Morten Welinder 2009-10-20 18:10:16 UTC
You could take the stand that it's a GTK+ problem and try to bring it to
the attention of mclasen@redhat.com -- if nothing else, he might know who
to point at.
Comment 19 Luke Hutchison 2009-10-20 18:29:22 UTC
Emailed him, thanks for the pointer.
Comment 20 Luke Hutchison 2009-10-20 22:55:28 UTC
Got the following from Robert Scheck, FYI.  

--
thank you for pointing out that. I've applied the fixes from gnumeric 1.8
stable branch to F-11, F-12 and devel. As F-10 is shipping gnumeric 1.8.2
right now, I'm not sure whether the issue really applies there as well. And
I am a bit unsure whether I should update gnumeric 1.5 months before EOL to
1.8.4 or whether this maybe breaks more than it helps. Let's see.

Note, I'm not the gnumeric package maintainer, just a provenpackager, who
updated gnumeric some time ago to 1.8.4, because the package maintainer did
not do it. So this is just another provenpackager activity.
--

Question: is Gnumeric 1.9.14 / HEAD stable enough for suggesting it be shipped with Fedora 12?  (Rephrased: would it be better including 1.9.x in Fedora than the broken 1.8.4 that they have been shipping for almost three releases?)
Comment 21 Andreas J. Guelzow 2010-02-01 06:59:49 UTC
*** Bug 608638 has been marked as a duplicate of this bug. ***
Comment 22 Andreas J. Guelzow 2010-08-26 00:09:08 UTC
*** Bug 627989 has been marked as a duplicate of this bug. ***