HP Forums
spreadsheet app - Printable Version

+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: spreadsheet app (/thread-1203.html)



spreadsheet app - fabila - 04-30-2014 12:08 AM

Sorry for my English
I'm trying to make a program app based on the spreadsheet
when I try to get equations from within the program, these are evaluated correctly, but the cell It does not keep the equation.
How I can get the cell keeps its equations?

Code:

EXPORT spreadsheet ()
BEGIN
END;
START ()
BEGIN
A1:=12;
A2:=7;
B2:=A1+A2;
END;

the program is evaluated correctly, but if I change the values ​​of the equation spreadsheet is not re-evaluate


RE: spreadsheet app - Tim Wessman - 04-30-2014 01:44 PM

You are evaluating your expression, and storing the result of the formula into B2. You need to store the formula into the cell - not the result.

Use the ' ' marks to surround your expression to quote the formula.


RE: spreadsheet app - fabila - 05-01-2014 04:42 PM

than you tim

Smile