How to delete the entire raw base on a condition ? libreoffice calc

I have this huge file from (libreoffice calc) A to S cells, and I want to delete the entire raw in all file, base on two separate condition 1) if the raw has specific word or 2)if it less than 3 characters