Previous in Forum: Does Vista OS Include an Audio Recording Program?   Next in Forum: PIC16F877A vs MCU-8051
Close
Close
Close
10 comments
Rate Comments: Nested
Guru

Join Date: Sep 2006
Location: Western Pennsylvania, USA
Posts: 761
Good Answers: 9

Converting MS Office Docs to Open Office 3.2

01/18/2011 3:46 PM

After MS's "validation tool" screwing up again (twice with Office 2003 and now with Office 2007), I gave up and switched to Oracle's Open Office.

I have been playing with Open office for quite awhile now, but MS just pushed me over the limit, with this and the Vista Business machine prior to this new upgraded XP one.

So, is there an easy way to convert all of the docs over, without doing them individually?

Respectfully,

qaqcpipeman

Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Good Answers:

These comments received enough positive votes to make them "good answers".

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Guru
Hobbies - Fishing - New Member

Join Date: Jun 2008
Location: Raleigh, NC USA
Posts: 13529
Good Answers: 468
#1

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 4:17 PM

I've never done it, but it looks like you can go to wizards from the files pull down menu on upper left, then go to document converter and choose which documents to convert, including ms word.

__________________
Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. Ben Franklin
Register to Reply
Guru

Join Date: Jul 2008
Posts: 1688
Good Answers: 145
#2

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 5:11 PM

I'm sure macros can do it. I am just now getting started with open office macros. They have a few tutorials on the internet that cause confusion by including all sorts of advanced stuff (UNO services) without any comments or supporting information. It's amazing how some Linux topics can be documented as bad or worse than M$ or IBM documentation.

http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/Program_Overview is a rare find in that it first explains open office Basic in a VERY GOOD way. What you need to know is there and ORGANIZED WELL. They do not include extra mumbo jumbo that is either there to fill space or just because it came along with the clipboard copy.

http://www.oooforum.org/forum/viewtopic.phtml?t=57578 is a forum thread that has some useful macro code that will work with all images or all documents in a directory. The code suffers from very few comments and numerous uncommented lines that are copied from somewhere and don't do anything useful for the beginner trying to learn to code open office macros. (I was pretty good at M$ Office macros). But, with all its faults it does show the power of the macros.

If you wish to you could probably write your own macro to do what you want by spending a hour or two with the above information.

Also, if you don't get any other suggestions you might be able to find key words in the above links to help you google for a macro that already does what you want. Your request seems like one that should already have a macro posted for it somewhere out there in the big, wide Internet.

Bruce

__________________
Few things limit our potential as much as knowing answers and setting aside questions.
Register to Reply
Guru
Hobbies - CNC - New Member Popular Science - Biology - New Member Hobbies - Musician - New Member

Join Date: Dec 2008
Location: Canada
Posts: 3523
Good Answers: 146
#3

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 5:27 PM

There may be some useful links in this thread about "batch document conversion" although most of the comments are about other formats, the general tools and techniques should be there - comment #5 looks promising.

__________________
incus opella
Register to Reply
Guru

Join Date: Feb 2006
Posts: 1758
Good Answers: 6
#5
In reply to #3

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 10:34 PM

Sorry

This refers to Ubuntu Forums not to Openoffice

Register to Reply
Guru

Join Date: Feb 2006
Posts: 1758
Good Answers: 6
#4

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 10:31 PM

Open Writer.

Help or F1

Microsoft Documents

Converting all documents of a folder

Have a fine day

Register to Reply
Guru
Safety - Hazmat - New Member Safety - ESD - New Member Engineering Fields - Transportation Engineering - New Member Popular Science - Evolution - New Member Technical Fields - Procurement - New Member Hobbies - Target Shooting - New Member Popular Science - Cosmology - New Member Engineering Fields - Architectural Engineering - New Member Technical Fields - Marketing/Advertising - New Member Engineering Fields - Food Process Engineering - New Member

Join Date: Dec 2005
Location: Mariposa Ca
Posts: 5800
Good Answers: 114
#6

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 11:06 PM

What format are you trying to go to?

you can just keep working in 2003 doc format

the wiki is exceptional, the forum is full of very knowledgeable & helpful members

Here's some

Register to Reply
Anonymous Poster
#7

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 11:09 PM

So, is there an easy way to convert all of the docs over, without doing them individually?

1. Copy all the documents to be converted to a single folder.

2. Click on the first file in the list.

3. Holding the shift key, click on the last file in the list. This will select all the files.

4. Right click any file in the selection and from the menu select "open with..."

5. Select Open Office writer. This should open the selected files as Open Office files.

6. Save the files from Open office in the format of your choice or export them as PDF files.

7. When the transform is successful, delete the orignal MS .DOC files.

Register to Reply Score 1 for Good Answer
2
Guru
Panama - Member - New Member Hobbies - CNC - New Member Engineering Fields - Marine Engineering - New Member Engineering Fields - Retired Engineers / Mentors - New Member

Join Date: Dec 2006
Location: Panama
Posts: 4273
Good Answers: 213
#8

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 11:34 PM

Actually, there is no need to convert from MS *.doc format, since OpenOffice/LibreOffice can read all but the latest from MS without conversion (although you will see some weird formating changes, figures jumping around a bit, etc.). Open the *.doc document in OpenOffice, clean up the formating a bit, and save it as *.odt. Also works for Excel files and PowerPoint. You can not go the other way- if you want someone to read your OpenOffice document with an MS product, you have to save it as such (which OpenOffice also permits...)

Register to Reply Good Answer (Score 2)
2
Guru
Safety - Hazmat - New Member Safety - ESD - New Member Engineering Fields - Transportation Engineering - New Member Popular Science - Evolution - New Member Technical Fields - Procurement - New Member Hobbies - Target Shooting - New Member Popular Science - Cosmology - New Member Engineering Fields - Architectural Engineering - New Member Technical Fields - Marketing/Advertising - New Member Engineering Fields - Food Process Engineering - New Member

Join Date: Dec 2005
Location: Mariposa Ca
Posts: 5800
Good Answers: 114
#9

Re: Converting MS Office Docs to Open Office 3.2

01/18/2011 11:40 PM
Register to Reply Good Answer (Score 2)
Guru

Join Date: Sep 2006
Location: Western Pennsylvania, USA
Posts: 761
Good Answers: 9
#10

Re: Converting MS Office Docs to Open Office 3.2

01/21/2011 10:43 PM

I would like to thank everyone for all of the advice and guidance.

It looks like it will take awhile and some docs just do not wanted to be converted, but save themselves in RTF aas they were orginally sent to me (they have been few so far; maybe if they had been converted to word first, then they would convert to ODF).

The excel docs with macros needed security adjustments (Open Office seems a lot stricter with the rules here than MS Office)

Thanks again, and if I find any other quirks, I will post them.

Respectfully,

Register to Reply
Register to Reply 10 comments

Good Answers:

These comments received enough positive votes to make them "good answers".

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

Anonymous Poster (1); artsmith (1); BruceFlorida (1); cwarner7_11 (1); Garthh (2); Haajee (2); kramarat (1); qaqcpipeman (1)

Previous in Forum: Does Vista OS Include an Audio Recording Program?   Next in Forum: PIC16F877A vs MCU-8051

Advertisement