Ask Your Question

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

asked 2018-07-05 16:32:23 +0100

Rexleonis gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-06 22:11:18 +0100

hjek gravatar image

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.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-05 16:32:23 +0100

Seen: 487 times

Last updated: Jul 06 '18