Man do I feel stoooopid! Months ago I created a filter for my spreadsheet and now I can’t remove it!
The picture below shows the sheet with the fllter for “place == sh”. I know the other records are in there somewhere (e.g., E6 == “Self View”) but I cannot find a menu function to clear this filter.
Many thanks!
Version: 7.0.1.2
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: sv-SE (en_US.UTF-8); UI: en-US
Calc: threaded
Incorrect answer. Thanks @BigRAl. Moving as comment until you read it. You can delete it also.
Choose menu Format - Conditional - Manage…, select the conditional format and Remove it.
“Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range.” (LibreOffice Help on Manage Conditional Formatting).
Have you tried with menu Data - More Filters - Reset Filter? Also, if you select all rows and choose menu Format - Rows - Show you can see all of them again.
Add Answer is reserved for solutions.
Press edit below your question if you want to add more information; also can comment an answer.
Check the mark (
) to the left of the answer that solves your question.