Posted 8 September 2017, 2:13 pm EST
System.IndexOutOfRangeException was unhandled by user code
Invalid row index: 1 (must be between -1 and 0).
I'm getting this exception while adding a row at the end of the sheet.
The sheet has 14 columns.
At the form load event I can successfully add a row to the sheet but when the user enters some data to any of the two columns in the row then I need to add a new row at the end and there i get this exception
Here is the code,
privatevoid fpSpreadSpareDetails_EditModeOff(object sender, EventArgs e)
if (fpSpreadSpareDetails_Sheet1.NonEmptyColumnCount >= 2 && fpSpreadSpareDetails_Sheet1.NonEmptyRowCount == fpSpreadSpareDetails_Sheet1.RowCount)
Farpoint for winfoms version 4.0.3510.2008
Thanks in advance.