Calc - finding a value not a formula

users
#1

The default action of the find command in calc is to search Formulae not Values. I usually want to search for a value.
Is there a way to change the default action?
If not, is there a way to search values from the Find toolbar, without having first opened the Find dialogue and changed the "Search in" field to "Values". If I close the Find dialogue (and I haven't screen space to leave it open), then Find from the toolbar appears to revert to finding Formulae.

David Lynch

4.3.0.4 on Windows 8

#2

Hi David,

The default action of the find command in calc is to search Formulae not
Values. I usually want to search for a value.
Is there a way to change the default action?
If not, is there a way to search values from the Find toolbar, without
having first opened the Find dialogue and changed the "Search in" field
to "Values". If I close the Find dialogue (and I haven't screen space to
leave it open), then Find from the toolbar appears to revert to finding
Formulae.

In this situation, use the Edit > Find & Replace dialog where you may
select the search target : click "Other options" then select the
appropriate type in the "Search in" list.

#3

Looks like I didn't actually read your question. Sorry for the noise.