Programming the spreadsheet from with spreadsheet app and from CAS

10242023, 09:55 AM
Post: #1




Programming the spreadsheet from with spreadsheet app and from CAS
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/hpprimespreadsheettutorial 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] 

10242023, 06:06 PM
(This post was last modified: 10242023 06:10 PM by Guenter Schink.)
Post: #2




RE: Programming the spreadsheet from with spreadsheet app and from CAS
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 

10242023, 11:42 PM
Post: #3




RE: Programming the spreadsheet from with spreadsheet app and from CAS
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 

« Next Oldest  Next Newest »

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