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

Search and replace Formules

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


Joined: 15 Nov 2004
Posts: 2

PostPosted: Mon Nov 15, 2004 3:39 am    Post subject: Search and replace Formules Reply with quote

I am trying to search and replace a part of a formule, but I am doing something wrong probably, because the program does not replace it.

I have use the formule =If(B3=0;0;B3/$AB3) alot.
The last part $AB has to become $AF.
A search and replace won't work. I already checked if the option "Formules" was selected. I am using OOo 1.1.3.

I hope someone can help me out!

Already tnx!
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Mon Nov 15, 2004 5:03 am    Post subject: Reply with quote

Try finding \AB and check the Regular Expressions box.
Back to top
View user's profile Send private message
HenkN
Newbie
Newbie


Joined: 15 Nov 2004
Posts: 2

PostPosted: Mon Nov 15, 2004 6:45 am    Post subject: Reply with quote

Thanks! That did the trick!
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