![]() |
APP spreadsheet insert values [Solved] - 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: APP spreadsheet insert values [Solved] (/thread-5296.html) |
APP spreadsheet insert values [Solved] - jrozsas - 12-08-2015 10:54 AM Hi, In APP spreadsheet, it is possible to make a program to create a spreadsheet and enter a value in cells? Is there any example? I want to create a program that creates a spreadsheet and enter values in the cells. RE: APP spreadsheet insert values - cyrille de brébisson - 12-09-2015 05:51 AM Hello, Yes, it is. Make a copy of the spreadsheet app (move cursor on spreadsheet and click on save) (let us call is sscpy) start the app. go in the program catalog, click on sscpy program and enter: START() BEGIN local a; for a:= 1 to 10 do Cell(a,1):= a^2; end; END; exit the program catalog, back in app view. Now, when you START the app (clicking on the app icon when in the APP catalog only starts the app if it was NOT the current app, so you need first to exit to another app and then return to sscpy), so, when you start the app, it will execute the START function and populate your spreadsheet. cyrille RE: APP spreadsheet insert values - jrozsas - 12-09-2015 11:11 AM (12-09-2015 05:51 AM)cyrille de brébisson Wrote: START()Fantastic! Thanks cyrille, but how to an external program enter the values in the spreadsheet sscpy? RE: APP spreadsheet insert values - Tim Wessman - 12-09-2015 08:10 PM (12-09-2015 11:11 AM)jrozsas Wrote: Fantastic! That is what the line "Cell(...):=<stuff>" is doing. Spreadsheet.Cell(1,3):='A1+A2' stores a formula into A3 that will add A1 and A2... and so on. RE: APP spreadsheet insert values - jrozsas - 12-09-2015 08:32 PM (12-09-2015 08:10 PM)Tim Wessman Wrote:Tim,(12-09-2015 11:11 AM)jrozsas Wrote: Fantastic! Do you believe that in the manual in Portuguese, latest version, there is nothing about "Cell"? This information did you get to where? This is the only page that has some information about "Cell" ![]() ![]() RE: APP spreadsheet insert values - Tim Wessman - 12-09-2015 08:57 PM (12-09-2015 08:32 PM)jrozsas Wrote: This information did you get to where? The built in calculator help for "Cell references and Cell". You have about a page of text describing it there. To find it most easily, type "Cell" and press your calculator HELP key. It will take you right there where you will find this information: Quote:In most cases, you will be referencing cells directly by their RC names as in A1 or D6 just like in your usual spreadsheet. Only advanced formulas creators or users that need access to spreadsheet data from outside of the spreadsheet numerical view will need to understand the full complexity of cell references. RE: APP spreadsheet insert values - jrozsas - 12-09-2015 11:27 PM (12-09-2015 08:57 PM)Tim Wessman Wrote:Interesting. In Portuguese is not the same. Note the differences in help menu> tree>search:(12-09-2015 08:32 PM)jrozsas Wrote: This information did you get to where? English: ![]() ![]() Portuguese: ![]() ![]() Is there any way to print everything this that help? RE: APP spreadsheet insert values - cyrille de brébisson - 12-10-2015 05:57 AM Hello, In the emulator, with a help currently displayed, pressing Edit/copy should copy the whole help text in the PC clipboard. Cyrille RE: APP spreadsheet insert values - jrozsas - 12-10-2015 10:25 AM (12-10-2015 05:57 AM)cyrille de brébisson Wrote: Hello,But only with the help currently displayed? And print all the help (A-Z - all commands)? We could create a book with that help. RE: APP spreadsheet insert values - Thomas_Sch - 12-10-2015 10:49 AM (12-10-2015 10:25 AM)jrozsas Wrote:Erwin (eried) did this already:(12-10-2015 05:57 AM)cyrille de brébisson Wrote: Hello,But only with the help currently displayed? And print all the help (A-Z - all commands)? We could create a book with that help. http://www.hpmuseum.org/forum/thread-4861.html?highlight=reference RE: APP spreadsheet insert values - jrozsas - 12-10-2015 06:47 PM (12-10-2015 10:49 AM)Thomas_Sch Wrote:I noticed something interesting. The "Cell" function does not exist in this PDF. Will other functions are also not in pdf?(12-10-2015 10:25 AM)jrozsas Wrote: But only with the help currently displayed? And print all the help (A-Z - all commands)? We could create a book with that help.Erwin (eried) did this already: RE: APP spreadsheet insert values - Thomas_Sch - 12-11-2015 06:54 AM (12-10-2015 06:47 PM)jrozsas Wrote: ..We should ask Erwin (eried) in his thread. Maybe the App-functions are mising ? RE: APP spreadsheet insert values - Terje Vallestad - 12-11-2015 08:32 AM (12-10-2015 06:47 PM)jrozsas Wrote:(12-10-2015 10:49 AM)Thomas_Sch Wrote: Erwin (eried) did this already:I noticed something interesting. The "Cell" function does not exist in this PDF. Will other functions are also not in pdf? The full Command Tree for 6975 (previous version) can be found in this post http://www.hpmuseum.org/forum/thread-2796.html It includes the help for cell Cheers, Terje RE: APP spreadsheet insert values - jrozsas - 12-11-2015 10:26 AM (12-11-2015 08:32 AM)Terje Vallestad Wrote:(12-10-2015 06:47 PM)jrozsas Wrote: I noticed something interesting. The "Cell" function does not exist in this PDF. Will other functions are also not in pdf? THANKS Terje! Very important.Exactly what I was looking for. RE: APP spreadsheet insert values - toshk - 12-14-2015 11:51 AM i have a list say L1={1,2,3,4} which can vary in size depending on the question. i want to output this "variable list" into a spreadsheet column A. and possibly from an external app. //this code crashes prime.............. for a:= 1 to length(L1) do Cell(1,a):= L1(a); end; //........................................... RE: APP spreadsheet insert values - jrozsas - 12-14-2015 12:37 PM (12-14-2015 11:51 AM)toshk Wrote: i have a list say L1={1,2,3,4} which can vary in size depending on the question.Sintaxe: FOR var FROM início TO fim DO comandos END; START() BEGIN local a; for a:=1 to length(L1) DO Cell(a,1):=L1(a); END; END; ![]() ![]() RE: APP spreadsheet insert values - Tim Wessman - 12-14-2015 09:37 PM I am unable to see this. I turned on Portuguese just to make sure language wasn't a part. This was the code I tried in the spreadsheet app function. I had 1 2 3 4 in my list. I also tried with other values, and with an empty list. It works fine with either the Cell(a,1) or Cell(1,a)[/code] Code: START() [code] //this code crashes prime.............. for a:= 1 to length(L1) do Cell(1,a):= L1(a); end; //........................................... Am I misunderstanding you here? RE: APP spreadsheet insert values - toshk - 12-14-2015 11:27 PM [attachment=2957] test values..... gausss(M1,M3) to run; type say vv to output a list... this app has a lot of outputs , but i just want to tabular certain values in PFL sheet. say busnumber in column A of PFL. this RE: APP spreadsheet insert values - jrozsas - 12-15-2015 12:04 PM Toshk, for me it worked correctly, as shown in the figures. |