Post Reply 
What's the equivalent of spreadsheet function Cell ()?
02-26-2018, 04:53 AM
Post: #1
What's the equivalent of spreadsheet function Cell ()?
Hi,

It's been a while since doing any HPPPL programming and I noticed the earlier Spreadsheet function Cell is no longer present. The function accepted integer values for spreadsheet row and column, and an optional attribute index value (like cell value, formula or color). On the RHS of an assignment it would return the requested attribute or list of attributes. On the LHS it could assign an attribute or set of attributes to the indicated spreadsheet cell.

Is this still possible in the latest Prime firmware? I can't find anything similar in the Tools-App menu. Has this programmatic access to Spreadsheet cells gone away?

Hope not!
~Mark

Cui Bono?
Find all posts by this user
Quote this message in a reply
02-26-2018, 05:19 AM
Post: #2
RE: What's the equivalent of spreadsheet function Cell ()?
Cell is under Vars>App>Spreadsheet>Numeric
Find all posts by this user
Quote this message in a reply
02-26-2018, 05:56 AM
Post: #3
RE: What's the equivalent of spreadsheet function Cell ()?
Hello,

The latest spreadsheet also adds new programming functions such as ClearCell and CellHasData.

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.
Find all posts by this user
Quote this message in a reply
02-26-2018, 04:00 PM
Post: #4
RE: What's the equivalent of spreadsheet function Cell ()?
Yes, it is a variable and not a function.

Anything that can be stored into, like Cell(1,1):='X^2' or whatever means that the object is a variable.

TW

Although I work for the HP calculator group, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
02-26-2018, 04:13 PM
Post: #5
RE: What's the equivalent of spreadsheet function Cell ()?
Bonjour

Dans les versions béta : dans l'aide des deux fonctions
ClearCell et CellHasData il était écrit que l'on pouvait définir
une colonne ou une ligne entière par -1 mais cela ne fonctionnait pas.

Dans la version 13441, cela n'est plus spécifié dans l'aide et cela ne fonctionne
toujours pas.
c'est dommage car cela aurait été à mon sens très utile, peut-on espérer avoir
cette fonctionnalité dans une prochaine version ?
A noter que le texte d'aide est toujours en Anglais quelque soit le langage selectionné.


Hello

In beta versions: in the help of both functions
ClearCell and CellHasData it was written that one could define
a column or a whole line by -1 but it did not work.

In version 13441, this is no longer specified in the help and it does not work
always not.
it's a shame because it would have been very useful in my opinion, can we hope to have
this feature in a future release?
Note that the help text is always in English whatever the language selected.

Sorry for my english
Find all posts by this user
Quote this message in a reply
02-26-2018, 05:04 PM
Post: #6
RE: What's the equivalent of spreadsheet function Cell ()?
(02-26-2018 05:19 AM)Didier Lachieze Wrote:  Cell is under Vars>App>Spreadsheet>Numeric
Ah, so it is! I thought earlier it had been a function but I couldn't find Cell in the Help text. I checked and the current user manual does list the variable but says nothing about using it. The section on Format Parameters (p. 236) does provide the attribute numbers though. Hopefully things still work the old way.

(02-26-2018 05:56 AM)cyrille de brébisson Wrote:  The latest spreadsheet also adds new programming functions such as ClearCell and CellHasData.

And both are great additions! I was revisiting some old code because these two functions were added. With all the other improvements made, like empty Apps, it seems time to revive that project.

~Mark
BTW, +1 on the -1 problem Tyann!
Find all posts by this user
Quote this message in a reply
02-27-2018, 05:49 AM
Post: #7
RE: What's the equivalent of spreadsheet function Cell ()?
Hello,

Sorry, the -1 was nixed upon a review...
You will need to use a 0 to maxreal (or 0 to 10000, which will work as well as the spreadsheet is limited to 10K lines/columns).

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.
Find all posts by this user
Quote this message in a reply
Post Reply 




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