bme Newbie

Joined: 08 Mar 2005 Posts: 1
|
Posted: Tue Mar 08, 2005 9:36 am Post subject: cannot set UserDefinedAttributes for calc sheet |
|
|
Hi,
Being a newbie to OObasic and the Uno API I found myself strugling setting a "UserDefinedAttributes" property of a Cell. Here's my piece of code. Can someone please tell me what I' m doing wrong.
Dim userprop As Variant
oDoc = ThisComponent
oCell = oDoc.Sheets.getByName("name").getCellByPosition(0, 0)
color = oCell.getPropertyValue("CellBackColor")
userprop = oCell.getPropertyValue("UserDefinedAttributes")
MsgBox userprop.Dbg_methods, 64, "methods"
' this resonse with a bunch of methods containing at least the insertByName
' SbxVOID insertByName( SbxSTRING,SbxVARIANT);
Dim aname as Variant
aname = "yo"
userprop.insertByName("monkey",aname)
' now I recieve a "com.sun.star.lang.illegalArgumentException"
Thanks in advance.
bme |
|