SPILL values in FpSpread

SPILL values in FpSpread

Posted by: niels on 23 March 2023, 4:54 am EST

• 

  niels

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 March 2023, 4:54 am EST

  It is possible to show array values with { }
  
  There is FunctionAttributes.Spillable
  
  But can FpSpread display ‘SPILL’ values like Excel 365?

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2023, 12:42 pm EST - Updated 25 March 2023, 12:53 pm EST

  Hi Niels,

  You can display spill values in FpSpread control similar to the way it is displayed in the Excel. Please go through the following documentation link for more information regarding the same: *https://www.grapecity.com/spreadnet/docs/latest/online-win/WorkingWithDynamicArrayFormulas.html

  We have created a sample application for your reference that demonstrates the implementation. Kindly refer SpillArrayDemo.zip

  Thanks & Regards,
  
  Aastha

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 25 March 2023, 2:31 pm EST

  O wow, This thing is unbelievable good!
  
  Thanks Aastha.