10-24-2023, 09:55 AM
Post: #1
 Anthony The Koala Junior Member Posts: 34 Joined: Aug 2023

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]
10-24-2023, 06:06 PM (This post was last modified: 10-24-2023 06:10 PM by Guenter Schink.)
Post: #2
 Guenter Schink Senior Member Posts: 520 Joined: Dec 2013
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
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
10-24-2023, 11:42 PM
Post: #3
 Anthony The Koala Junior Member Posts: 34 Joined: Aug 2023
Dear Herr Guenter,
Your response has generated a curiosity in me and I want to share back.
Generate a set of numbers 1 to 4 in spreadsheet
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

For cube of numbers
Goto column C start at C1.
Type: =A1^3
While in C1 press Shift and View/Copy

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
 « Next Oldest | Next Newest »

User(s) browsing this thread: 1 Guest(s)