Question re accessing Spreadsheet Cells

[bobkrohn]

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

[Snorre]

Yes, your last guess nailed it. Take a look at [Vars]>[App]>[Spreadsheet]>[Numeric]>[Cell]>[Help].

[bobkrohn]

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

[Snorre]

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

[bobkrohn]

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.