I have a question about column deletion

I have a question about column deletion

Posted by: addio777 on 27 September 2018, 7:23 pm EST

• 

  addio777

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 September 2018, 7:23 pm EST

  Hi.

  Of the more than 300 columns, it takes more than 30 seconds to delete hidden columns.
  
  Is there a way to do it fast?
  
  I am using the Spread 10 version.

  for (int i = newSheet.ColumnCount - 1; i >= 0; i–)
  
  {
  
  if (newSheet.Columns[i].Visible == false)
  
  {
  
  newSheet.Columns[i].Remove();
  
  }
  
  }

  Thanks.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 30 September 2018, 4:35 pm EST

  Hello,

  We are unable to replicate the issue with the latest version of Spread 11.45.20183.0 wherein hidden columns are deleted quickly without any delay of 30 seconds or so.

  Hence, we request you to please test your case with the latest version once and also share a small working sample replicating the issue so that we can investigate this issue further.

  Thanks,
  
  Reeva

• 

  addio777

  • Post Options:
  • Link
    Copy

  Posted 30 September 2018, 5:06 pm EST

  Hi.
  
  Thanks for the reply.
  
  Is there a way to do it in Spread 10?

  Thanks.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 30 September 2018, 10:25 pm EST

  Hello,

  We are unable to replicate the issue at our end using Spread Win version 10.40.20174.0 on Win 10X64 bit machine.

  Please have a look at attached sample for the same and let us know what are we missing to replicate the issue.

  You can modify my sample to replicate the issue and send it back so that we can debug the same at our end and provide you with a fix.

  Thanks,
  
  Reeva
  
  SpreadWin_hidecolumns.zip