GNOME Bugzilla – Bug 563601
Format "0.0E-00" is invalid
Last modified: 2008-12-08 14:24:54 UTC
Gnumeric 1.8.3, via Ubuntu Intrepid. I have a sheet used for calculating probabilities based on a hidden markov model - most of the contents are derived from a set of nine cells with values in the top-left of the sheet. In Gnumeric, the (default/initial) values are correctly used to generate the rest of the sheet's payload, but I am unable to view these values - if I input a value into the cell, it's not visible in the display, but is visible if I click the cell and look at the equation view (see the second screenshot below, where I've input .1 to the highlighted cell, pressed enter, then re-clicked the cell) http://rercola.acm.jhu.edu/gnumeric_hmm_gnu.png http://rercola.acm.jhu.edu/gnumeric_hmm_gnu2.png Compare and contrast with the behavior of the program which generated the sheet (Excel 2003) - the second screenshot below, again, is after I've input .1 into the highlighted cell, pressed enter, and then re-selected it. http://rercola.acm.jhu.edu/gnumeric_hmm_excel.png http://rercola.acm.jhu.edu/gnumeric_hmm_excel2.png I will post a copy of the spreadsheet as soon as I've gotten permission from the appropriate person. :)
What happens if you change the font for all cells?
Created attachment 124136 [details] Spreadsheet which misbehaves Spreadsheet which misbehaves and doesn't display the default values either in equation view or spreadsheet view in [C-E][11-16].
No effect (on those cells - the cells all change font, obviously, but the contents is no more visible.) I've received permission, so I've attached the spreadsheet above.
Opening the attached spreadsheet in current svn even causes a crash! So I am rainsing the severity.
+ Trace 210586
looks like I'm guilty for the crash :-(
Fixed the crash. Cell contents are not visible with svn trunk, and the content does not appear in the formula bar when selected, and I see no scrollbars (might be related with split panes which are not supported yet). I see the same behavior with 1.8.3 (debian sid package). Looks like the cell issue is related to the custom format used. But even with a standard format, I can't edit the formula.
I was wrong, the formula becomes visible after changing the format and selecting again the cell.
The problem is that we think the format is invalid. It is... [>=0.001]0.0###;[=0]0;0.0E-00; ...and changing the E-00 to E+00 fixes the issue. I need to investigate.
"0.0E-00" seems to be valid in XL. The "-" indicates that the sign for the exponent is optional.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report. Note: problem was in goffice.