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?
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
