[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
OOO330m20(Build:9567)
OS:Windows 7 Ultimate
trivender
 
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
menu:Tools>Add-Ons>SpecialCells>Formattings...
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.x
User avatar
Villeroy
Volunteer
 
Posts: 27301
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 31 guests