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) Laurent -- Laurent Godard <[EMAIL PROTECTED]> - Ingénierie OpenOffice.org Indesko >> http://www.indesko.com Nuxeo CPS >> http://www.nuxeo.com - http://www.cps-project.org Livre "Programmation OpenOffice.org", Eyrolles 2004 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
