Jump to active cell in UI?

[Soulstorm]

Hello everyone!

Is there a way to scroll to active cell in UI from codebehind? My spreadsheet contains big amount of data and needs some sort of navigation.

[Todor]

Hello,

You could use the RadWorksheetEditor's BringIntoView() method by passing the active cell index as the following code-snippet:

CellIndex activeCellIndex = spreadsheet.ActiveWorksheetEditor.Selection.ActiveCellIndex;
spreadsheet.ActiveWorksheetEditor.BringIntoView(activeCellIndex);

In order you desire to set the active cell index as top left index, you could use the following code-snippet:

CellIndex activeCellIndex = spreadsheet.ActiveWorksheetEditor.Selection.ActiveCellIndex;
spreadsheet.ActiveWorksheetEditor.UpdateToViewWithTopLeftCellIndex(activeCellIndex);

In addition, depending on your scenario, you could use the RadSpreadsheet's SetHorizontalOffset() and SetVerticalOffset() methods which offsets the viewport with a specific double value.

I hope this helps.

Regards,
Todor
Telerik

[Soulstorm]

Thanks a lot! It works great!