cancel
Showing results for 
Search instead for 
Did you mean: 
sideshot
Level 1
15 11 0 0
Message 1 of 3
512
Flag Post

SPREADSHEET.....help

HP Recommended
hp prime

Ok, so I know how to write data to spreadsheet cells in a program, BUT...how the heck do i loop and send values to subsequent cells?? Say I'm entering a column of values; A1, A2, A3, A4........A10....A20.

 

Is it possible?

 

Thanks guys.

0 Kudos
2 REPLIES 2
Tim_Wessman
Level 8
Level 8
747 744 121 185
Message 2 of 3
Flag Post
HP Recommended

Look at the "Cell" spreadhseet variable on how to directly access things in programming

 

Vars->App->Spreadsheet->Numeric->Cell

 

Press HELP on it to get all you need to know.

TW

Although I work for the HP calculator group as a head developer of the HP Prime, the views and opinions I post here are my own.
0 Kudos
Jan_D
Level 6
305 297 32 76
Message 3 of 3
Flag Post
HP Recommended

Most often it is as simple as this:

 

When you want to store 7.3 into cell C5 write:

Spreadsheet.Cell(5,3):=7.3

 

When you want to store the content of cell C5 into variable X write:

X:=Spreadsheet.Cell(5,3)

 

When you write and run the program when the Spreadsheet app is active ("Spreadsheet" is displayed at the top of the screen) it is easier and instead of Spreadsheet.Cell(5,3) you can simply write: Cell(5,3).

 

 

 

0 Kudos
† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation