How to set Spreadsheet formula from string?

[mfleming]

Hi all,

Another spreadsheet question. I'd like to be able to assign the formula for a spreadsheet cell where the desired formula is in string form. For example, if the string is "=SUM(D1:D10)" and the target cell is D11, I can't just assign the string to Cell(11,4,1). Various attempts to use eval and expr have at best evaluated the expression and stored the result as a value.

I guess what I'm looking for is a function that will convert a string object to a function object. The reason for my interest can be found in the post "RTable: Load and Save CSV Files" here in the HP Prime Software Library forum.

Thanks,
~Mark

Oh yeah, a shout-out to Diego for his Flex-PCB. I'm trying to restore my first HP-41 - it's a great follow-up to the WP 34 project a little earlier!