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


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

Context


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.