Welcome to the DevChannel

Welcome to the DevChannel

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

• 

  c1_danb

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  i-bougnouch

  • Post Options:
  • Link
    Copy

  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

• 

  slawyer

  • Post Options:
  • Link
    Copy

  Posted 25 September 2017, 10:44 pm EST

  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

• 

  gmasaalawi

  • Post Options:
  • Link
    Copy

  Posted 25 January 2018, 4:09 pm EST

  S’étant v reste

• 

  gmasaalawi

  • Post Options:
  • Link
    Copy

  Posted 25 January 2018, 4:11 pm EST

  Halo commet tale vous