Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

LibreOffice Calc Search

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.

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.

LibreOffice Calc Searchchange "search in" option to "values" permanently

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).

The 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.

click to hide/show revision 3
No.3 Revision

LibreOffice Calc change Can I set "search in" option to "values" permanentlypermanently in Calc's search toolbar?

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.