APP spreadsheet insert values [Solved]
|
12-08-2015, 10:54 AM
(This post was last modified: 09-06-2016 11:39 AM by jrozsas.)
Post: #1
|
|||
|
|||
APP spreadsheet insert values [Solved]
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. Leo |
|||
12-09-2015, 05:51 AM
Post: #2
|
|||
|
|||
RE: APP spreadsheet insert values
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 Although I work for the HP calculator group, the views and opinions I post here are my own. I do not speak for HP. |
|||
12-09-2015, 11:11 AM
(This post was last modified: 12-09-2015 11:16 AM by jrozsas.)
Post: #3
|
|||
|
|||
RE: APP spreadsheet insert values
(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? Leo |
|||
12-09-2015, 08:10 PM
Post: #4
|
|||
|
|||
RE: APP spreadsheet insert values
(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. TW Although I work for HP, the views and opinions I post here are my own. |
|||
12-09-2015, 08:32 PM
Post: #5
|
|||
|
|||
RE: APP spreadsheet insert values
(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" Leo |
|||
12-09-2015, 08:57 PM
(This post was last modified: 12-09-2015 09:03 PM by Tim Wessman.)
Post: #6
|
|||
|
|||
RE: APP spreadsheet insert values
(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. TW Although I work for HP, the views and opinions I post here are my own. |
|||
12-09-2015, 11:27 PM
Post: #7
|
|||
|
|||
RE: APP spreadsheet insert values
(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? Leo |
|||
12-10-2015, 05:57 AM
Post: #8
|
|||
|
|||
RE: APP spreadsheet insert values
Hello,
In the emulator, with a help currently displayed, pressing Edit/copy should copy the whole help text in the PC clipboard. Cyrille Although I work for the HP calculator group, the views and opinions I post here are my own. I do not speak for HP. |
|||
12-10-2015, 10:25 AM
Post: #9
|
|||
|
|||
RE: APP spreadsheet insert values
(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. Leo |
|||
12-10-2015, 10:49 AM
Post: #10
|
|||
|
|||
RE: APP spreadsheet insert values
(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-486...=reference |
|||
12-10-2015, 06:47 PM
Post: #11
|
|||
|
|||
RE: APP spreadsheet insert values
(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: Leo |
|||
12-11-2015, 06:54 AM
Post: #12
|
|||
|
|||
RE: APP spreadsheet insert values | |||
12-11-2015, 08:32 AM
Post: #13
|
|||
|
|||
RE: APP spreadsheet insert values
(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 |
|||
12-11-2015, 10:26 AM
Post: #14
|
|||
|
|||
RE: APP spreadsheet insert values
(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. Leo |
|||
12-14-2015, 11:51 AM
Post: #15
|
|||
|
|||
RE: APP spreadsheet insert values
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; //........................................... |
|||
12-14-2015, 12:37 PM
(This post was last modified: 12-14-2015 01:02 PM by jrozsas.)
Post: #16
|
|||
|
|||
RE: APP spreadsheet insert values
(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; Leo |
|||
12-14-2015, 09:37 PM
Post: #17
|
|||
|
|||
RE: APP spreadsheet insert values
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? TW Although I work for HP, the views and opinions I post here are my own. |
|||
12-14-2015, 11:27 PM
(This post was last modified: 12-14-2015 11:31 PM by toshk.)
Post: #18
|
|||
|
|||
RE: APP spreadsheet insert values
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 |
|||
12-15-2015, 12:04 PM
(This post was last modified: 12-15-2015 12:05 PM by jrozsas.)
Post: #19
|
|||
|
|||
RE: APP spreadsheet insert values
Toshk, for me it worked correctly, as shown in the figures.
Leo |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: