[Solved] Locate merged cells
[Solved] Locate merged cells
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
OOO330m20(Build:9567)
OS:Windows 7 Ultimate
Re: Locate merged cells.
Download http://user.services.openoffice.org/en/ ... p?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>.
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice