i find that when i setdataarray() into merged cells, the data goes in just fine but is sometimes not visible until after i click away from the sheet and back. so i am doing this for the moment:
with thiscomponent.currentcontroller dim sht sht = .activesheet .setactivesheet(some_other_sheet_object) .setactivesheet(sht) end with
which works. So i am wondering is there a .refresh() or .redraw() or any such method that would be appropriate?