Re: [libreoffice-users] Search key working intermittently for values

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+unsubscribe@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