How to remove filter in OpenOffice Spreadsheet?
Using the Remove Filter option you can remove the previously selected result.
To remove filter, follow the steps,
In the home tab, select Data Filter→Remove Filter
When the filter is removed from the cells, all the previously selected results will be erased.