various bugs

[Padraig Brady <padraig antefacto com>]

OK all this relates to 0.67, and I can't for the life of me
get 1.01 installed (RPM dependency problems), anyway...

excel supports the firmula SUM(M4:M5:M6:M7:M8), but gnumeric gives 
"unknown formula"
I know it's silly but perhaps gnumeric could auto convert on import
from silly constructs like this?

saving to readonly directory => get error dialog with no message

left click to select a cell, then right click another cell. You get the
context menu for the origonally selected cell. Very unintuitive/dangerous.

Gnumeric didn't support the (custom) excel value format below correctly.
ValueType="40" ValueFormat=""IR£#,##0.00"
It just displayed IR£#,##0.00
The &quot seems out of place, and when I removed it everything worked fine.
(wow xml format files are seriously useful!!)
I opened an excel xls and saved as .gnumeric, so maybe the bug is in the
save as .gnumeric? This also happens when pasting from xls file to a 
gnumeric file
Note also when viewing this custom format, there seemed to be a string
termination problem as there were arbitrary characters displayed after
the actual custom format string in the text box (Maybe this is a quote 
termination problem?)
Anyway opened xls again, and before save the format was "IR£"#,##0.00
So when outputing to xml the second " is lost it seems.
On a related note if you type a negative number (not positive) prepended 
with a £
in a cell with format of £#,##0.00 or £0.00 (these are all I tested) 
then the value is modified!!
I.E. £-32.50 is modified to £-31.50 and £-32.09 to £31.91, WTF?? Note I 
know the £ is
redundant but gnumeric inserts it by default in the editbox (not in the 
xml file).
More custom format weirdness! gnumeric is starting to show the custom 
formats
in the cell and/or the editbox instead of the value. The value is 
retained however and
shown in the summary bar corectly.

copy & paste key combinations of Ctrl+Ins & Shift+Ins don't work for cells
but do for "edit bar". Any reason?

Can't copy/paste string in editbox in custom format edit dialog.

password protected books not supported yet? Hadn't Caolan code for this?
can't save over existing xls even if you have saved over it already

excel cell comments are not supported?

When xls has cells that contain #REF! gnumeric just throws away the whole
formula and replaces with "unknown formula". It should at least convert 
to text,
but really should support bad references.

When saving to gnumeric format the following should
probably changed to gnumeric?
    <gmr:Item>
      <gmr:name>application</gmr:name>
      <gmr:val-string>Microsoft Excel</gmr:val-string>
    </gmr:Item>

When 1 cell is selected you shouldn't show the 
{Sum,Min,Max,Average,Count}=...
in the summary bar I think? On a related note it might be a good idea to
have an "autostats" submenu in a context menu for multiple selected cells,
which has entries for {Sum,Min,Max,Average,Count}=... automatically 
calculated?
Perhaps the button/menu on the summary bar could show the same info, i.e
func=value for selection, rather than just func?

also a crash report....cheers,

From: Padraig Brady <Padraig antefacto com>
To: submit bugs gnome org
X-Mailer: bug-buddy 2.0.6
Subject: gnumeric crash

Package: Gnumeric
Severity: normal
Version: 0.67
Synopsis: gnumeric crash
Bugzilla-Product: Gnumeric
Bugzilla-Component: Main System

Description:
clicked blank cell in workseet after opened solver and various other things.
I couldn't reproduce it though.
I also seen many of the following messages on the console:
Gtk-WARNING **: invalid cast from (NULL) pointer to `GnumericSheet'
** CRITICAL **: file sheet-control-gui.c: line 92 
(scg_redraw_cell_region): asse
rtion `GNUMERIC_IS_SHEET (gsheet)' failed.

Debugging Information:

