How to move focus to a specific cell ?

2 Answers 81 Views
Spreadsheet
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
Ian asked on 27 Jul 2023, 03:39 PM | edited on 27 Jul 2023, 03:52 PM

That's it. 

Just move the cursor, and the UI focus, to a specific cell.

Trying to implement the behaviour in the find/replace function, when the user clicks on a search result in the list, and the appropriate cell is highlighted.

 

 

2 Answers, 1 is accepted

Sort by
0
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
answered on 28 Jul 2023, 09:25 AM

OK - finally found it here:

https://docs.telerik.com/devtools/winforms/controls/spreadsheet/features/ui-working-with-selection#changing-the-ui-selection

Interesting way to select a cell:

'get a selection object

 Dim s2 = myControl.SpreadsheetElement.ActiveWorksheetEditor.Selection

'point it to a new cell.

 s2.Select(new CellIndex(1,2),false)

Suggestion: it would be helpful to provide a  simpler 'shortcut' method like:

myControl.selectCell(1,2)

 

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 31 Jul 2023, 02:11 PM

Hello, Ian,

I am glad that you have found a suitable solution for the scenario you need to cover. Indeed, the UI selection is the appropriate way to focus a specific cell.

The provided feedback is greatly appreciated. We will consider it in the future improvement of the control. Meanwhile, since RadSpreadsheet relies on the RadSpreadProcessing library, the available API depends on it.

If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
Spreadsheet
Asked by
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
Answers by
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or