Register

Displaying Spreadsheet function or list matrix

Discuss issues related to the Casio Basic Language
Member
Posts: 48
Joined: Mon Apr 23, 2012 3:58 am
Location: Chennai,India
Calculators: Casio fx-9750 G II, Casio fx-9860G Slim, Casio fx-9860 GII

Displaying Spreadsheet function or list matrix

Postby nagarajan » Thu Aug 29, 2013 1:13 pm

I am having a casio basic program in which I need to implement the spreadsheet function or a matrix like list editor.
They should be accessed from the PRGM menu.
Post your suggestions.

Member
User avatar
Posts: 31
Joined: Wed Apr 18, 2012 4:48 pm

Re: Displaying Spreadsheet function or list matrix

Postby Cartix » Thu Aug 29, 2013 2:40 pm

At first, a "please" would be appreciated.
No suggestion, not possible
Image

Member
Posts: 48
Joined: Mon Apr 23, 2012 3:58 am
Location: Chennai,India
Calculators: Casio fx-9750 G II, Casio fx-9860G Slim, Casio fx-9860 GII

Re: Displaying Spreadsheet function or list matrix

Postby nagarajan » Thu Aug 29, 2013 6:40 pm

Sure Cartix Sir.
But something like defining a matrix and assigning it to list function.
Any suggestions please.

Senior Member
Posts: 369
Joined: Tue Jan 03, 2012 11:24 pm
Calculators: Casio Afx 1.0, Casio fx-9860 GII SD, Casio Classpad 330, Casio fx-CG 20, Casio Classpad fx-cp400

Re: Displaying Spreadsheet function or list matrix

Postby helder7 » Thu Aug 29, 2013 6:55 pm

If im sure, is not possible acess spreadsheet from programs.

I wrote an exemple of a "list editor" in basic for you! :thumbup:
It can get values of the list1, list2 and list3 of the calculator and is possible edit these values or add new values. Is attached in this post.

Image

BTW: dont forget to put at least 1 value in each list before use the program.
Attachments
LISTEDIT.zip
(599 Bytes) Downloaded 467 times
SiO2 + CaCO3 ----------> CaSiO3 + CO2

Member
Posts: 48
Joined: Mon Apr 23, 2012 3:58 am
Location: Chennai,India
Calculators: Casio fx-9750 G II, Casio fx-9860G Slim, Casio fx-9860 GII

Re: Displaying Spreadsheet function or list matrix

Postby nagarajan » Thu Aug 29, 2013 7:26 pm

Hello Admin Sir,

That was amazing stuff.
Instead of "Enter new Cell Value" screen how about typing the value directly and saving it.
This can reduce some time I hope while inputting the values.

Senior Member
Posts: 369
Joined: Tue Jan 03, 2012 11:24 pm
Calculators: Casio Afx 1.0, Casio fx-9860 GII SD, Casio Classpad 330, Casio fx-CG 20, Casio Classpad fx-cp400

Re: Displaying Spreadsheet function or list matrix

Postby helder7 » Thu Aug 29, 2013 8:35 pm

nagarajan wrote:Instead of "Enter new Cell Value" screen how about typing the value directly and saving it.

In basic this ("Enter new Cell Value" in another window, with ? command) is the easy and fatest way to input new values.
SiO2 + CaCO3 ----------> CaSiO3 + CO2

Member
Posts: 48
Joined: Mon Apr 23, 2012 3:58 am
Location: Chennai,India
Calculators: Casio fx-9750 G II, Casio fx-9860G Slim, Casio fx-9860 GII

Re: Displaying Spreadsheet function or list matrix

Postby nagarajan » Fri Aug 30, 2013 7:59 am

Thank you so much for the explanation Sir. :thumbup:

Return to Casio Basic Development

Who is online

Users browsing this forum: No registered users and 0 guests