Peter Eberlein schrieb:
Hi Niklas,
Niklas Nebel schrieb:
Laurent Godard wrote:
merging a cell range is quite easy
activeSheet = thiscomponent.currentController.activeSheet
range = activeSheet.getCellRangeByName("A3:B3")
range.merge(true)
btw, how can i merge also the datas of all merged cells so that they
are displayed in the merged cell (having A3 and B3 content in merged A3)
Read the text from cells A3 and B3, concatenate it, put it into A3.
Same for notes if you care about them. There's no separate API.
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?
oData() is a 2-dimensional array.
UBound( oData(), 1 )
or
UBound( oData() )
gives the upper limit of the first dimension,
UBound( oData(), 2 )
the second dimension. Access the single values with
for first = 0 to ubound( oData(), 1 )
for second = 0 to ubound( oData(), 2 )
... oData( first, second ) ...
next
next
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
