denisv
Newbie
Joined: 02 Jan 2006
Posts: 1
|
 Posted: Sun Mar 05, 2006 11:23 am Post subject: Replace in a selection without changing the selection |
 |
|
How can I perform a series of Find & Replace operations within a range of cells that I've selected, without Calc changing the selected range after each operation?
I'd like the range to remain the same, so that I can repace different cells without having to re-select the range after each replacement. |
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Mar 05, 2006 4:28 pm Post subject: |
|
|
Just a workaround for OOo2 only:
The name field on the left of the formula bar allows you to define a named range quickly. Select your range, type in some valid name (eg. "tmp", no spaces, no range-addresses, no special chars like +,-,",$). Retyping the name selects the name.
From time to time you may want to clean up those temporary names in the names-dialog (Ctrl+F3) |
|
