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

[Solved] A simple Macro

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


Joined: 30 Apr 2009
Posts: 17

PostPosted: Thu Feb 09, 2012 10:02 pm    Post subject: [Solved] A simple Macro Reply with quote

As I can't seem to find a Search and Replace function I took a look at a Macro. What I want to do is very simple, replace one word with another in a cell. My data has French alphabet characters which I can't get displayed properly. So I have had to insert key codes order to get them to show properly. For instance "Québec" comes up as "Qu?bec". I would like a simple macro to step through exchanging the listed Qu?bec with the proper Québec..

I don't want to and simply can't write a bunch of code to do this. And having to fish down through a series of menus to get at the macro is a bit awkward. By the time I get to the macro I could have done it by hand.

Is there a simple solution?

Any help would be appreciated.
Back to top
View user's profile Send private message Visit poster's website
qaz1qaz1qa
Power User
Power User


Joined: 21 Jan 2012
Posts: 68

PostPosted: Thu Feb 09, 2012 10:11 pm    Post subject: Reply with quote

You mean the crtl+f does not work?

and Québec shows up just fine on my machine
Ariel font

Additionally make sure you are not some how stuck in ASCII characters.
_________________
OO 3.3 XP
Back to top
View user's profile Send private message
elder73
General User
General User


Joined: 30 Apr 2009
Posts: 17

PostPosted: Fri Feb 10, 2012 10:11 am    Post subject: Reply with quote

qaz1qaz1qa wrote:
You mean the crtl+f does not work?

and Québec shows up just fine on my machine
Ariel font

Additionally make sure you are not some how stuck in ASCII characters.


Thank you for your reply. It is in ASII characters, what should I be using?
Back to top
View user's profile Send private message Visit poster's website
qaz1qaz1qa
Power User
Power User


Joined: 21 Jan 2012
Posts: 68

PostPosted: Fri Feb 10, 2012 9:41 pm    Post subject: Reply with quote

Might be as simple as changing your font.
Try Insert > Special Character. and see if you have character 232 and 233. Not sure which one you actually need.

Page through the fonts and see which ones do not have them and perhaps avoid those.
All but 2 of mine have them.

After that A dev will need to help you.
Resubmit your question asking about being stuck with ASCII characters and how to expand or something along those lines. IF this is not the problem.
_________________
OO 3.3 XP
Back to top
View user's profile Send private message
elder73
General User
General User


Joined: 30 Apr 2009
Posts: 17

PostPosted: Sat Feb 11, 2012 7:50 pm    Post subject: Reply with quote

qaz1qaz1qa wrote:
page through the fonts and see which ones do not have them and perhaps avoid those. All but 2 of mine have them.


What I am doing is importing a CSV file into the OO spreadsheet. The CSV is a text file and am not sure whether that made any difference as it is a text file. I am currently using Arial on the spreadsheet. Your pointer to the Alt-F key, has saved the day. I was able to correct all the missing French letters quickly. I searched for the code of the letter, with the actual letter as the replacement. Asked it to show all the occurrences, checked them and then replaced.

Once again, Thank you for your help.
Back to top
View user's profile Send private message Visit poster's website
qaz1qaz1qa
Power User
Power User


Joined: 21 Jan 2012
Posts: 68

PostPosted: Sat Feb 11, 2012 9:51 pm    Post subject: Reply with quote

AHA! Thats your problem's start. The Csv was saved in ASCII I bet.

Well Glad you Find a solution to fix it.
BTW it seems it is becoming a common keyboard short to most programs now days to use Ctrl+F to initiate FIND. Some separate replace with Ctrl+R

Just put a little [Solved] in the first post's subject by editing your original post. This helps others know you got a solution.
_________________
OO 3.3 XP
Back to top
View user's profile Send private message
elder73
General User
General User


Joined: 30 Apr 2009
Posts: 17

PostPosted: Sun Feb 12, 2012 9:14 am    Post subject: Reply with quote

qaz1qaz1qa wrote:

AHA! Thats your problem's start. The Csv was saved in ASCII I bet.

Just put a little [Solved] in the first post's subject by editing your original post. This helps others know you got a solution.


Yes it is solved and I figured the CSV files text was the problem. I could not figure out a way to use a more friendly text for that file.

When entering data with an English keyboard, the user would still have to use key codes to get the appropriate French letter. Years ago I used a keyboard that carried the French characters which was kind of neat at the time as I was using those characters more than I am now.

Thanks again for your help. Laughing
Back to top
View user's profile Send private message Visit poster's website
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