04-16-2016, 02:18 AM
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!
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!