How to search in multiple Calc files (sheets AND files)?

I have many Calc ODS files and I’d like to search all of them at once for a particular word and not one by one. Can this be done?

This can be done, but I don’t think LibreOffice provides a built-in way of doing it.

You can use a search program that supports indexing of LO documents, like Recoll or DocFetcher. Or if you’re comfortable using a shell, you could use also Unoconv or Pandoc to convert the files to plaintext and grep through them.

(If this works for you, please click on the ✓ to accept the answer.)