Thank you Brian!
On 6/5/2016 2:07 AM, Brian Barker wrote:
Yes. But you won't need to replace the formula, of course, just the
ranges it includes.
In the Find & Replace dialogue, click More Options and select Formulae
in the "Search in" drop-down.
Aha! You're correct, of course.
You may wish to tick Tools | Options... | OpenOffice Calc | View |
Display | Formulae, perhaps temporarily, in order that you can see
what is going on. In particular, depending on exactly how you perform
the replace, you may have to take care that multiple references to the
same range (as you have in your example) are all replaced. But it is
*not* necessary for formulae to be displayed for the process to work.
Yes; your suggestion will be a beneficial technique for me to implement.
This allows me to find my typos more quickly!
PS: When you looked up "replacing" in the built-in help text and saw
the sub-entry "cell content" and the explanation there of "Search in"
and "Formulae", what went wrong? Oh, or "Finding and replacing
formulas or values" in Chapter 2 of the Calc Guide?
When the Search resulted in None found, I should have then explored the
More Options in the dialog window.
Very good advise!
I will need to locate or re-download the/entire/ Calc Guide.
