Ask Your Question

Revision history [back]

Tested Find&Replace dialog on Win7 with Libre 6.1.0 and on MacOS HIgh Sierra with Libre 5.4.3.2 - 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.


Tested Find&Replace dialog on Win7 with Libre 6.1.0 and on MacOS HIgh Sierra with Libre 5.4.3.2 - 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.


Edited...

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.