Ask Your Question

How can change the default option for Find & Replace "search in" to be "values"?

asked 2016-02-12 21:35:52 +0100

J SIZEMORE gravatar image

updated 2020-08-16 12:15:51 +0100

Alex Kemp gravatar image

How can change the default option for Find & Replace "search in" to be "values" for Calc?

edit retag flag offensive close merge delete


I would love to hear the answer for this one. I have googled this multiple times, and I finally am commenting on this. :-) Thumbs up for asking. Where would it be possible to find the answer?

I have looked in the Libre Office Calc options, but there are no defaults there. I guess we will need to hack into the search function somehow. I will tinker around a bit more about this.

gnowak gravatar imagegnowak ( 2018-02-08 08:29:46 +0100 )edit

Please comment on this issue if you want this functionality to be implemented: tdf#102615

And add yourself to the CC list.

gnowak gravatar imagegnowak ( 2018-02-08 08:45:18 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-02-10 10:05:35 +0100

mkostrem gravatar image

This is the one problem in LibreOffice I've never been able to find an answer to. How I'd love to be able to change the default Find and Find/Replace settings to search Values rather than Formulas!

edit flag offensive delete link more


You can't find an answer how to do something that is not implemented: tdf#102615.

And what you "answered" is not a solution to the question... so should not had been posted as answer.

Mike Kaganski gravatar imageMike Kaganski ( 2020-02-10 10:09:41 +0100 )edit

Yes, thank you for posting!

gnowak gravatar imagegnowak ( 2020-02-12 09:13:13 +0100 )edit
Login/Signup to Answer

Question Tools



Asked: 2016-02-12 21:35:52 +0100

Seen: 197 times

Last updated: Feb 10 '20