Hello,
last year I have posted a question about navigating to a cell after editing. This was the issue "Navigation to another cell".
You proposed to use the function
ActiveGrid.CurrentCell.MoveCurrentCell(new Cell)
I did that and in most cases it works.
But when the cell that is edited is almost hidden or the cell where I would like to move to is hidden a call to MoveCurrentCell returns false and the new cell is not selected. Even if I use the call with the forceMove set to true the cell is not moved. This is the code I have used. The ScrollToView does not change anything.
RowColumnIndex rowColIdx = new RowColumnIndex(Sheet.ActiveGrid.CurrentCell.RowIndex + 1, 1);
this.Sheet.ActiveGrid.ScrollInView(rowColIdx);
if (Sheet.ActiveGrid.CurrentCell.MoveCurrentCell(rowColIdx, true) == true)
{
Debug.WriteLine($"NavigateToNextRow cell {Sheet.ActiveGrid.CurrentCell.RowIndex} and {Sheet.ActiveGrid.CurrentCell.ColumnIndex} done");
}
else
{
Debug.WriteLine($"NavigateToNextRow cell MoveCurrentCell returned false. Not moved");
}
Why does the MoveCurrentCell works only when the destination cell and the edited cell are visible?
How can I solve this? Because navigation is one of the key features this makes the app unusable for large sheets, therefore any help is highly appreciated.
Kind regards
Frank