GNOME Bugzilla – Bug 585178
Style trouble with operator.xls
Last modified: 2009-06-09 13:10:18 UTC
Steps to reproduce: - ssconvert gnumeric/samples/excel/operator.xls /tmp/foo.xls Console output (truncated): WARNING **: Can't find style 0xa060578 for cell GT!? WARNING **: Can't find style 0xa0606e8 for cell GT!D3 WARNING **: Can't find style 0xa0607a0 for cell GT!E3 WARNING **: Can't find style 0xa060858 for cell GT!F3 WARNING **: Can't find style 0xa060910 for cell GT!G3 WARNING **: Can't find style 0xa0609c8 for cell GT!H3 Backtrace:
+ Trace 215925
Adding GNM_DEBUG=style-optimize:style-optimize-verify prduces: [...] Optimizing GT Turning I17:P32 (8x16) from a matrix into a row Turning I33:P48 (8x16) from a matrix into a row Turning A49:H64 (8x16) from a matrix into a col Turning I49:P64 (8x16) from a matrix into a simple Turning Q49:X64 (8x16) from a matrix into a col Turning I65:P80 (8x16) from a matrix into a row Turning A4097:IV8192 (256x4096) from a ptr-matrix into a col Turning A8193:IV12288 (256x4096) from a ptr-matrix into a col Turning A12289:IV16384 (256x4096) from a ptr-matrix into a col Turning A16385:IV20480 (256x4096) from a ptr-matrix into a col Turning A20481:IV24576 (256x4096) from a ptr-matrix into a col Turning A24577:IV28672 (256x4096) from a ptr-matrix into a col Turning A28673:IV32768 (256x4096) from a ptr-matrix into a col Turning A32769:IV36864 (256x4096) from a ptr-matrix into a col Turning A36865:IV40960 (256x4096) from a ptr-matrix into a col Turning A40961:IV45056 (256x4096) from a ptr-matrix into a col Turning A45057:IV49152 (256x4096) from a ptr-matrix into a col Turning A49153:IV53248 (256x4096) from a ptr-matrix into a col Turning A53249:IV57344 (256x4096) from a ptr-matrix into a col Turning A57345:IV61440 (256x4096) from a ptr-matrix into a col Turning A61441:IV65536 (256x4096) from a ptr-matrix into a col ** (/home/welinder/gnome-src/gnumeric/src/.libs/lt-gnumeric:21288): WARNING **: Style optimizer position conflict at J25!
The style optimizer is not at fault -- it just makes things visible. There is one problem in sheet_style_find: gnm_style_link_sheet can change the style (in the gnm_style_equal sense). I think we need an extra check to avoid overwriting an element in the hash: res = g_hash_table_lookup (sheet->style_data->style_hash, s); if (res != NULL) { gnm_style_link (res); gnm_style_unlink (s); return res; } Adding this will ensure that only new styles are added to the hash. Fixing this and also turning the style optimizer off, we then get the warnings from the initial reports: WARNING **: Can't find style 0xa060578 for cell GT!C3 (except that a fix in plugins/excel now makes it print the actual cell address even when there is not cell).
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.