Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.