Obsession Massage

Open Office... How compatible is it with MS Office?

Don

Active member
Aug 23, 2001
6,288
10
38
Toronto
How compatible is it with MS Office? I bring my work home a lot and I have Excel, World, Power Point docs I'd like to with. Can I actually use Open Office to work with them or will I have formatting issues that will make it not worth it to deal with?
 

AnimalMagnetism

Self Imposed Exile
Apr 21, 2006
3,744
0
36
Toronto
How compatible is it with MS Office? I bring my work home a lot and I have Excel, World, Power Point docs I'd like to with. Can I actually use Open Office to work with them or will I have formatting issues that will make it not worth it to deal with?
to my knowledge it is completely compatible. i have not heard of any problems with current releases
 

guelph

Active member
May 25, 2002
1,500
0
36
77
How compatible is it with MS Office? I bring my work home a lot and I have Excel, World, Power Point docs I'd like to with. Can I actually use Open Office to work with them or will I have formatting issues that will make it not worth it to deal with?
documents and spreadsheets very compatible

Powerpoint animation is different -- presenation is compatible but the animation is gone
 

danibbler

Active member
Feb 2, 2002
2,269
0
36
Toronto
To my knowledge it's not, my livelihood depends to some extent on being totally compatible with MS Word and I've had issues before. If there is a lot of formating and/or templates involved, I wouldn't take the risk that your workplace will point the finger at OO.
 

Lagavulin2

Taking the Red pill
Jan 5, 2010
403
1
0
Looked at Open Office many times.
There are formatting issues. Headers and footers are a problem, lines and graphics are a problem, numbered lists have issues.

If format is critical it is not worth the aggravation. We look at it every 6 months to a year and it never works clean. So we stick with M$.

BTW: M$ 2010 full professional version in BETA is free from Microsoft until October. We've been using that and are satisfied, but it means come October having to buy the licenses.
 

danibbler

Active member
Feb 2, 2002
2,269
0
36
Toronto
Not sure about them moving over to a new file format but MS has released upgrades to their older software in order to maintain forward compatibility.
 

larry

Active member
Oct 19, 2002
2,070
4
38
I just tried to use OO as a home version of the work MS Office. Very bad feeling. I don't do much. Just word and excel. But when i opened word and click-clicked a doc file that i usually use to start mail-merge and it didn't work! I gave up. Immediately. Bought MS Office Home and works fine. MS Office 2010 upgrade will be a free download when it is released.

If I were only using OO, that would be fine. But the two, I wouldn't do it.
 
you can get it to work flawlessly compatible, but you have to look into the open source software coding and know how to change it to work as you wish... everything is only a search away... but, there is some programming involved.

I find the biggest stock incompatibilities are with the presentation programs, but word and writer work very well together.

I keep OO and a couple other important OpenSource software programs (content management, graphics, photo/video editing) on a USB stick so that I can use it anywhere there's a computer.
 

larry

Active member
Oct 19, 2002
2,070
4
38
you can get it to work flawlessly compatible, but you have to look into the open source software coding
i can see a few smarties doing this. i can't see the general population ever being capable. so we're back to..out of the box, it's not. I know MS Office Professional costs a lot, but Home was only $150 for 3 licenses. Depends on how serious you areor your need is.
 

Anynym

Just a bit to the right
Dec 28, 2005
2,961
6
38
As mentioned above, there are a lot of things which can be easily transferred between MSOffice and OpenOffice.org; however, Microsoft doesn't like to follow specs too exactly, so their products render fonts slightly off-spec, leading to formatting differences with OOo.

For some, these formatting differences are very important; for others, less so.

Better to use OOo at both home and the office, if that option is available to you.
 

danmand

Well-known member
Nov 28, 2003
46,500
4,906
113
Yeah I agree. I decided it is not worth the hassle to save a few (hundred) bucks.
It depends. I have used OO on a netbook I have, and it works flawlessly with MS office (words and excel), but then again,
I was in software development for 25 years and I fasticiously avoids advanced features of words and excel.
 

OddSox

Active member
May 3, 2006
3,148
2
36
Ottawa
Depends on what you're doing. Even Word has formatting issues between Mac/Windows, different Word versions, and even different PCs - the program has been bloated for years and will probably never work properly unless they start from scratch...
 

gollumtroll

Well-known member
Jun 18, 2009
1,439
883
113
Agreed. It is great for doing individual work but becomes a problem when you have to share it with people who are trying to use it on MS Office.

To my knowledge it's not, my livelihood depends to some extent on being totally compatible with MS Word and I've had issues before. If there is a lot of formating and/or templates involved, I wouldn't take the risk that your workplace will point the finger at OO.
 

luckyjackson

Active member
Aug 19, 2001
1,505
2
38
As mentioned above, there are a lot of things which can be easily transferred between MSOffice and OpenOffice.org; however, Microsoft doesn't like to follow specs too exactly, so their products render fonts slightly off-spec, leading to formatting differences with OOo.

For some, these formatting differences are very important; for others, less so.

Better to use OOo at both home and the office, if that option is available to you.
yup. Even something as simple as a formatted table doesn't transfer well from OO to MSO
 
Toronto Escorts