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.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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