WEDLOCO wrote:
Hi there
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 another spreadsheet
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.
Evie.
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:
https://bugs.freedesktop.org/show_bug.cgi?id=36800
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
contains "2")
- 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
Mark.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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