How does gotoOffset work in LO Basic/Calc?

[kumiponi]

Hi, I’m not sure if this is a bug so I’ll ask here first. Sample code:

Sub PrintCursorLocation (cursor As Object)
    print cursor.getRangeAddress.StartColumn & ", " & cursor.getRangeAddress.StartRow
End Sub

Sub CursorTest
    Dim cursor As Object
    cursor = ThisComponent.CurrentController.ActiveSheet.createCursor()
    PrintCursorLocation(cursor)
    cursor.gotoOffset(2, 2)
    PrintCursorLocation(cursor)
    cursor.gotoNext()
    PrintCursorLocation(cursor)
End Sub

GotoOffset doesn’t seem to be doing anything. There is no error message either. According to the Open Office developer manual, it should move the cursor to the expected cell (C3 in this case) relative to it’s current location. GotoNext and others do move it. Am I doing something wrong?

I’m using LibreOffice 4.2.1.1 release version on Windows Vista.

[macroman]

Did anyone ever find a solution to this?? I’m having the same issue

Using LO Basic 5.0.3.2 on Windows 8

[librebel]

it works if you call cursor.gotoStart() right after createcursor().