OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Replace in a selection without changing the selection

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
denisv
Newbie
Newbie


Joined: 02 Jan 2006
Posts: 1

PostPosted: Sun Mar 05, 2006 11:23 am    Post subject: Replace in a selection without changing the selection Reply with quote

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.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Mar 05, 2006 4:28 pm    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group