LibreOffice Basic - get reference to a second window and scroll it programatically

users
#1

Hello,I have a single LibreOffice Calc document opened in two windows (menu
Window->New Window). My document has different active sheets in each window.
The document contains a macro that scrolls the current sheet in the active
window to some position:
Sub
ScrollSheetThisComponent.getCurrentController().setFirstVisibleRow(10)End
Sub
If I put a button that executes the macro and if I press it on the first
window then it scrolls the sheet in the first window. How to get a reference
to the second window and scroll its active sheet? I need something like
this:
ThisComponent.getWindowByIndex(1).getCurrentController().setFirstVisibleRow(10)
Thank you!