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

  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.

• 

  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