Posted 8 September 2017, 1:46 pm EST
Using Spread for Windows (C# 3.5 - Spread 4.0.3505.2008). Have a multiple row/ multiple column spread. A few of the columns I have set to unlock so that the user could make changes to the data. When the user either navigates to a different row (LeaveCell event where the row is not equal to the newRow) or the spread looses focus (Leave event) and there has been a change, I validate the data in the row being left. When errors are found, I display the error message or messages.
What I have not figured out is how to set the focus back to the row just being left. I tired fpSpread1.SetViewportTopRow, fpSpread1.SetViewportLeftCoumn, fpSpread1_Sheet1.SetActiveCell and setting the fpSpread1_Sheet1.ActiveRowIndex to the targeted row. The SetViewportLeftCoumn scrolls left-to-right but the row focus stays on the new row.