I am seeking suggestions of how a callable (usually output from LAMBDA, though I have also implemented other ways of generating them) should be displayed in a cell. I know Google Sheets displays an #N/A error (even though the cell has a valid non-error value), which, when selected, tells you that you need to call the function if you want to see a result. I don't know what Excel does, as I don't have Excel. I'm thinking that there could be reason to not choose something that could potentially be entered as text in a cell (to avoid confusing users), but I have no ideas beyond that. Can anyone offer input, or could a Power That Be offer a Decision?
Thanks, Ben P.S. If anyone could also point me to the code that actually does the cell drawing, I would appreciate it. Would it be somewhere in the document shell code? Currently (in my build) a LAMBDA cell looks blank.
