Apache OpenOffice Community Forum

Hi all,
I need to know, weather some cells of a spreadsheet are merged together or not.
If I define a range and look to isMerged or use getIsMerged, then I get TRUE, even if only the first two cells from ten cells are merged together.
Only if there are no cells at all merged, isMerged will be read FALSE.

Do anyone know about this - and how to work around? I'm using LibreOffice 6.1.4 and Windows7

Best regards,
VBandOoffice

See viewtopic.php?f=45&t=24234&hilit=merged+area.

Hello Lupp,

with the code from Villeroy (Sub fillMergedAreas(oRange, oRanges)) I only get all StartCells of merged cells correctly, but the range is not matching the real merged range.
If there are some unmerged cells between the merged ranges, I will not detect them.

Some Ideas why? - And how to get the real merged range?

Best regards,
VBandOoffice

In the attached file (selectMerged.ods) you find a function that returns the merged region of a start cell.
In fact the macro in that document selects all the regions. The code snippet in the other posting is faster since it does not do that.

My oops.

Hi all,

it works!

Thank you Villeroy!

Best regards to all,
VBandOoffice