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

    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 The benefits of your GrapeCity account... 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. thanks, 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

    Regards, -Sean 2016/08/Custom2ValueFunction.html

  • 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