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) ?
If this is possible, then doing so would save me huge amount of retyping
and perhaps also allow me to move the resulting array to another
location/sheet.
Do I need to enclose the formula within quotation marks, " " in the
Search&Replace dialog window?
Regards,
VinceB.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org