Swap rows

Swap rows

Posted by: cyril.scandaliato on 7 February 2018, 2:27 am EST

• 

  cyril.scandaliato

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 February 2018, 2:27 am EST

  Hi,

  I work with spread COM 7.055.
  
  I note that when i want to swap data with SSSwapRange function (actualy i run several times the function for several rows), the operation is longer when i’ve a majority of hidden rows in my sheet.
  
  It is normal ? Can i do something to ?
  
  Best regards.
  
  Cyril

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 7 February 2018, 10:19 pm EST

  Hi Cyril,

  You can set the Redraw to false while calling the SSSwapRange function and then set to True once the method completes.
  
  http://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#prop623.html

  Thanks,
  
  Deepak Sharma