HP PRIME: Can the Columns headers of a spreadsheet be changed from a program

[cyrille de brébisson]

Hello,

Cell(0,1):Cell(0,3)(8):=1

will not work for 2 reasons:
Cell(0,1):Cell(0,3)
is not recognized by the Spreadsheet app as a cell/range reference.
only name:name is (with name either a named cell name or a traditional cell reference).

Cell(0,3)(8) is also not recognized. the (8) only works when the stuff on the left is a variable that contains a list or matrix object.
In this care, the stuff on the left is Cell(0,3) which is NOT a variable but a function call that returns a list and {data}(n) is not a recognized syntax/operator in PPL.

In this case, you will indeed have to use a loop, sorry about that.

Cyrille