17 replies to this topic

[Lovecasio]

Hi everyone.
This evening, I tried to download the Spreadsheet App for ClassPad from the site that mamaf show in this forum. 15.8 MB-how big it is, while I have only 56K modem and the connection line in VietNam is not so good. After 30 minutes, it is 40 percent of download. But then, download was complete immediately. Open the file "Spreadsheet.rar", the error message appeared. However, I could access Spreadsheet installer and Spreadsheet user guide in many languages. The main file: Spreadsheet.exe cannot be opened. :motz:
Is anyone there know the download that has only the file Spreadsheet.exe?

[Lovecasio]

As I read in a page in the manual, the negative value is ignor when your graph like log and ln. Is it because of OS update? If you have it, can you try this to check can the OS update fix something:

- Try to graph y=sqrt(x) in graph mode. Is it faster? The same for y=log(a,x) or y=ln(x) or y=sin^-1(x)...
- Find the maximum value of -x^4-x^2-2 in Main app (real setting). Something happen?

I hope someone understand.

[PJay]

I downloaded it (15.8MB) with a 33.6K line ! :rlol:
It worked correctly !
Address : http://casiocalto.fr...Spreadsheet.rar

[BiTwhise]

In my computer the exe opens fine.. but, it doesn't do anything :/

After "installing", all the setup phases are checked, and only the 'finish' button is enabled..

[CrimsonCasio]

hmm... what web site did you get this from, your not supposed to be able to get it anymore (it was sort of a beta release). Casio sent out requests to everyone that had it on their site to please remove it.

[Lovecasio]

Spreadsheet application is finally released

Download it directly at Spreadsheet.zip at www.classpad.de/euro
or site: www.classpad.de

There, you can download only the Spreadsheet setup (10.9 MB).

The "OS update" update my ClassPad to verson 1.20, and some built in app are also updated to the new verson ( I dont know what has been improve, but it really solve some bug. Ex: fmax(-x^4-x^2-2) in Real mode is OK. Before, a Error table occur, and the ClassPad restart)

Have fun !

[BiTwhise]

Crap!!

It still does the same thing as the old one
Just ticks all the setup phases, and enables the 'finish' button

Hope it's not like the old language add-ins for the afx, that had to run on Win98 or Win95

[UserC300]

For what did I sign the newsletter? :motz:

[maurice1979]

I installed it without any problems so far.
oh, and it beeped

start spreadsheet.EXE' /> and follow instructions.
I don't see how that's a problem.

[Lovecasio]

Yes, everything is OK. The install process is easy, just follow what tell you.
(at least in windows XP). It can be used many time in one operating system.

[BiTwhise]

I know the whole procedure is suppose to be easy...

Problem is .. it doesn't ever get to the "easy part".. it just skips it

start spreadsheet.exe and follow instructions.

I'm not retarded, thank you

[maurice1979]

I'm not retarded, thank you

really??

ok But serious, I think there is nothing is wrong with your CP or with the exe.
If you never had any problems about transfering data, then the drivers should be ok.
I was running it in win 98, Lovecasio in XP, it could be OS related, what OS are you using?
Did you try installing it at some other person's PC?
I did remember that installing the CP manager for XP, there was a different prosedure for installing.
maybe if you re-install the manager, it would work.
you'll have to find out where something went wrong.
maybe you got some bugs on your pc? did you do a virus sweep?
it isn't easy to say what the cause could be.

I know one thing that should make it work

[BiTwhise]

Well, I'm running WinXP

-Haven't tried it on another PC yet
-Don't have a virus
-Transfers work fine from the manager.. (this isn't a transfer failure... it's simply the program going "hey.. I'm finished.. wheeee", before it's actually finished)

You know the end screen right.. with all the setup phases completed and ticked, and a 'finish' button enabled
this is where I'm taken right after the "installation" of the installation program is done.


I emailed Casio about it.. Don't expect a quick answer, but hopefully they can help

[maurice1979]

I want to use a figure in a field to supplement x in a funtion,
2x-1, (sin x)/x, or somthing.
what I have to do is type in some numbers in colum A1 to An.
then the awnser B1 to Bn.
in the colum B I have to copy and paste the funtion and use 2*A1-1.
should i use a$1? I'm not really sure If I understood the manual.
Is there a easy way to do this?

[SoftCalc]

I want to use a figure in a field to supplement x in a function,
2x-1, (sin x)/x, or something.
what I have to do is type in some numbers in column A1 to An.
then the awnser B1 to Bn.

First an explanation on the $ symbol. This makes a reference absolute for paste and fill operations. If you have the reference A$1 in a formula, row-1 will not be translated if you use this formula for pasting/filling in a different row. This means you don't want to use an absolute reference for the row.

Now for addressing your problem, try using the Fill Range function. Its in the menu under Edit : Fill Range.

Say for example you want to use the formula 2x-1, where x is in the A column and the result is in the B column. Also assume for this example you are using rows 1 through 10. Enter the following...

Formula: =2*A1+1
Range: B1:B10

This will fill in your B column. Then you only need to enter in your values in the A column. If you are entering a known sequence in the A column you can use the Fill Sequence dialog (its in the menu right under the fill range dialog).

Another trick, if you have a formula for the values in the A column you can use the fill range dialog for this too. For example, if you want integer values from 1 to 10, you can enter 1 in A1. Then use the Fill Range dialog with the following...

Formula: =A1+1
Range: A2:A10

The cool thing about this is, you can change A1 and all of your A values will update. This means you can switch the range from 11 to 20 my simply changing A1 to 11.

Oh, and here is one more trick. You can have the range automatically detected for the Fill Range dialog by selecting the range you want first. If you have a selection it uses this as the initial value for many of the dialogs.

This is only one way you can solve your problem. There are a ton of other ways. You could use copy/paste, etc....

[CrimsonCasio]

heed the all knowing voice

[BiTwhise]

Note that you can use Classpad specific functionality as well in the spreadsheet.

For example, if you have a formula in, say cell A1, like "x^2+x" for example
You could replace the 'x' with something from another cell using the option '|' symbol
say you have the number you like for 'x' in B1, and you want the result of the equation in C1

A1: "=x^2+x"
B1: "12" <- just any number
C1: "=A1|x=B1" -> producing the value '156'


This way you can access formulas with absolute cell referencing and use them all over your sheet, only replacing the values in the formulas with values of other cells

[maurice1979]

this fill range thingy is handydandy