Ask Your Question

[Calc] How to search for values in formula results?

asked 2017-11-08 16:14:23 +0200

shimi gravatar image

updated 2017-11-08 19:34:53 +0200

I have one sheet (sheet1) with numbers entered into it, such as:




(each number is in it's own row, see attached example file)

And a second sheet (sheet2) with a formula taking values from the first sheet such that sheet2.A1=sheet1.A1 and so on. The contents of sheet2 is displayed to be the same as sheet1:




Searching for the string "6546" in sheet1 instantly finds the second cell. However, the same search fails on sheet2. Is there away to perform this search in sheet2?

edit retag flag offensive close merge delete


(Your "numbers" obviously are texts.)
You should provide all the relevant information with your question. In this case mainly: By what means did you serch?

Lupp gravatar imageLupp ( 2017-11-08 17:20:29 +0200 )edit

Actually they are entered as numbers, not as text (no ' at the start). I searched using the find toolbar that pops-up when you hit ctrl+f.

shimi gravatar imageshimi ( 2017-11-08 19:24:38 +0200 )edit

There is nothing like a number with 21 significant digits in Calc.
The "simple search" after Ctrl+F does not support the settings hinted by @pierre-yves samyn . However, you find an ikon linking to 'Find & Replace' in the 'Find Bar' (if it wasn't customized away). The default shortcut is Ctrl+H.

Lupp gravatar imageLupp ( 2017-11-08 19:28:20 +0200 )edit

I updated the question so it is more clear. I also added the example file now that I have enough karma to do so.

shimi gravatar imageshimi ( 2017-11-08 19:35:54 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-11-08 17:23:00 +0200

pierre-yves samyn gravatar image


Find & Replace ▸unfold Other optionsSearch in▸select Values


edit flag offensive delete link more


That works. Thank you. Is it possible to save this setting and/or make it work from the toolbar?

shimi gravatar imageshimi ( 2017-11-08 19:25:19 +0200 )edit

@shimi - AFAIK no, but this parameter is kept during the session (as long as you do no quit)

(if it is not changed by the user of course)...

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-11-09 07:33:25 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-08 16:14:23 +0200

Seen: 396 times

Last updated: Nov 08 '17