Andrew Douglas Pitonyak schrieb:
Turns out I had an example in my book that snows how to link.

Andrew Douglas Pitonyak wrote:

REM  *****  BASIC  *****
Option Explicit

Sub Main
 Dim oSheet
 oSheet = ThisComponent.getSheets().getByIndex(0)
 oSheet.link("file:////andrew0/home/andy/foo.csv", _
    "Sheet1", _
    "Text - txt - csv (StarCalc)", _
    "FIX,34,0,1,0/3/8/2/19/10", _
    com.sun.star.sheet.SheetLinkMode.NORMAL)
End Sub



Thank you very much, Andrew, it works, though I think the API is slightly cloudy in this respect. :-(

I understand that oSheet.link returns a Sheetlink, but it doesn't, when I initialize oSheet by

    oSheet = oDoc.getSheets().insertNewByName("Voodoo", 0)

I have to put it in 2 lines:

    oDoc.getSheets().insertNewByName("Voodoo", 0)
    oSheet = oDoc.getSheets().getByName("Voodoo")

This is bewildering behavior imho.

Regards, Volker

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to