Hi Marc

   Range(Foo).select
   If ActiveCell.MergeCells Then
   MergedInfo = ActiveCell.MergeArea
   MergedValue = MergedInfo(1, 1)
   End If


for Libreoffice basic
assuming a calc sheet, with some content in A1 and B1

Sub Main

        doc = thisComponent ' the current document
        curSheet = doc.CurrentController.activeSheet
        
        cellRange = curSheet.getCellRangeByName("A1:B1")
        
        cellRange.merge(true)

        if cellRange.isMerged then
                cellContent = cellrange.dataArray
        endif
        
        anArray = cellContent(0)
        print join(anArray, " ---- ")
        
End Sub

did you have a look there

http://wiki.openoffice.org/wiki/Documentation/BASIC_Guide
http://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide

i assumle you already identified this ressource (IDL reference)
http://api.libreoffice.org/docs/common/ref/com/sun/star/module-ix.html

HTH

laurent
_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Reply via email to