input string was not in correct format - when drap and drop columns to move from one position to other

Posted by: tejashvini on 8 September 2017, 1:59 pm EST

  • Posted 8 September 2017, 1:59 pm EST


    private void fpSpread1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)


    {


    int Col = e.Column;


    int Row = e.Row;


    if (fpSpread1.Sheets[0].GetText(Row,Col) != "")


    fpSpread1.Sheets[0].SetValue(Row,Col,fpSpread1.Sheets[0].GetText(Row,Col).ToUpper(),false);


    }


     The line in bold is throwing the exception.

  • Replied 8 September 2017, 1:59 pm EST

    Hello,

    I tested the above snippet on a bound spread with AllowDragDrop set to True and did not get any exception on dragging the columns or range of cells in response of your above code in the LeaveCell event.Any additional steps I need to perform to replicate the issue at my side.

    Thanks

Need extra support?

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

Learn More

Forum Channels