Can I set "search in" option to "values" permanently in Calc's search toolbar? [closed]

asked 2014-07-08 09:12:17 +0200

Ljiljan gravatar image

updated 2014-07-11 18:41:46 +0200

bencomp gravatar image

When using Search toolbar in LibreOffice Calc (not LO Search Dialog), default option to search in is "formula". However, I would prefer to use search "in values"... when open dialog and change it, it works but not for long. My tables contain both formulas, values and values that comes from formula (VLOOKUP).

How can I achieve that default option for "search in" is always "in values"?

ADDITIONAL INFO - the way I use search function: I press CTRL + F, type the phrase I want to find (usually number),press enter and then exit Search toolbar by clicking Escape.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-28 23:12:16.436931

Comments

What is your question? If you want to share tips and tricks, could you answer existing questions or create a question and answer combination?

bencomp gravatar imagebencomp ( 2014-07-10 21:25:22 +0200 )edit

I wanted to see can I change this behaviour? I don't want to change "search in" in "search dialog" every time I press CTRL + F. I want to select "search in values" and to keep this option selected while LO Calc is open. So my question was: how to achieve this?

Ljiljan gravatar imageLjiljan ( 2014-07-11 08:23:03 +0200 )edit
1

Can you edit your question and then reopen it (or the other way around)? Make sure you change the question from "LibreOffice Calc Search" to your specific question. Hope you didn't feel offended, as I didn't mean to. It just didn't look like you were asking for anything. Thanks!

bencomp gravatar imagebencomp ( 2014-07-11 08:54:16 +0200 )edit

Why is this question supposed to be "not relevant or outdated"? It's exactly what I was wondering for a long time.

Tilman gravatar imageTilman ( 2017-02-13 14:37:19 +0200 )edit

agree with Timan! The default search behauviour is absolutly annoying. Open the search bar with CTRL-F, type the text to search and LO Calc will notfind those cells that have formulas in it resulting to the exact search string (not tested for numbers). see also: https://ask.libreoffice.org/en/questi... or here: https://askubuntu.com/questions/60165... search should work that way, but it does

c-hartmann gravatar imagec-hartmann ( 2017-07-07 08:49:57 +0200 )edit