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
 jasonX Junior Member Posts: 7 Joined: Dec 2015
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
 Tyann Member Posts: 199 Joined: Oct 2014
RE: HP PRIME: Can the Columns headers of a spreadsheet be changed from a program
Bonjour
Hello
Code:
Cell(0,n,2):="name"
n=n°de colonne avec A=1,B=2 etc...
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
 jasonX Junior Member Posts: 7 Joined: Dec 2015
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
 Tyann Member Posts: 199 Joined: Oct 2014
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
 Didier Lachieze Senior Member Posts: 1,137 Joined: Dec 2013
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])
[..]
[...]
CELL ATTRIBUTES (n)
[...]
2: name
12-07-2015, 07:48 PM
Post: #6
 jasonX Junior Member Posts: 7 Joined: Dec 2015
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":

Quote:Syntax: Cell(RowNumber, ColNumber, [n])
[..]
[...]
CELL ATTRIBUTES (n)
[...]
2: name

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
 Tyann Member Posts: 199 Joined: Oct 2014
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 Cell(0,I,8):=1; END;

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
 jasonX Junior Member Posts: 7 Joined: Dec 2015
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
 Tyann Member Posts: 199 Joined: Oct 2014
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
 jasonX Junior Member Posts: 7 Joined: Dec 2015
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.
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.

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
 Tyann Member Posts: 199 Joined: Oct 2014
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
 cyrille de brébisson Senior Member Posts: 845 Joined: Dec 2013
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
 jrozsas Member Posts: 158 Joined: Nov 2014
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
 jasonX Junior Member Posts: 7 Joined: Dec 2015
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
 jasonX Junior Member Posts: 7 Joined: Dec 2015
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,

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).

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: 1 Guest(s)