How can I specify that an XLL function should spill?

Viewed 130

When creating an XLL using Excel's C API, how can I specify that a worksheet function defined in the XLL returning a range should spill?

I know that I can return an array by specifying 'Q' as the return type when registering the function with xlfRegister, but then I get a non-spilling array function.

Unfortunately, I did not find anything about that in Microsoft's documentation. (Yet it should be possible, since PyXLL supports it, and I guess they also use the C API to create their product.)

1 Answers

You need to specify the return array with the letter U (Xloper 12).

I haven't found any official documentation on this either.

Related