Get better way to delete range area

Get better way to delete range area

Posted by: 122368177 on 13 July 2020, 6:00 am EST

• 

  122368177

  • Post Options:
  • Link
    Copy

  Posted 13 July 2020, 6:00 am EST

  Hi,How can I delete ranges not cols or rows?
  
  Now，I create custom command, I delete range shift left,sheet data setValue (row,col-offsetColCount),
  
  but maybe cause conflict with merged spans, span also need to get offset count to removeSpan,next addSpan(row,col-offsetColCount,rowCount,colCount)

  however, undo operation annoyed me，
  
  do you have better way ,thanks~

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 14 July 2020, 10:03 am EST

  Hi,

  We are working on this and will share an update with you soon.

  Regards

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 15 July 2020, 5:14 am EST

  Hi,

  Please refer to the following sample which demonstrates how we could create a custom command to delete range and shift cells:
  
  https://codesandbox.io/s/lingering-dust-ng7jd

  Regards