Remove Blank Cells

Tags: Calc

last edited: 2023-01-24

Removes blank cells in a selected range.

Description

This extension allows to remove blank cells in various situations:

Single column: When a single column is selected, all empty cells in that column will be removed.

Single row: When a single row is selected, all empty cells in that column will be removed.

Blank rows: When a range with multiple rows and columns is selected and the user chooses this option, all blank rows in the range will be removed.

Blank columns: When a range with multiple rows and columns is selected and the user chooses this option, all blank rows in the range will be removed.

Blank rows using a reference column: With this option you can define a single column that will be used as reference to decide if the entire row will be removed or not.

Blank columns using a reference row: With this option you can define a single row that will be used as reference to decide if the entire column will be removed or not.

Getting help:

More information can be found at the extensions Help page.

Reporting bugs:

In case you find any bugs, please report them as issues at the extension's Github page.

Homepage: https://github.com/rafaelhlima/remove_blank_cells

Repository: https://github.com/rafaelhlima/remove_blank_cells/tree/main/Source

Release List

Release: 0.9.1 – First release

Release: 0.10.0 – New modes of removing rows and columns