At 13:38 04/06/2016 -0400, Vince Bonly wrote:
Using the Find&Replace feature in AOO 4.1.2 Calc, is it possible to
replace a formula, such as:
=SUMPRODUCT($D$343:$L391>100;$D$343:$L391<109)
with:
=SUMPRODUCT(_2016_Scores_Target_Vince>100;_2016_Scores_Target_Vince<109)
where:
_2016_Scores_Target_Vince
is a named array ($D343:$L391) ?
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.
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.
Do I need to enclose the formula within quotation marks, " " in the
Search&Replace dialog window?
No.
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?
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
