The problem of the row index after sorting sheet

The problem of the row index after sorting sheet

Posted by: pasun2 on 30 January 2018, 9:48 pm EST

• 

  pasun2

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 January 2018, 9:48 pm EST

  I use “Spread Sort” and “DataModel changed event”
  
  There are some problems after sorting.

  After sorting, I modified the cell. anthor cell was changed by “DataModel changed event”.
  
  As this time DataModel and spread had different index.

  In the pic, I modified the Priority but “M” flag was marked to different location cell .
  
  Is there any solutions?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 31 January 2018, 4:41 am EST

  Hello,

  Use following method to get correct row index after sorting:

  
  fpSpread1.ActiveSheet.GetViewRowFromModelRow(1);
  
  

  Hope it helps.

  Thanks,
  
  Mohit