+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Programming the spreadsheet from with spreadsheet app and from CAS (/thread-20694.html)
Programming the spreadsheet from with spreadsheet app and from CAS - Anthony The Koala - 10-24-2023 09:55 AM
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]
RE: Programming the spreadsheet from with spreadsheet app and from CAS - Guenter Schink - 10-24-2023 06:06 PM
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
RE: Programming the spreadsheet from with spreadsheet app and from CAS - Anthony The Koala - 10-24-2023 11:42 PM
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