[Solved] Select only blank cells

[Rajagopalanta]

Hi All,

Our organisation is in the process of Migrating from MsOffice to Open Office. I do face some difficulty in mimicing the ways we work with Excel (especially), but I'm working around.

Currently I have two questions, which I'm posting as two different posts.

1. Is there an equivalent option of Excel's EDIT->GOTO->SPECIAL in Open Office? Many a times I use the "blanks cells" and "visible cells only" option, especially when I have to paste only in blanks or grouped contents of the cell. I'm unable to find it in Open Office Calc, can you help me.

Thanks in advance for you help.

- Raja

[Villeroy]

Advertisement for SpecialCells
Download
Extract the oxt from the zip
Add the oxt to menu:Tools>Extensions...
Restart the office suite or all spreadsheets at least.

menu:Tools>Add-Ons>SpecialCells>Contents... [X] Blank Ranges

[Rajagopalanta]

Hi Villeroy,

Thats a very good tool... But I'm facing another problem.

Step 1: I copy a cell.
Step 2: Select a Range
Step 3: Select the blank cells in the range using the tool you provided.
Step 4: Paste Using Ctrl + V ----> This gives error stating "Insert into multiple selection not possible"

Any idea how to overcome this error.

- Raja

[Villeroy]

My tool only selects cells. Like most spreadsheets, Calc can not perform content related actions on multiple selections.
You can overcome this limitation with the help of filters.
menu:Data>Filter>Standard... <Column X> <-- is empty --> [OK]
Select the filtered cell range of blank cells and paste.
The filter together with a regular paste from clipboard should preserve the hidden cells.
Be careful: Drag&drop or Edit>Fill>Down will overwrite the hidden cells!

[Rajagopalanta]

Hi villeroy and others,

Thanks for your valuable time... It really helped me a lot.

- Raja