+- 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: Question re accessing Spreadsheet Cells (/thread-2653.html)
Question re accessing Spreadsheet Cells - bobkrohn - 12-18-2014 08:13 AM
to programmatically address a Spreadsheet Cell according to the User Guide:
"Spreadsheet.A1" would retrieve the contents of Cell A1
Is there a way to use a variable for the Cell reference?
Something like:
MyCellRef:="A1";
Spreadsheet.MyCellRef;
or
MyCol:="A";
MyRow:=1;
MyCellRef:=MyCol + MyRow;
Spreadsheet.MyCellRef;
Nice if the Function for getting or setting a Cell was:
X:=Spreadsheet.(Row,Col);
or
X:=Spreadsheet.Cell(Row,Col);
RE: Question re accessing Spreadsheet Cells - Snorre - 12-18-2014 08:55 AM
Yes, your last guess nailed it. Take a look at [Vars]>[App]>[Spreadsheet]>[Numeric]>[Cell]>[Help].
RE: Question re accessing Spreadsheet Cells - bobkrohn - 12-18-2014 10:04 AM
Oh thank you.
I was trying to find this stuff in the User Manual.
(where it only shows the "Spreadsheet.A1" format)
On page 424 it just shows "Cell" with no details.
There should be details.
I like to see examples too.
For example is input Row,Col or Col,Row
Of course you just experiment both ways. But still...
Just discovered that the new User manual is also loaded as part of the firmware update.
thanks again
RE: Question re accessing Spreadsheet Cells - Snorre - 12-18-2014 11:26 AM
Hello,
you should really look at the on-device help (it's -- despite some minor quirks -- very useful and always at your hand and made me almost never look at he manual). This will not only tell you that the order is (row, col) but also how to access cell formatting and all the other cool stuff you can do.
Greetings
RE: Question re accessing Spreadsheet Cells - bobkrohn - 12-19-2014 05:45 AM
As I am discovering, while playing with this new toy, there are features I need to become much more acquainted with.
What you pointed out is one of them. Thanks again. You have been very helpful.