HP PRIME: How to change the column headers and reset data


Hi Friends,

I am programming in HP Prime for Numeric Methods,
Created and App from Function App,
The results of iterations send to Spreadsheet,
But there appears 2 problems, and

I need to know: FROM AN APP PROGRAM...

1.- How reset the data from past iterations?
only fill with "" all spreadsheet and I like to clear or RESET it.

2.- How to chage the original column titles OF ROW 0 (A, B, C) for my own titles (iteración, a, b, p, f(p)...etc) ?

Without these features, I created the best format to show the data (se screen capture below), but it would be better.

Thanks in advance,



1) Reseting is a good question! There is no 'special' function to clean completely a cell, however there is a trick.
An "empty" cell in the spreadsheet is one that contains/has a value of a 'special' 0. A 0 which is tagged in the system to mean: spreadsheet empty.
so, to clear a cell, try doing Cell(r,C,-1):=AA1000 (AA1000 is taken here as an example of a cell that contains no data, hence contains the special 0)... this will store that special 0 in the cell of your choice, hence erasing it.

There is unfortunately no way to erase all cells at once...

2) Sorry, I have no answers for you on this one... there is honestly no way that I can find to do it.



Hi Cyrille,

Thank You so much,

Clearing the cells will help a lot to show better and right iterations.

Again, thanks for the answer... Some day It will possible to do the 2nd issue,

Have a nice day.




Cell(1,1,-1):=AA1000 works fine, even
Cell(0,0,-1):=AA1000 works fine clearing all data in the Spreadsheet.

BUT FROM INSIDE THE PROGRAM: stops the execution.
Spreadsheet.Cell(1,1,-1):=AA1000 doesn´t work
EXPR("Spreadsheet.Cell(1,1,-1):=AA1000"); doesn´t work

I think the code for using the special 0 would be reviewed.

Best regards!!



I seem to understand that when your program runs/is compiled, Spreadsheet is not the current app.
if this is true, did you try:




Hi Cyrille,

That works GREAT !! Thank You.

If some day You know how to change the column titles please post it here, thanks.

Best regards!!


Possibly Related Threads…
Thread Author Replies Views Last Post
  HP Prime reset to factory state? BruceH 3 4,991 11-26-2013, 07:27 PM
Last Post: BruceH
  HP Prime - Reset methods bluesun08 3 3,250 11-21-2013, 09:49 AM
Last Post: Joe Horn
  HP Prime: How do I insert/delete a column/row in a spreadsheet ? Michael de Estrada 3 2,275 11-20-2013, 10:01 PM
Last Post: Michael de Estrada
  Sheet data importer for HP Prime Marek Russ 4 1,855 11-15-2013, 04:55 AM
Last Post: debrouxl
  Program to change entry mode on Prime Michael de Estrada 3 1,902 10-28-2013, 10:13 AM
Last Post: Han
  Entering,Saving,and Analysis /Fitting X Y Data on the Prime Harold A Climer 6 2,489 10-26-2013, 01:54 PM
Last Post: Tim Wessman
  Explaination on How to Reset Caculator in Users guie: error Harold A Climer 5 2,564 10-15-2013, 02:11 AM
Last Post: cyrille de Brébisson
  RESET App from a program. Joseph Ec 0 938 10-14-2013, 12:28 PM
Last Post: Joseph Ec
  Leading 0 change? Tim Wessman 12 3,133 10-07-2013, 12:11 PM
Last Post: Katie Wasserman
  HP Prime data sharing Alberto Candel 5 1,827 10-06-2013, 07:49 PM
Last Post: Alberto Candel

Forum Jump: