Ask Your Question

LO Calc: How do I define "search in values" as standard search option?

asked 2018-08-07 13:57:43 +0100

Tanlladwyr gravatar image

This exact question has been asked but not answered here:

Got the same problem and I can try to be more precise. I have a huge calc file with several tables. One of the table functions as source table, the others refer to it creating values out of formulae, like article numbers and price calculations with factors.

The content of a given cell is thus a formula and the output a value. However, using STRG+F to find an article number is not working.

Only after opening up the search dialog, then opening the advanced options, then selecting "values", then searching again is doing the trick. Repeat the process for every freaking search. Neither does it keep the setting for the next use nor did I find any possibility to define my search settings.

Is there any workaround or recommendation? MS Excel has the same problem, but you can change the settings in fewer clicks and it keeps the settings at least until you close the program.

Any help appreciated!

edit retag flag offensive close merge delete


Mike Kaganski gravatar imageMike Kaganski ( 2018-08-07 14:04:01 +0100 )edit

That bug report is two years old...

Tanlladwyr gravatar imageTanlladwyr ( 2018-08-09 13:50:16 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-08-10 17:47:24 +0100

updated 2018-08-10 22:21:01 +0100

Tested Find&Replace dialog on Win7 with Libre 6.1.0 and on MacOS HIgh Sierra with Libre - in both cases Dialog window keeps "Search in:" setting from previous uses, Values are kept as default choice during the whole session. After closing Calc - yes, Formulas is default choice again. I do not know why you experience different LO behavior, but as a workaround I suggest you can use your own macro for performing search in Values. I will add demo spreadsheet with mentioned functionality a bit later.


Here you will find a very simplified demo with macro, which performs search within Values. C:\fakepath\Search_values.ods

Feel free to ask, if assistance needed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-07 13:57:43 +0100

Seen: 144 times

Last updated: Aug 10 '18