Hi Laurent,
Laurent Godard schrieb:
Hi Peter
btw:
oRange = ThisComponent.Sheets(0).GetCellRangeByName("a1:a3")
oData = oRange.GetDataArray()
msgBox uBound(oData()) ' gives me 2.
If I substitute the range with "a1:c1" the uBound of the array gives
me 0.
Any ideas?
yes
you'll have a variant for each row
then each row contains an array for each cell
so a1:c1 has only one row --> ubound 0
try a ubound(oData(0))
you'll have 2 (a,b, and c)
Thanks Laurent,
forgot that it has two dimensions :(
http://api.openoffice.org/docs/DevelopersGuide/Spreadsheet/Spreadsheet.xhtml#1_3_1_4_5_Data_Array
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
