Welcome to the DevChannel

Posted by: c1_danb on 25 September 2017, 10:44 pm EST

    • Post Options:
    • Link

    Posted 25 September 2017, 10:44 pm EST - Updated 11 January 2024, 5:42 am EST

    The Spread DevChannel delivers pre-release previews of next version builds and hot fixes so you can get familiar with new features or take advantage of fixes without waiting for official release cycles. Check http://sphelp.grapecity.com/devchannel/ for a current list of builds.

    This forum is a place for you to give feedback, ask questions, and report issues you encounter while using these builds.

    We look forward to hearing from you.

  • Posted 25 September 2017, 10:44 pm EST

    Hi, thanks for opening this channel, so we can keep using the latest features and fix of spreadjs.

    I was thinking about a situation I still don’t know if spreadjs client side handles it or no. The situation is that i have an excel add-in with “custom async function”, so when this function used in formula on a cell “i.e: A2” the result is a couple of two values (X,Y) , X is written on the cell “A2” and the “Y” is written in the left of “A2” which means “B2”. As I know when I develop a custom async function with spreadJs, I use only the context.setAsyncResult(value), so I can see only the “X” in cell “A2”, any suggestion or solution for this case.


    Ismail bougnouch

  • Posted 25 September 2017, 10:44 pm EST


    Yes, you can create a custom function which evaluates asynchronously and returns an array of values, and reference that function in an array formula set to a range of cells. Like Excel, SpreadJS.Sheets will show the array values in the cells when the array formula is set to a range of cells matching the dimensions of the array returned by the function. I have attached a simple example for reference which returns the hard-coded array [1,2] in the ranges A1:B1 and A2:B2 . It should also work to use a web worker to implement the function




  • Posted 25 January 2018, 4:09 pm EST

    S’étant v reste

  • Posted 25 January 2018, 4:11 pm EST

    Halo commet tale vous

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels