[libreoffice-users] Macro Dim Dialog and Control

Hi!

I'm experimenting with extended data types in Calc Basic. I found some
information about it, which only gave me two different examples without any
link or anything to the rest of the ”new” data types available, so I'm
searching the best I can, so far coming up with a few ideas that all failed.

Without the feature enabled I Dim everything as Object, for instance:
Dim oSheet As Object
Dim oCell As Object
Dim Col As Long, Row As Long: Row = 35 : Col = 42
Dim oDlg As Object
Dim oCtl As Object
oSheet = ThisComponent.getSheets().getByName("MySheet")
oCell = oSheet.getCellByPosition(Col, Row)
oDlg = CreateUnoDialog(DialogLibraries.Standard.MyDialogue)
oCtl = Dlg.getControl("MyComboBox")

With the extended data types enabled, the first two lines would rather look
like this:
Dim oSheet As com.sun.star.sheet.XSpreadsheet
Dim oCell As com.sun.star.table.XCell

This works, but what about oDlg and oCtl? Are there special data types for
them too? The documentation I've found so far doesn't give any hints at
all. I tried this:
Dim Dlg As com.sun.star.awt.XDialog ' No error here,
' but next line throws an error:
oDlg = CreateUnoDialog(DialogLibraries.Standard.MyDialogue)
' Error: No access to object.
'        Invalid usage of the object.
' Well, something like that, it's actually in Swedish.

I can still do Dim As Object and it works, but since I'm trying out the new
data types this isn't it…

Can anyone point me to some kind of reference manual for those new data
types?



Kind regards

Johnny Rosenberg

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted