GNOME Bugzilla – Bug 67760
Lotus 123 loading problem
Last modified: 2004-12-22 21:47:04 UTC
I had previously thought (see list) that this problem affected Excel 95/97 files too, but I can't reproduce that today. Maybe I need to label my test data more clearly :( The attached file euro-123.wk1 is a Lotus 123 file created from Microsoft software, when loaded there are two serious cosmetic problems which may be related. If they're not related fix one and I'll file another bug for the other one :) First if you look at B1 the cell should have the phrase "Euro Currency Price List", but initially it doesn't span into adjacent empty cells so it only says "Euro C" or similar (depending on local fonts). Once the user tweaks the width of ANY column the display updates to show that the cell does span. Lower down, in e.g. E27 it should read "LUF" because the formula in that cell is =E$21 and cell E21 has "LUF" in it. Instead the cell is blank, until the user presses F9 or causes a recalculation of the cell. (Thinking out load: Maybe 123 does not store precalculated cell values, and therefore the 123 plug-in needs to ask Gnumeric to do one full recalculation after it finishes loading, maybe that fixes the spans too?)
Created attachment 6323 [details] euro-123.wk1
Here's an interesting fact: The first problem goes away if the plug-in sets a default column width using the appropriate Gnumeric function such as: sheet_col_set_default_size_pts (sheet, 40.0); So a possible workaround is to ask all file plug-ins to call this function, even if they've no idea what size the columns should be. Alternatively Gnumeric could call the function itself when a new sheet is created by a plug-in.
Yes, this is a known problem and eerily enough, that is not far from the correct solution. I'll get to it shortly.
Fixed in CVS. Patch will be in 1.0.2