how to allow sorting record in spreadsheet using perticluar column in window application

Posted by: sanjay18 on 8 September 2017, 2:15 pm EST

  • Posted 8 September 2017, 2:15 pm EST


    How to allow sorting record in spreadsheet using  sorting depend on perticular column that time spread is lock.but when we editable mode that time not allow sorting.that  time spread  is unlock. i want set flag on that perticular condition.using window application

    please reply me......


    Sanjay Chaudhari,



  • Replied 8 September 2017, 2:15 pm EST

    Hello Sanjay,

    You would not be able to edit a cell if the Spread is Locked. As per your requirement I would suggest you to turn AutoSorting off when you get into edit mode using EditModeOn event.Have a look at the code below,

            private void fpSpread1_EditModeOn(object sender, EventArgs e)
                fpSpread1.ActiveSheet.Columns[fpSpread1.ActiveSheet.ActiveColumnIndex].AllowAutoSort = false;

            private void fpSpread1_EditModeOff(object sender, EventArgs e)
                fpSpread1.ActiveSheet.Columns[fpSpread1.ActiveSheet.ActiveColumnIndex].AllowAutoSort = true;


    I hope it will help you.





Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels