Welcome to the DevChannel

Originally Posted 21 June 2016, 7:35 pm EST

  • Originally Posted 21 June 2016, 7:35 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 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.
  • Reply

    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
  • Reply

    Hi,

    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
Need extra support?

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

Learn More

Forum Channels