HP Forums
What's the equivalent of spreadsheet function Cell ()? - 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: What's the equivalent of spreadsheet function Cell ()? (/thread-10248.html)



What's the equivalent of spreadsheet function Cell ()? - mfleming - 02-26-2018 04:53 AM

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


RE: What's the equivalent of spreadsheet function Cell ()? - Didier Lachieze - 02-26-2018 05:19 AM

Cell is under Vars>App>Spreadsheet>Numeric


RE: What's the equivalent of spreadsheet function Cell ()? - cyrille de brébisson - 02-26-2018 05:56 AM

Hello,

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

Cyrille


RE: What's the equivalent of spreadsheet function Cell ()? - Tim Wessman - 02-26-2018 04:00 PM

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.


RE: What's the equivalent of spreadsheet function Cell ()? - Tyann - 02-26-2018 04:13 PM

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.


RE: What's the equivalent of spreadsheet function Cell ()? - mfleming - 02-26-2018 05:04 PM

(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!


RE: What's the equivalent of spreadsheet function Cell ()? - cyrille de brébisson - 02-27-2018 05:49 AM

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