CollapseToMergedArea (LibreOffice Basic)

API-documentatie

Beschrijving

[1]:

• Expands the cursor to merged cell ranges.
• Expands the current cursor range in a way so that all merged cell ranges intersecting the current range will fit completely. If the cursor does not point to any range with merged cells, it is left unchanged.

Opmerkingen

• Onderdeel van com.sun.star.sheet - Belangrijk!

Bronnen

• https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/XSheetCellCursor.html#collapseToMergedArea

Testen

Simpel beginnen - Dit geeft in ieder geval geen foutmelding:

sub test_01()

   o_cursor = ThisComponent.Sheets(0).createCursor()
   o_cursor.collapseToMergedArea()

end sub