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 699045 - Sheet style performance problem for large sheet
Sheet style performance problem for large sheet
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2013-04-27 15:44 UTC by Curt Wiedeman
Modified: 2013-08-26 20:01 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Curt Wiedeman 2013-04-27 15:44:36 UTC
downloaded ubuntu upgrade to version 13.04 and spreadsheet locks up when trying to save and close out working file
Comment 1 Andreas J. Guelzow 2013-04-27 16:22:53 UTC
Hi could you give us a few more details: 
What type of file?
Did you already give the file a name?
Are you just saving the file or just quitting, or do you have a modified file and you are quitting?
In the latter case do you see the save-confirmation dialog?
Comment 2 Andreas J. Guelzow 2013-04-28 00:53:00 UTC
Additional information provided by Curt:

file is basic gnumeric spreadsheet I have been using for several years with name after modifying data I either quit or save and quit file turns gray and sits for 30 seconds to a minute then program shuts down re-open program to check that changes have been made generally the changes are recorded but on one or two occasions the changes were not accepted yes I see the save-confirm dialog hit saves and appears to lock up.

Thank you.
Comment 3 Andreas J. Guelzow 2013-04-28 14:45:19 UTC
Curt,

would you be able to run Gnumeric from a terminal window (open a terminal and execute 'gnumeric')? If you can do you see any waring messages in the terminal?
Comment 4 Andreas J. Guelzow 2013-04-28 19:27:25 UTC
Response from Curt:

here is what I got:
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Comment 5 Morten Welinder 2013-08-26 12:47:10 UTC
That would suggest that something is taking a very long time during
shutdown.

Any chance of getting a copy of the spreadsheet in question to see if that
happens to us?  (As attachment here if you don't care who sees it, as
private email if you want us to treat it as confidential.)
Comment 6 Morten Welinder 2013-08-26 17:06:18 UTC
This is a save-as-gnumeric problem: "exit" takes little time, "save-as" takes
a long time.




  • #0 ??
    from /usr/lib64/libglib-2.0.so.0
  • #1 merge_vertical_stripes
    at sheet-style.c line 2671
  • #2 internal_style_list
    at sheet-style.c line 2840
  • #3 sheet_style_get_range
    at sheet-style.c line 2878
  • #4 xml_write_styles
    at xml-sax-write.c line 707
  • #5 xml_write_sheet
    at xml-sax-write.c line 1309
  • #6 xml_write_sheets
    at xml-sax-write.c line 1331
  • #7 gnm_xml_file_save_full
    at xml-sax-write.c line 1457
  • #8 wbv_save_to_output
    at workbook-view.c line 1055

Comment 7 Morten Welinder 2013-08-26 17:19:43 UTC
A workaround is to resize the sheet to something smaller:

1. Open sheet
2. Right-click on a sheet tab and select Resize
3. Shrink to 256 columns and 65536 rows.
[That'll take a few minutes for the same reason as the save]
4. Save.
[A few seconds]

After that you should no longer be meaningfully affected by this bug.
Comment 8 Morten Welinder 2013-08-26 20:01:42 UTC
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.