HP Forums

Full Version: Programming the spreadsheet from with spreadsheet app and from CAS
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am looking to do spreadsheet operations on the spreadsheet app and within the spreadsheet.

Note I am not interested in programming macros.

This is about entering data either from the cas or within the spreadsheet app.

To illustrate:
I want to do these commands programmatically either in the cas or spreadsheet:

1. Column A has numbers from 0 to 10
2. Column B has the numbers A^2
3. Column C has the num.
4. Column D has the numbers A^4

I tried the method of copying for example at this tutorial
https://bellebot.com/hp-prime-spreadsheet-tutorial but could not do a copy of the column values of A and for example column B is A^2.
I could not work out how to do a single paste of column B.

Again the questions are:
(a) is there a way to do steps 1. to 4. in the spreadsheet
(b) is there a a way to poluate the cells within the cas screen NOT the macro method.

Thank you
Anthony, Sydney[/align]
Open spreadsheet
enter 1 in A1
activate A2
enter: =1+A1
back to A2
<Copy> , that's shift View
Select -- changes to Sel■
cursor down to A10, watch column becoming blue
<Paste> that's shift Menu
choose 1+A1
Voilá column A has your numbers 1 through 10

activate B1
enter: =A1^2
back to B1
<Copy>
Select
Cursor down to B10, watch column becoming blue
<Paste>
choose A1^2
Voilá column B has squares of column A

activate A1
Select
cursor down to A10, watch column becoming blue
<Copy>
activate C1
<Paste>
choose {1,2,3,4,5,6,7,8,9,10}
Voilà numbers in column C

activate D1
enter: =A1^4
back to D1
<COPY>
Select
Cursor down to D10, watch column becoming blue
<Paste>
Choose A1^4
Voilá column D has column A^4

Maybe there is a simpler way, but this works at least

Günter
Dear Herr Guenter,
Thank you for your reply. It is appreciated.
Your response has generated a curiosity in me and I want to share back.
Generate a set of numbers 1 to 4 in spreadsheet
Open the spreadsheet app by pressing Apps then Spreadsheet icon
In column A do the following:
In A1 type: 1
In A2 type: =A1+1
While in A2 press Shift and View/Copy
Move to A3
In A3 Press Shift and Menu/Paste
You are presented with choices in a submenu. Choose Formula press Enter

Generate square, cube and fourth power
We will demonstrate for square:
For square of numbers:
Goto column B start at B1.
Type: =A1^2
While in B1 press Shift and View/Copy
Move to B2 Press Shift and Menu/Paste select Formula submenu
Move to B3 Press Shift and Menu/Paste select Formula submenu
Move to B4 Press Shift and Menu/Paste select Formula submenu

For cube of numbers
Goto column C start at C1.
Type: =A1^3
While in C1 press Shift and View/Copy
Move to C2 Press Shift and Menu/Paste select Formula submenu
Move to C3 Press Shift and Menu/Paste select Formula submenu
Move to C4 Press Shift and Menu/Paste select Formula submenu

Similar process for number^4 as for squaring and cubing
Voilá/Hier/Here!!!!!

Now the other method for which I seek advice is to do the same is within the CAS system

Danke/Merci/Thanks
Anthony,Sydney
Reference URL's