Path: utzoo!utgpu!water!watmath!clyde!rutgers!ames!aurora!labrea!decwrl!pyramid!voder!kontron!optilink!cramer
From: cramer@optilink.UUCP (Clayton Cramer)
Newsgroups: comp.binaries.ibm.pc
Subject: Re: MS-DOS spreadsheet (sc)
Message-ID: <1851@optilink.UUCP>
Date: 18 Jan 88 18:11:07 GMT
References: <332@cogpsi.UUCP>
Organization: Optilink Corporation, Petaluma, CA
Lines: 33

> 
> This is a port of the Unix sc spreadsheet to MS-DOS.
> 

It's real nice (especially for what it costs :-)), but there are at least
two bugs in it that users should be aware of.  (Hopefully whoever did the
port can fix both of the problems).

1. The most serious bug is that if a recalculation causes a number to change
sign, and at least one of the digits is unchanged, it appears that the 
screen is not always updated.  You can force screen update with ^L, and
the numbers will now be correct, but make sure you force redisplay when
you cause a recalculation -- otherwise the numbers on the screen may
mislead you.

2. If you put in several rows, then set a cell to a formula like:

    = D2+D3+D4+D5

then delete row 2, the formula will be changed not to:

    = D2+D3+D4

but:

    = D2+D2+D3+D4

which is definitely wrong.

The first bug sounds like a PC-specific one.  The second bug sounds like
it might be a basic bug shared with the UNIX version.  Does anyone know?

Clayton E. Cramer