How to create a Custom Formula that returns an Array to fill in multiple cells

[qcurtemanjc]

Hello,

I am working on creating a new SPLIT formula but I am running in to an issue. I think I have followed all of the documentation correctly on how to create a custom formula that returns an Array, however no matter what I do, I always get a #SPILL! error when I call my function from the arraySizeMethod I have defined. I even return an ArraySize object where I have explicitly set the width/height to what it should be and it still gives me this error. Here is an example of what I am seeing: https://codepen.io/qcurtemanjc/pen/oNPedpB

Let me know if you need anything else from me, thank you!

P.S.
Can we also make the SimpleRangeValue class a public class like you guys recently did with ArraySize class? That class is needed to return the values as an array from the custom formula but I haven't been able to find it (I could have missed it as well so let me know if I'm mistaken) thanks!

[wojciechczerniak]

You have values in the cells around the formula so it cannot "spill" to them. Change '' to null should help with that

[qcurtemanjc]

I see, is there a possible workaround for the current time until SimpleRangeValue has been added as a public class?

[wojciechczerniak]

Looks like it's exported:

hyperformula/src/index.ts

Line 175 in f829f4c

SimpleRangeValue,

but not exposed on Hyperformula object. Should work with ES6 modules or some bundler/build system.

[AMBudnik]

Hi guys! We've already marked the issue with SimpleRangeValue at #1178 and will inform you as soon as we fix it.

[AMBudnik]

ps @qcurtemanjc I've just tested your code locally, and it works well. Here's the project zipped https://we.tl/t-Q4Z2GZES1G

[AMBudnik]

I just wanted to make a quick note that HyperFomula 2.4.0 has launched, and the issue #1178 is fixed.