Programming the spreadsheet from with spreadsheet app and from CAS - Printable Version +- 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 , that's shift View Select -- changes to Sel■ cursor down to A10, watch column becoming blue that's shift Menu choose 1+A1 Voilá column A has your numbers 1 through 10 activate B1 enter: =A1^2 back to B1 Select Cursor down to B10, watch column becoming blue choose A1^2 Voilá column B has squares of column A activate A1 Select cursor down to A10, watch column becoming blue activate C1 choose {1,2,3,4,5,6,7,8,9,10} Voilà numbers in column C activate D1 enter: =A1^4 back to D1 Select Cursor down to D10, watch column becoming blue 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