GNOME Bugzilla – Bug 96387
Failure to import protected worksheets
Last modified: 2009-08-15 18:40:50 UTC
I need to work with protected worksheets without knowing the password. This wroks fine with EXCEL but gnumeric refuses to import them without entering the password. What should happen is that uif I di not know the password I can load the worksheet but only edit the unprotected cells. I imagine that this would be very useful for lots of people as many forms are distributed in this form. I can send you an example if you like. I'm using version 1.1.9
Please try "VelvetSweatshop".
The spreadsheet now loads with the following messages FIXME: rich string support unimplemented:discarding 1 runs sheet password '980f' sheet password '980f' sheet password '980f' sheet password '980f' sheet password '980f' sheet password '83f3' sheet password '83f3' some of the boxes allow entries but others cause crashes with errors like ** (gnumeric:30466): WARNING **: do_gnm_expr_unref error. ** (gnumeric:30466): WARNING **: do_gnm_expr_unref error. ** (gnumeric:30466): WARNING **: do_gnm_expr_unref error. ** (gnumeric:30466): WARNING **: do_gnm_expr_unref error. Segmentation fault Would you like a copy of the spreadshhet?
Yes, please. Either attach to this bug report (if it is not sensitive) or email to terra@diku.dk and jody@gnome.org thanks.
This now load smoothly without your being required to enter a password. This sheet had a few quirks that I had not seen before, thanks they're patched now. There is still 1 irregularity that I'll try to patch before 1.1.10 later today. However, I can not replicate the gnm_expr warnings or the crash. Can you give me an example of some exact steps from startup to crash that reproduce it ? It is possible that it has been fixed in cvs or my tree already. There was a fair amount of breakege in 1.1.9.
On the first first page there are start and end dates. If you try to enter months and years, for example "2002", sometimes it rejects it saying must enter a 4 digit number! Similary for the month. if you enter "=2000" sometimes it crashes. It does not appear to do the same thing each time, but if you try and enter the start and end dates it always crashes before you manage to. Jim
Ah ok. crash fixed in 1.1 and back ported to 1.0 Thanks
I've just installed 1.1.10 from the tarball. (I failed from CVS earlier) The worksheet is much better now and doesn't crash. It is still broken however. Main of the entries have pull down lists so that you can select one item. I'm not sure if this is a bug or an unimplimented feature but none of these work. For example the first entry box "Name of department / Group:" has a downward pointing arrow on the right hand side that when clicked gives a scrolling list of the possible entries. Thanks
Too much in one bug. If more needs to be done, please make it a new bug. I think we're aware that drop-downs aren't right.