(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...[New 
Thread 1024 (LWP 8309)]

0x4070e989 in __wait4 () from /lib/i686/libc.so.6
#0  0x4070e989 in __wait4 () from /lib/i686/libc.so.6
#1  0x4078a534 in __DTOR_END__ () from /lib/i686/libc.so.6
#2  0x4025be88 in gnome_segv_handle () from /usr/lib/libgnomeui.so.32
#3  <signal handler called>
#4  0x080d28e7 in sc_cursor_bound () at eval.c:41
#5  0x080d1fd7 in sc_redraw_headers () at eval.c:41
#6  0x080c0d81 in sheet_redraw_headers () at eval.c:41
#7  0x080bfb87 in sheet_selection_reset () at eval.c:41
#8  0x0809dc10 in item_edit_enable_highlight () at eval.c:41
#9  0x0809e0fa in item_edit_enable_highlight () at eval.c:41
#10 0x4021679c in gnome_canvas_item_marshal_signal_1 ()
   from /usr/lib/libgnomeui.so.32
#11 0x403d87ad in gtk_signal_real_emit () from /usr/lib/libgtk-1.2.so.0
#12 0x403d6525 in gtk_signal_emit () from /usr/lib/libgtk-1.2.so.0
#13 0x4021abd0 in emit_event () from /usr/lib/libgnomeui.so.32
#14 0x4021b24a in gnome_canvas_button () from /usr/lib/libgnomeui.so.32
#15 0x403a5aec in gtk_marshal_BOOL__POINTER () from /usr/lib/libgtk-1.2.so.0
#16 0x403d87ad in gtk_signal_real_emit () from /usr/lib/libgtk-1.2.so.0
#17 0x403d6525 in gtk_signal_emit () from /usr/lib/libgtk-1.2.so.0
#18 0x40410b89 in gtk_widget_event () from /usr/lib/libgtk-1.2.so.0
#19 0x403a5a45 in gtk_propagate_event () from /usr/lib/libgtk-1.2.so.0
#20 0x403a4a6f in gtk_main_do_event () from /usr/lib/libgtk-1.2.so.0
#21 0x40455d7f in gdk_event_dispatch () from /usr/lib/libgdk-1.2.so.0
#22 0x405ce773 in g_main_dispatch () from /usr/lib/libglib-1.2.so.0
#23 0x405ced39 in g_main_iterate () from /usr/lib/libglib-1.2.so.0
#24 0x405ceeec in g_main_run () from /usr/lib/libglib-1.2.so.0
#25 0x403a4333 in gtk_main () from /usr/lib/libgtk-1.2.so.0
#26 0x0809e5f1 in item_grid_get_type () at eval.c:41
#27 0x0809e655 in main () at eval.c:41
#28 0x40670627 in __libc_start_main (main=0x809e640 <main>, argc=2,
    ubp_av=0xbffffa64, init=0x8065bcc <_init>, fini=0x8139bc0 <_fini>,
    rtld_fini=0x4000dcd4 <_dl_fini>, stack_end=0xbffffa5c)
    at ../sysdeps/generic/libc-start.c:129
#0  0x4070e989 in __wait4 () from /lib/i686/libc.so.6
No locals.
#1  0x4078a534 in __DTOR_END__ () from /lib/i686/libc.so.6
No symbol table info available.
#2  0x4025be88 in gnome_segv_handle () from /usr/lib/libgnomeui.so.32
No symbol table info available.
#3  <signal handler called>
No locals.
#4  0x080d28e7 in sc_cursor_bound () at eval.c:41
        in eval.c
ap = (void **) 0x0
digval = 4294966784
digval = 4294966784
digval = 4294966784
digval = 4294966784
p = 0x8359338 "\002"
result = 0
result = 137728824
#5  0x080d1fd7 in sc_redraw_headers () at eval.c:41
41 
in eval.c
ap = (void **) 0x0
digval = 4294966784
digval = 4294966784
digval = 4294966784
digval = 4294966784
p = 0x8359338 "\002"
result = 0
result = 137728824
#6  0x080c0d81 in sheet_redraw_headers () at eval.c:41
41 
in eval.c
ap = (void **) 0x0
digval = 4294966784
digval = 4294966784
digval = 4294966784
digval = 4294966784
p = 0x8359338 "\002"
result = 0
result = 137728824
#7  0x080bfb87 in sheet_selection_reset () at eval.c:41
41 
in eval.c
ap = (void **) 0x82f95d8
digval = 4294966784
digval = 4294966784
digval = 4294966784
digval = 4294966784
p = 0x8302680 "8\2235\b"
result = 137336280
result = 137373312