💻 Software
OpenOffice: Delete rows based on cell value
Fresh5 days ago
Mar 15, 202641838 viewsConfidence Score0%
0%
Problem
I've got a rather large spreadsheet that I need to filter some rows out of. In the spreadsheet, all rows whose M-Column doesn't equal "on" must be removed. I applied a filter, and re-saved the document, but that kept the unwanted rows - how can I permanently delete these rows instead? So in this ex…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: OpenOffice: Delete rows based on cell value
Low Risk
Select a cell in Column M. Select all cells in the spreadsheet with Ctrl-A. Open the Data->Filter->Standard Filter menu. Set the first row of the filter so that Field Name is "Column M", Condition is "Not Equals" and Value is "on". Click OK to apply…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix