I was populating the sheet with UDF and testing them in VS2010.
The array functions did not when I programatically populate the sheet.
THey do work when I enter them as an ArrayFormula.
I would make some functions test if they clobber anything, and make some options to
For example, returning an arbitrary length list of environment vars, or manipulating 3d tensors or
datasets makes the array formula function problematic.
For example, I have some applications to mung/manipulate lists of files in directories. I can't
call in advance the number of files returned for each directory.
i will review your citation above.
I did read up on Array Formulas. I think it will make a nice kind of tensor if i can
get the omitted regions to -auto-fill to flesh out co-variant and conta-varient (super and sub pre-scripted tensors).
i would put in some protection for oversized arrays being returned.
People are sending me data in spreadsheets for analysis and i'm working on how best to analyze their data.
Is there a programatic way to pre-define a region to call a UDF ?