Re: "Serious cell error"

[Allin Cottrell <cottrell wfu edu>]

On Mon, 11 Nov 2002, Jody Goldberg wrote:

> On Mon, Nov 11, 2002 at 01:12:33PM -0500, Allin Cottrell wrote:

> > If I select a range of cells and do Format Cells/Numeric, most of the 
> > data in the cells disappears and I get messages on stderr like
> >
> > ** (gnumeric:15126): WARNING **: Serious cell error at 'B3'.

> 1.1.11 had some work done on just in time rendering.  That message
> indicates that something went amiss with the rendering.  I can't
> replicate it with the current CVS so it must have been fixed.  There
> will be a 1.1.12 release on Thursday.

After experimentation, I see this only happens when the cell contents
are given by a formula.  E.g. type "1" into A1, type "=A1+1" into A2,
select A1 and A2, do Format/Cells/Numeric and accept the default of 2
decimal places.  A1 is formatted to 2 decimal places but the text in
A2 disappears.  The formula bar still shows the correct formula but
the cell in the worksheet appears blank.

Allin Cottrell.