I recently downloaded Libre Office to replace Open Office on my Mac.
All previously created documents now open with Libre Office - obviously.
I am having problem with the Search Key Function in my spreadsheets. I am using it to find amounts.
It seems to work
2 or 3 times then suddenly changes to "Search key not found”. I have closed and re-opened, opened
and it works and then back to "Search key not found". I have restarted computer, checked old
spreadsheets where it works again and then used again with another spreadsheet (where it worked before) but
still no luck.
Is this a bug?
Help please but not too technical! - thank you.
If there is only one occurrence of the search key, and the cell
containing it is already the active cell, Calc seems to display "Search
key not found". I guess that behaviour could be considered a bug, and
appears to be behind:
although the description there isn't particularly clear.
Alternatively, do you have formulae in the spreadsheet? Calc's search
can look for the search term either in the formulae themselves or in the
values (results of the formulae). I think the default is to search
within formulae, not values. This can be selected by going to Edit >
Find and Replace; enter your search term, then click "More Options" at
the bottom of the dialog and select the required option for "Search in".
For example, if you have a formula "=1+2" in a cell, the value of that
cell is 3 and:
- Searching for "2" in formulae would find that cell (the formula
- Searching for "2" in values would not find that cell
- Searching for "3" in formulae would not find that cell (the formula
does not contain "3")
- Searching for "3" in values would find that cell
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
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