How to hide the blue rectangle of a dynamic array spill

How to hide the blue rectangle of a dynamic array spill

Posted by: niels on 17 May 2023, 8:38 pm EST

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 17 May 2023, 8:38 pm EST

  Can I hide the blue rectangle of a dynamic array spill

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2023, 6:35 pm EST

  Hi,

  This is a design behavior that a Blue Border appears to identify the CellRange for the Spilled array. This behavior exact same in MSExcel.
  
  However, we are discussing this requirement with the development team. Will get back to you once we have any update from them.[Internal Tracking Id - SPNET-30136]

  Regards,
  
  Nitin

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 21 May 2023, 7:24 pm EST

  Hi Nitin. Yes it is brilliant. I so much like this product.
  
  My end-user has no idea about dynamic arrays and spill range. And it makes for her/him no sense to see the rectangle.
  
  Thank you for discussing this with the development team.