Ask Your Question
1

CALC - how to search entire sheet, not just current page

asked 2016-11-10 06:08:07 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a spreadsheet with several pages that have data, any one of which might contain the item I am looking for. The Find function only seems to search the current page, and it is a pain to have to run the same search on each page, instead of being able to search all of the pages at the same time. Is there a way to make CALC search all the pages?

(I have looked and can't find any addins to do this, or anything in the docs about it - I may have missed something - pointers to correct info are also useful...)

Thanks, ART

edit retag flag offensive close merge delete

Comments

Many thanks - looks like a major part of my problem is a need to upgrade - I'm currently running LO 4.2.8.2 - and don't seem to have the options mentioned, but it is the latest option offered by the Kubuntu 14.04 LTS version I'm running - will be looking at downloading latest directly from the LO site later tonight.

ArthurT gravatar imageArthurT ( 2016-11-16 06:56:26 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2016-11-10 07:39:30 +0200

pierre-yves samyn gravatar image

Hi

You can either:

  • Select sheets in which you want to search (Ctrl+Click the tabs) then EditFind & Replace
  • Or, in this dialog, tick All sheets

Regards

edit flag offensive delete link more

Comments

Thanks very much!

fernandokosh gravatar imagefernandokosh ( 2018-05-08 21:22:26 +0200 )edit
0

answered 2018-03-02 00:11:45 +0200

updated 2018-03-02 00:20:31 +0200

To search all sheets you must use the "Find and Replace" pop-up dialog instead of just the simple find box at the bottom of a sheet.

To open the "Find and Replace" dialog, use Ctrl + H, or "Edit" --> "Find and Replace", then check the box for "All sheets".

Done!

You can also Ctrl + Click or Shift + Click tabs to select just the tabs you want to search, then do a regular Ctrl + F "Find", as answered by pierre-yves-samyn here.

edit flag offensive delete link more
0

answered 2016-11-10 08:41:30 +0200

LibreOffice 5.1 answer.

Just to complete the previous answer:

  • If you select Edit > Find... or Ctrl+F, a toolbar appears below the sheets. You should switch to Find & Replace... clicking the icon just after Match Case option in that toolbar. Anyway, it is easier to go directly to Edit > Find & Replace... or Ctrl+H.
  • In the Find & Replace dialog, you should activate Other options, and tick Search in all sheets.
edit flag offensive delete link more

Comments

1

Hi @asiersar

No need to activate other options since 5.2 see Release Notes

Regards

pierre-yves samyn gravatar imagepierre-yves samyn ( 2016-11-10 08:46:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-11-10 06:08:07 +0200

Seen: 13,429 times

Last updated: Mar 02 '18