[Solved] Locate merged cells

Discuss the spreadsheet application

[Solved] Locate merged cells

Postby trivender » Mon Jul 09, 2012 10:00 pm

I have a sheet and some cells are merged in it but I dont know which cells are merged . Is there any way we can quickly find the cells that are merged.
Last edited by trivender on Mon Jul 09, 2012 10:21 pm, edited 1 time in total.
OpenOffice.org 3.3.0
OS:Windows 7 Ultimate
Posts: 26
Joined: Sun Jun 17, 2012 4:22 am
Location: New Delhi,India

Re: Locate merged cells.

Postby Villeroy » Mon Jul 09, 2012 10:10 pm

Download download/file.php?id=11048
Do NOT unzip and point Tools>Extensions... to this zip package.
Close the office or all spreadsheets at least.
Open your sheet and call
Search in the grouped list of cell format ranges for ranges with attribute <Merged>.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28668
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests