I am doing a data cleanse on some contact date. Once the record is completed and it meets certain criteria the helper column (column O) fill in the cell with either the word import or check.
I currently have 3000 records. I have added the auto filter to first row that contains the header.
Here is my issue. When I filer the data to only show rows with the word import, I can still see some which say check. This seems happen from row 273. Any know how to fix this?
Your automatic database range includes only 272 rows for some reason. Define a database range explicitly.
Hi there
It sounds like you’re encountering an issue with the auto filter in LibreOffice Calc. This can happen due to a few reasons:
There might be hidden characters or spaces in the cells that are causing the filter to not work correctly. Ensure that the cells in column O only contain the exact words “import” or “check” without any extra spaces or characters.
The filter range might not be correctly set to include all rows. Make sure the auto filter is applied to the entire range of your data, including all (at least your 3000) rows.
Of course there might be a bug in the version of LibreOffice you’re using. Updating to the latest version of LibreOffice might resolve the issue.
Check for Hidden Characters:
Select the entire column O.
Use the Find & Replace feature (Ctrl+H) to remove any extra spaces or hidden characters. For example, replace all spaces with nothing.
Reapply the Filter:
Remove the existing filter by going to Data > AutoFilter to turn it off.
Reapply the filter by selecting the entire range of your data (including all rows) and then going to Data > AutoFilter.
If the issue persists, you might want to try using a different method to filter your data, such as using a formula in a helper column to mark the rows that meet your criteria and then filtering based on that column.
If you have any further questions or need additional assistance, send a message to Copilot 