Programing questions about Spreadsheet App and PRINT.

[Marcus von Cube]

(11-22-2014 04:46 PM)rbiondi Wrote:  - The name of the column. I've tried Cell(0,i) but didn't work.
- The number of filled rows and columns (row and column count)?

You can access a row with the syntax A:A and SIZE(A:A) returns the number of values in the first column.

I couldn't find a way to access the column name, just the names of single cells can be accessed with A1(2). A1(-1) returns a list with attributes for a cell, A:A(-1) the same for the first column as a list of lists. (cf. Help->HP Apps->Spreadsheet->Spreadsheet Variables->Cell References and Cell.)

There seems to be bug in the Cell function: The notation Cell(1,1,n) works well while Cell(0,1,n) or Cell(0,0,n) seems to return 0 in any case.