Re: [libreoffice-users] searching in Calc does not find anything

At 09:48 07/06/2022 +0900, Thomas Blasejewicz wrote:
> For years Crtl+F and then entering numbers or words used to find 
> those, if they are in the sheets somewhere. For a few days now 
> trying to find anything, numbers, digits, words ..., ALWAYS gives me 
> "Search key not found", even if the item in question sits right in 
> the middle of the screen. I tried all sorts of settings and options 
> in the search box.

It may not be the Find box that matters. What Find options have you 
chosen? Do you have "Formatted display" or "Entire cells" ticked when 
you shouldn't - or not when you should?

Have you expanded "Other options" in the "Find and Replace" dialogue 
and considered those additional options? Something there may be 
affecting what will be found. For example:

o Do you have "Regular expressions" ticked when you instead mean your 
Find text to be interpreted literally and not as a regular expression?

o In particular, do you have "Search in:" set to Formulas (or even 
Comments) instead of Values? Values that you can see in your 
spreadsheet will not be found if you are searching instead in the 
formula or comment that may (or may not) be in that cell.

(There are other possibilities.)

> Apparently I am not smart enough to figure out what I am missing.

I don't think this is a question of being smart or otherwise - just 
perhaps unaware of something.

I trust this helps.

Brian Barker



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy