Post Reply 
How to set Spreadsheet formula from string?
04-18-2016, 02:51 AM
Post: #6
RE: How to set Spreadsheet formula from string?
(04-17-2016 04:12 PM)Tim Wessman Wrote:  Remember that QUOTE( ) is also just the spelled out long form of ' ' found on the shift paren key.

Thanks for the clarification. I'm familiar with the behavior of quotes from my 48/50 days. I was trying to make the round trip from spreadsheet cell formula to string to file, then back again. I got stuck at the transform from string to formula prior to assignment to cell.

I'll use the quote form for transport in a program in the future, since pure formulas seem to get evaluated at inopportune times!

~Mark

Remember kids, "In a democracy, you get the government you deserve."
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: How to set Spreadsheet formula from string? - mfleming - 04-18-2016 02:51 AM



User(s) browsing this thread: 1 Guest(s)