Article View: algonet.amiga
Article #1TurboCalc3.5__Confusion
From: Hans Malmberg
Date: Sat, 27 Jan 1996 17:05
Date: Sat, 27 Jan 1996 17:05
56 lines
2469 bytes
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!usenetShow 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)