Den 2011-03-04 17:56:12 skrev Niklas Nebel <niklas.ne...@oracle.com>:
On 04.03.2011 17:18, Johnny Rosenberg wrote:
Have been looking for it with Xray, but so far I didn't find anything
that I think does what I want.
What I want to do is to search for a cell. When I find it, I want it to
appear as the first row and the the first column. Let's say that I find
what I'm looking for in C7. Then I want the sheet to scroll so that it
appears like this:
C D E F G H I J…
7
8
9
10
11
12
13
14
15
⁝
Use the view's XViewPane interface. In Basic that's just
oView.FirstVisibleColumn = 2
oView.FirstVisibleRow = 6
Niklas
Thanks! Your answer eventually lead me to the following subroutine:
Sub Scroll(Col As Long, Row As Long)
ThisComponent.getCurrentController().setFirstVisibleColumn(Col)
ThisComponent.getCurrentController().setFirstVisibleRow(Row)
End Sub
Works like a charm!
--
Kind regards
Johnny Rosenberg
--
-----------------------------------------------------------------
To unsubscribe send email to dev-unsubscr...@api.openoffice.org
For additional commands send email to sy...@api.openoffice.org
with Subject: help
