HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
|
12-07-2015, 12:27 AM
(This post was last modified: 12-07-2015 12:28 AM by jasonX.)
Post: #1
|
|||
|
|||
HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
I'm creating a simple spreadsheet application for the HP Prime. I need to be able to change the headers of the columns from within the program, but can't find how to accomplish that. Is it even possible? Any help would be appreciated.
Thanks |
|||
12-07-2015, 06:04 AM
Post: #2
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Bonjour
Hello Code: Cell(0,n,2):="name" n = No. of column A = 1, B = 2 etc ... Pour nommer une ligne: To name a line : Code: Cell(n,0,2):="name" Sorry for my english |
|||
12-07-2015, 06:34 AM
Post: #3
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Thanks a lot Tyann. It worked like a charm! Quick question, if you don't mind. Is that information in the user's guide or did you get if from another place? I'm asking because I've being trying to learn the programming language of the calculator but I'm having a hard time learning from the user's guide. I found some quick tutorials from Han Duong and Edward Shore, which were great to grasp the basics; but I question myself if there exist another source of information that I'm not aware of, because sometimes their tutorials include details which I'm sure are not in the user's guide. For example, this information you gave me I couldn't find it in the guide, but now that I now that command exists I found more detailed information in the help of the calculator. I was under the impression that user's guide was the most complete reference and it doesn't seem to be so. Any information will be appreciated.
Thanks |
|||
12-07-2015, 11:56 AM
Post: #4
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Bonjour
Peut-être n'avez vous pas la dernière version, ou avez vous le guide rapide. Regardez ici: Hello Maybe you do not have the latest version , or you have the guide Quick . Look here: ftp://ftp.hp.com/pub/calculators/Prime/D...alculator/ Sorry for my english |
|||
12-07-2015, 01:26 PM
Post: #5
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
From the built-in help about "Cell":
Quote:Syntax: Cell(RowNumber, ColNumber, [n]) |
|||
12-07-2015, 07:48 PM
Post: #6
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
(12-07-2015 01:26 PM)Didier Lachieze Wrote: From the built-in help about "Cell": Hi, Didier, Tyann! Thanks! Lets suppose I want to select a range of column headers (A to C). I put custom labels there and desire to change the Horizontal Aligning. I tried the following: Cell(0,1):Cell(0,3)(8):=1; but get a syntax error. Tried different things but none worked so far. Any ideas? Thanks |
|||
12-07-2015, 08:12 PM
(This post was last modified: 12-07-2015 08:15 PM by Tyann.)
Post: #7
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Bonjour
Je ne sais pas si l'on peut spécifier un bloc de cellules avec Cell(. Pour vôtre cas le plus simple me semble: Hello I do not know if we can specify a block of cells with Cell ( . In the simplest case yours seems to me : Code: FOR I FROM 1 TO 3 DO Sorry for my english |
|||
12-07-2015, 08:23 PM
(This post was last modified: 12-07-2015 08:26 PM by jasonX.)
Post: #8
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Hi,
Yes, you're right, that should work. I considered doing some kind of loop like that but thought there was something more compact to accomplish it. Do you know if I can clear a Spreadsheet from a program? I mean, similar to the functionality of SHIFT+ESC. I tried RECT(); but it didn't work. Thanks |
|||
12-07-2015, 09:23 PM
(This post was last modified: 12-07-2015 09:26 PM by Tyann.)
Post: #9
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Il n'existe pas à ma connaissance de moyen satisfaisant pour faire cela.
Vous pouvez faire un truc du genre : It does not exist to my knowledge satisfactory way to do that. You can do something like : Code: A1:z999:=0 or A1:z999:="" par exemple. for example. Sorry for my english |
|||
12-08-2015, 02:03 AM
Post: #10
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
(12-07-2015 09:23 PM)Tyann Wrote: Il n'existe pas à ma connaissance de moyen satisfaisant pour faire cela. Yeah, it could be a quick fix in some situations, but that method won't clear any attributes set in the cells, like bgcolor, aligning, etc. I'm getting frustrated because there are a lot of basic questions on the programming side that just doesn't seen to be covered in the user's guide. I really appreciate your help. I think this calculator has a lot of potential but the documentation needs to be improved a lot in certain areas. Most students would give up before bothering that much to get something done. :0( |
|||
12-08-2015, 06:14 AM
(This post was last modified: 12-08-2015 06:15 AM by Tyann.)
Post: #11
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Bonjour
Pour effacer les attributs il faut mettre -1. Par exemple, pour remettre le nom d'origne A d'une colonne: Hello To clear the attributes must be put -1 . For example, to replace the name of a column origne A : Code: Cell(0,1,2):=-1 Sorry for my english |
|||
12-08-2015, 06:21 AM
Post: #12
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Hello,
Cell(0,1):Cell(0,3)(8):=1 will not work for 2 reasons: Cell(0,1):Cell(0,3) is not recognized by the Spreadsheet app as a cell/range reference. only name:name is (with name either a named cell name or a traditional cell reference). Cell(0,3)(8) is also not recognized. the (8) only works when the stuff on the left is a variable that contains a list or matrix object. In this care, the stuff on the left is Cell(0,3) which is NOT a variable but a function call that returns a list and {data}(n) is not a recognized syntax/operator in PPL. In this case, you will indeed have to use a loop, sorry about that. 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-08-2015, 10:56 AM
Post: #13
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Thanks!
I liked that explanation because the HP updated Manual (latest version- portuguese) does not appear so. This information exists only in the HELP Calculator. Leo |
|||
12-08-2015, 01:45 PM
Post: #14
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
That's great. I think now I have enough information to complete the task. Thanks a lot for your help!
|
|||
12-08-2015, 02:13 PM
Post: #15
|
|||
|
|||
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
(12-08-2015 06:21 AM)cyrille de brébisson Wrote: Hello, Hi, Cyrille! Thanks for a very valuable insight on the fundamentals. Question...is it reasonable to assume that a command mimicking the functionality of "SHIFT +ESC (clear)" could be made available to the programming language, to be able to reset the spreadsheet app, since the functionality already exist? I mean, I can do it manually, but it seems not such command exist to do it in a program. |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: