sheettest
May 10th, 2002, 09:08 PM
I am testing the trial version of TinySheet v4.12 on a Handspring Visor Neo. I have repeatedly received "fatal reset" and "memory errors" that either require both hard and soft resets to restore my PDA to functionality.
The spreadsheet that I am using is rather simple, but TinySheet doesn't seem able to handle it on my Handspring Visor Neo. Below is a brief description of the data used in the spreadsheet that causes problems:
A1: Size
B1: Width
C1: Min
D1: Max
A2: 65
B2: =(16/9)*A2/(256/81+1)^(1/2)
C2: =(1/12)*(B2/2)/(tan(pi()/12))
D2: =(1/12)*(B2/2)/(tan(pi()/18))
(If I am lucky and it hasn't crashed yet, I enter several more cells of data before it is guaranteed to crash again.)
A3: 64
B3: =(16/9)*A3/(256/81+1)^(1/2)
C3: =(1/12)*(B3/2)/(tan(pi()/12))
D3: =(1/12)*(B3/2)/(tan(pi()/18))
Upon entering C2 or D2, I usually receive "fatal reset" or "memory error ...". The crash will occur if I enter the formula containing tan() and pi(), though it may not happen immediately. Sometimes, it happens right after I enter C2. Sometimes, I am able to enter a bit more data before it crashes.
When I am able to recover from the crashes with a soft reset, I go to the C2,D2,(optionally C3,D3) cells, and they are filled with #ERR! despite the fact that the formula is a valid one. If I try to recalculate use /O command, it crashes.
Even after a hard reset with NOTHING on my Visor Neo but the ROM applications and TinySheet, I still have these problems. For what it's worth, I tried TinySheet with the same data on a Palm m100, and it crashes just the same. I would appreciate any help that I could receive in resolving these issues. Thanks.
The spreadsheet that I am using is rather simple, but TinySheet doesn't seem able to handle it on my Handspring Visor Neo. Below is a brief description of the data used in the spreadsheet that causes problems:
A1: Size
B1: Width
C1: Min
D1: Max
A2: 65
B2: =(16/9)*A2/(256/81+1)^(1/2)
C2: =(1/12)*(B2/2)/(tan(pi()/12))
D2: =(1/12)*(B2/2)/(tan(pi()/18))
(If I am lucky and it hasn't crashed yet, I enter several more cells of data before it is guaranteed to crash again.)
A3: 64
B3: =(16/9)*A3/(256/81+1)^(1/2)
C3: =(1/12)*(B3/2)/(tan(pi()/12))
D3: =(1/12)*(B3/2)/(tan(pi()/18))
Upon entering C2 or D2, I usually receive "fatal reset" or "memory error ...". The crash will occur if I enter the formula containing tan() and pi(), though it may not happen immediately. Sometimes, it happens right after I enter C2. Sometimes, I am able to enter a bit more data before it crashes.
When I am able to recover from the crashes with a soft reset, I go to the C2,D2,(optionally C3,D3) cells, and they are filled with #ERR! despite the fact that the formula is a valid one. If I try to recalculate use /O command, it crashes.
Even after a hard reset with NOTHING on my Visor Neo but the ROM applications and TinySheet, I still have these problems. For what it's worth, I tried TinySheet with the same data on a Palm m100, and it crashes just the same. I would appreciate any help that I could receive in resolving these issues. Thanks.