[comp.soft-sys.andrew] automatic recalc failure in Table

tobeye@NORTHSTAR.DARTMOUTH.EDU (Anthony Edwards) (02/19/91)

I enjoy using spreadsheets and am willing to use the limited
implementation in the Table application.

Today, I discovered a bug:  automatic recalcuation fails if you paste a
number into place.  To create the table below, I put the formula into
cell [1,3] and then typed 10 into cell [1,2].  I then pasted 15 into
[1,1] and notice how the result is still wrong (if the result in the
mail message is correct, then apparently a recalculation occurs when
this mail message is redisplayed or something).
[An Andrew ToolKit view (a spreadsheet) was included here, but could not
be displayed.]Just thought you folks might be interested in hearing
about it....

   - Anthony

nsb@THUMPER.BELLCORE.COM (Nathaniel Borenstein) (02/19/91)

I got an even worse behavior.  When your message arrived, the numbers
were right, indicating that the recalculation did occur when I received
the message.  After verifying that the spreadsheet was working, I tried
pasting in a number.  It looked sort of like it had inserted a text
object containing the number -- the font was different, and the
calculation was, as you said, not correct.  Then I tried to type in a
new number by hand, and the whole application dumped core!

Clearly a bug or two still lurks in the depths of the table object...