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

[shimi]

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

1324654

6546987

6548796

(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:

1324654

6546987

6548796

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?

[Lupp]

(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?

[shimi]

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.

[Lupp]

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 @PYS . 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.

[shimi]

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

[PYS]

Hi

Find & Replace ▸unfold Other options▸Search in▸select Values

Regards

[shimi]

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

[PYS]

@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)…

[sotoraul]

like that but with function, search some text and show the row?

[sotoraul]

im trying something “simple” as find a text in a range of data and when it founds it, to show or display row in other place that i choose with a function. why is so complicated?