How to get TREND formula to provide data based on selection

How to get TREND formula to provide data based on selection

Posted by: adisa.craig on 27 April 2022, 12:38 pm EST

• 

  adisa.craig

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 April 2022, 12:38 pm EST - Updated 3 October 2022, 9:18 am EST

  In Google sheets when using the TREND formula, I am able to select multiple cells and have the results go into them as seen in the attached image
  
  

  

  695×352 22.4 KB

  I was trying to replicate this behavior in spreadjs. but this is the result

  

  816×599 47.6 KB

  Is there a way for me to get the same behavior as in Google sheets?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 28 April 2022, 5:54 am EST - Updated 3 October 2022, 9:18 am EST

  Hi,

  For this, you need to enable allowDynamicArray flag. Please refer to the following code snippet and let me know if you face any issues.

  
  spread.options.allowDynamicArray = true
  
  

  Regards,
  
  Avinash