Programing questions about Spreadsheet App and PRINT.

[Han]

(11-22-2014 07:05 PM)Marcus von Cube Wrote:  You can access a row with the syntax A:A and SIZE(A:A) returns the number of values in the first column.

Very cool (need to write this down for my own benefit), but there seems to be something odd with this. If column A has cells 1 through 3 filled, and column B is blank, then B:B returns {0,0,0}. The behavior seems to suggest that this gives you a list whose size is the size of the longest column, and all other columns are internally filled with 0 where needed to form a similarly sized column. (The same goes for rows using $2:$2 to refer to row 2)

Quote: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.

I was not familiar with the Cell(x,y,z) notation. It seems that Cell(1,2,3) is equivalent to A2(3). I think that Cell(x,y,n) where x=0 or y=0 doesn't return anything because there's no corresponding row 0 or column 0. For example, Cell(1,2) is the same as A2. So Cell(0,1) would refer to column 0 and row 1 (which isn't a valid cell). Maybe one of the developers can weigh in on this.