Jerrod J Littleton wrote:
Can anybody tell me how to "Find and Replace" in Calc the Font and
color. I can only replace the exact words without regard to the font
and color. Once replaced the original font and color of the text
remains. Thanks!
I believe that in Calc you can only do this if you define font
attributes, including color, within a cell-style. You cannot do this for
direct formatting, either applied to an entire cell or applied to some
words in a cell.
Even then it will require more than one step.
Set "Search for Styles" on, select the style you want to search for in
the "Search for" box and then do a "Find All". This select only those
cells formatted with the style you want.
Set "Current selection only" on and set "Search for Styles" off. Set the
text you want to find and the text you want to replace. Then do a
"Replace All".
At this point only the fields where replacement has occurred will be
selected, which are also the fields that you want to be in your new
formatting.
So set "Search for Styles" on again, again select the style you want to
search for and the style you want to replace it with. Do a "Replace All".
Jallan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
