GNOME Bugzilla – Bug 170465
Names like K3P lexed incorrectly
Last modified: 2005-03-16 16:22:59 UTC
Please describe the problem: I open a large (20+ megs), complex, excel spreadsheet in Gnumeric. Then I save it in the .gnumeric format. All seems fine and I can continue to work with the spreadsheet. When I close and reopen it, it is (WAS, see below) non-functional. If any of you would like to see the .gnumeric file I can email it to you because it is only 1.7 megs as a .gnumeric file. This is the 1.4.3 RC 1 precompiled for Windows. I didn't compile it myself. Steps to reproduce: 1. Open the .xls file 2. Save it as a .gnumeric file 3. Close then reopen the .gnumeric file Actual results: When reopened, the file does not function properly. I have resolved the issue and described the solution below. Expected results: Does this happen every time? Other information: I seem to have resoloved the problem. There were two main issues: At first, the equation =-average(indirect(DY$1&$AV2):indirect(DY$1&$AW2)) gives #REF! error. I entered the cell to try to trouble shoot it. Since I could not see anything wrong I hit the check box. Voila, it resumed proper function. In another set of equations, Gnumeric apparently did not like the way I had named a variable. The way it dealt with that was to put a ' in front of the equation which referenced that variable name. I renamed the variable (K3P to K_3P) and it worked. I then saved and exited. When I reopened, it worked fine.
Please email a copy to terra@gnome.org. If the contents is confidential, please state so and I'll delete it after investigating. (It's normal that .gnumeric files are smaller -- they are compressed xml files.)
Ok, got it. I'll have a look.
Fixed in cvs HEAD. "K3P" was seen as "K3" and then "P". The fix is a touching core parts of the program so I am reluctant commit it to the 1.4 series for a while. That's a honking big spreadsheet, btw.!