In calc basic are there equivalents to VBA’s HorizontalAlignment, largeScroll and smallScroll?
Thanks,
Mike
This is an incomplete answer, just because I couldn't find VBA equivalents
doesn't mean they are not there. LO/OO is much too large a field for me to
say there are no equivalents.
However, I have found ways to shift the view of my spreadsheet.
The first is using selection. If the cell I want in view is off the page
simply selecting it will bring near center screen.
If it is already in view then selecting a cell out of view then back to
what I want center screen will do the trick.
I'm a lazy and lousy typist so taking Pitonyak's "oDoc = ThisComponent"
a little further, I've created a couple of sub/functions as so:
Function currentSheet
currentSheet = ThisComponent.CurrentController.ActiveSheet
End Function
Function cellRC( row as Long, Column as Long)
' generate a cell as in VBA, just for simplicity's sake
cellRC = currentSheet.GetCellByPosition( Column, row )
End Function
Sub objSelect(obj)
ThisComponent.CurrentController.Select(obj)
End Sub
With these it's easy to shift the view with "objSelect(cellRC(0,0))"
or objSelect(cellRC(100,100))" then back to what I wish to have midscreen.
That worked well but I ran across LO/OO's cursor commands in OOME p.506.
gotoStartOfUsedArea and especially gotoEndOfUsedArea.
The cursor is created like so:
oCurs = currentSheet.createCursor()
There are also cursor commands for moving about a range
gotoOffset(3,3), gotoStart, gotoNext, gotoPrevious, gotoEnd
Unfortunately for my purposes the cursor doesn't shift the view so after
getting the cursor where you want it it must be followed by:
objSelect(oCurs.getCellByPosition(0,0))
Finally I found this:
Sub positionView(row as Long, col as Long)
' https://ask.libreoffice.org/t/scroll-in-calc-via-api/13214
' by pierre-yves samyn
thiscomponent.currentController.setFirstVisibleColumn(col)
thiscomponent.currentController.setFirstVisibleRow(row)
End Sub
You have to calculate the offset from the edge of the view to what you
want center screen but that's likely to be trivial. In my case 4 columns
to the left of today's quotes puts today's quotes center screen
consistently.
Hope this helps somebody.
Be well,
Mike
A slight amendment, I found one situation where positionView() doesn't
shift the view. If the cursor or last selected cell is to the left of a
Freeze frame and the desired position is to the right the view doesn't
shift, don't know why.
The cell selection does shift the view as long as the selected cell is
out of view.
MM