🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: algonet.amiga
Article #1

TurboCalc3.5__Confusion

#1
From: Hans Malmberg
Date: Sat, 27 Jan 1996 17:05
56 lines
2469 bytes
I don't know how to put this, either a bug or I don't understand
some peculiar facility....

TurboCalc3.5 version 3.54 English.

 1. Select CELL C15, edit to =C5+C6-SUM(C7:C14)
 2. Mark Cell C15-N15
 3. Menu: Edit/Fill/Right (N15 reads =N5+N6-SUM(N7:N14)
 4. Select Cell D5, edit to =C15.
 5. Mark Cell D5-N5
 6. Menu: Edit/Fill/Right (N5 reads =M15)
 8. Fill C6:N14 with random values.
    try:
    Set C6 to 37.
    Mark C6:N6.
    Menu: Edit/Fill/Right
    Now: ( on my screen)
    C15 displays 37 (correct) formula is =C5+C6-SUM(C7:C14)
    D5  displays 37 (correct) formula is =C15
    D15 displays 74 (correct) formula is =D5+D6-SUM(D7:D14)
 ** E5  displays  0 (INcorrect) formula is =D15, which is 74.
    Place cursor E5 and activate edit window.
    Do not alter, just press return.
 !! E5 suddenly turns to 74, which is OK, E15 is '111' , ok too.
    But, F5 now reads 37, it should be '111' !!!
    Everytime I edit a cell then correction steps one column
    more to the right side. After 11 inputs then the
    spreadsheet displays the correct values.
 9. The rightmost columns are not calculated properly,
    the left ones are correct, but there is error
    int the transport from (x)15 to (x+1)5.
10. I've done exactly the same construction in a
    Professional Calc spreadsheet, and there it
    works just fine. So does MaxiPlan.
11. I bought TurboCalc as I want to keep the
    Amiga alive, but miscalculations could cause
    serious trouble. Very serious....
12. I have sent information to the proper sources,
    and I post this to listen if anyone other has
    discovered any probles with TurboCalc, or if
    anyone can spot fault behaviour from me when
    construction the spreadsheet.

Appreciating comments from other TurboCalc users I
sign off. CU.

And, just for information, I'm a registered user and
received the program from the UK last Thursday.

Hans

<tsb> Amiga THOR v2.22  No:1270  27-Jan-96 17:18:59
      LUND    13.10'30''E  55.43'24''N
      http://www.algonet.se/~hansmbg
--
Technical Details
Message-ID: <2023.6600T1046T1816@algonet.se>
Path: arc1-ca.pugleaf.net!news.algonet.se!usenet

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!news.algonet.se!usenet
From: hansmbg@algonet.se (Hans Malmberg)
Newsgroups: algonet.amiga,swnet.sys.amiga,comp.sys.amiga.applications
Subject: TurboCalc3.5__Confusion
Date: 27 Jan 1996 17:05:17 GMT
Organization: AlgoNet Public Access Node, Stockholm
Message-ID: <2023.6600T1046T1816@algonet.se>
NNTP-Posting-Host: sophocles.algonet.se
X-Newsreader: THOR 2.22 (Amiga;TCP/IP)