Ask Your Question

Multiple Sheet Searches in Calc [closed]

asked 2020-09-06 03:30:30 +0200

HerCorns gravatar image

I have seven sheets with names and id numbers in one Calc file. If I run a search on either name or id number I would have expected calc to find it in any of the sheets, but I have to manually go to each sheet and do the search.

However, taking a look at the search results window's tabs [Sheet][Cell][Content] it surely should be possible.

What am I missing?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by HerCorns
close date 2020-09-09 16:21:27.965647

1 Answer

Sort by » oldest newest most voted

answered 2020-09-06 05:21:15 +0200

Edit -> Find and replace, mark All sheets

edit flag offensive delete link more


Okay, this worked. Now, for the question. Why if I click on edit Find enter the search field and click Find All it only return the values for the sheet you are in. Should it not return the search results of all the instances in the calc file's sheets? Edit -> Find and Replace -> all sheets works, but it's illogical if you are only searching to go to find and replace.

HerCorns gravatar imageHerCorns ( 2020-09-06 06:19:17 +0200 )edit

Question Tools

1 follower


Asked: 2020-09-06 03:30:30 +0200

Seen: 78 times

Last updated: Sep 06 '20