Posted 8 September 2017, 2:29 pm EST
We are receiving an error on when Spread call ShowActiveCell:
Invalid row index specified (must be between 0 and 0).
Parameter name: row
Actual value was -1.
See call stack below.
at FarPoint.Win.Spread.SheetView.IsRowExpanded(Int32 row)
at FarPoint.Win.Spread.SpreadView.ShowCell(Int32 rowViewportIndex, Int32 columnViewportIndex, Int32 row, Int32 column, VerticalPosition verticalPosition, HorizontalPosition horizontalPosition)
at FarPoint.Win.Spread.SpreadView.ShowActiveCell(VerticalPosition verticalPosition, HorizontalPosition horizontalPosition)
at FarPoint.Win.Spread.FpSpread.ShowActiveCell(VerticalPosition verticalPosition, HorizontalPosition horizontalPosition)
We hide and lock the first row, then
Me.ActiveControl = SpreadSection
The horizontal scroll bar was visible.
However, we have no clue what else in the spread settings will cause this.
I noticed that if I unhide the row, it works fine.
Can you please shed some light?