Compatibility with Microsoft Office

Not sure where to post? Post here!

Re: Compatibility with Microsoft Office

Postby nathandev » Sat Jan 11, 2020 10:31 pm

RusselB wrote:To summarize: OpenOffice is not 100% compatible with Microsoft Office.
The exact level of compatibility varies upon the type and complexity of the task.

Thank You RusselB, Thanks for saving my time.
NeoOffice 2.2.3 MacOS 10.15
nathandev
 
Posts: 8
Joined: Mon Dec 30, 2019 8:41 pm

Re: Compatibility with Microsoft Office

Postby nathandev » Sat Jan 11, 2020 10:35 pm

RoryOF wrote:If you will regularly be interchanging documents of importance, such as business documents, with MS Office users and they are for editing by both parties, then acquire and use MS Office. There can be formatting differences and macros will not necessarily run interchangeably.

I would be very grateful to you if you just mention the files format after interchanging. I think there is a possibility to change the file formatting by using some tools. I need the formats when interchanged.
Also how do you handle such a big data for interchanging?
Thank you.
NeoOffice 2.2.3 MacOS 10.15
nathandev
 
Posts: 8
Joined: Mon Dec 30, 2019 8:41 pm

Re: Compatibility with Microsoft Office

Postby RoryOF » Sat Jan 11, 2020 11:06 pm

.doc formats are rendered reasonably well, .docx are not so well supported; besides, OpenOffice cannot Save to .docx format.

You can try out some test files - it may be that you will find the OO/MS Word interchange satisfactory, but as I said, if the files and their formatting are of importance you should get MS Office.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32535
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Compatibility with Microsoft Office

Postby John_Ha » Sun Jan 12, 2020 12:26 am

LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 8376
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Compatibility with Microsoft Office

Postby nathandev » Sun Jan 12, 2020 1:23 am

RoryOF wrote:.doc formats are rendered reasonably well, .docx are not so well supported; besides, OpenOffice cannot Save to .docx format.

You can try out some test files - it may be that you will find the OO/MS Word interchange satisfactory, but as I said, if the files and their formatting are of importance you should get MS Office.

Your explanation was satisfactory and i appreciate you for your time.
As i am new to the community, hopeful to learn and get command like you do have.
NeoOffice 2.2.3 MacOS 10.15
nathandev
 
Posts: 8
Joined: Mon Dec 30, 2019 8:41 pm

Re: Compatibility with Microsoft Office

Postby nathandev » Sun Jan 12, 2020 1:51 am

John_Ha wrote:See [Tutorial] Differences between Writer and MS Word files for an explanation.

I will surely keep visiting these links time to time but is there any summarized guideline about Open Office in general?
NeoOffice 2.2.3 MacOS 10.15
nathandev
 
Posts: 8
Joined: Mon Dec 30, 2019 8:41 pm

Re: Compatibility with Microsoft Office

Postby John_Ha » Sun Jan 12, 2020 5:20 am

Not really - it's why I wrote the tutorial. MS Word keeps on adding function, the format of .doc files keeps on changing, Microsoft sets up MS Word so that it does not use strict OOXML so things keep changing all the time.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 8376
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Compatibility with Microsoft Office

Postby Villeroy » Sun Jan 12, 2020 10:58 am

You can not be fully compatible with something that refuses to be incompatible because of incompatibility as a busines model. OpenOffice has been created to overcome this problem by introducing a free and open standard. Of course OpenOffice can open a lot of foreign documents and LibreOffice does this job even better. But then you should work with the native file format of the program you are using. You would do the same with MS Office or with any other software producing documents, media, interactions.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29709
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Compatibility with Microsoft Office

Postby thomas12N » Tue Oct 27, 2020 2:54 pm

Yep, it's all about issues from Microsoft Word's side. They should create something like addons, I think, for resolving such issues..
OpenOffice 3.1 on Windows Vista
thomas12N
 
Posts: 1
Joined: Tue Oct 27, 2020 2:52 pm

Re: Compatibility with Microsoft Office

Postby RyanWad82 » Tue Dec 01, 2020 4:17 pm

So, there are no options to open text from OpenOffice in Word without breaking?
OpenOffice 4.1.7 on Windows 10 Pro KitchenToast
User avatar
RyanWad82
Banned
 
Posts: 1
Joined: Tue Nov 10, 2020 10:29 am

Re: Compatibility with Microsoft Office

Postby Zizi64 » Wed Dec 02, 2020 8:40 am

So, there are no options to open text from OpenOffice in Word without breaking?


I can repeat it only:

There is NOT (never was and never will be) 100% compatibility between the different file formats, and between the different types of the office suites.

The International Standard ODF formats provide you with long-term compatibility.

The MS Office file formats have many-many subversions, which are not even compatible with each other.

If you must work with MSO file formats or with the MSO anyway, then you must buy MSO.
Tibor Kovacs, Hungary; LO6.1.6, 6.4.7 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.1.1;AOO4.1.9
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9840
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Compatibility with Microsoft Office

Postby keme » Wed Dec 02, 2020 10:46 am

RyanWad82 wrote:So, there are no options to open text from OpenOffice in Word without breaking?

Well, the typical OpenOffice Writer document complies to a published standard format (the Open Document Format, or ODF). We have no influence on how Microsoft choose to handle files submitting to this standard. So if Microsoft products "break" your text created in OpenOffice, perhaps ask the Microsoft experts. (Good luck with that!)

Most commonly, content and basic structure is handled fine, but meticulous layout suffers. As I have repeated ad nauseaum in these forums, Microsoft Office and OpenOffice subscribe to different "schools of typography", which (among other things) treats spacing differently and has different ways to deal with marginalia (page headers/footers). Common consequences: Running text is reflowed, sometimes altering the page count. Tables filling an entire page (like what you would use to make a fillable form) may be significantly shifted, or split to new page (sometimes ruining a form setup).

If you have examples where the "breaking" you mentioned renders your files unusable or significantly degraded to a recipient using Word, you could ask a specific question in the forum, on "how best to adapt this so it can be used in Word". You should brace yourself for the "ask Microsoft" response, but then at least there is something to work with, and many of the helpers here have access to multiple Office suites on their computer. (For myself at time of writing: MSO365 Pro+, WPS free, LibreOffice 6.4.4, OpenOffice 4.1.8, and iWork "something" on a different workstation when I have to.)

  • If you want a tool to enable working with documents in a structured and predictable fashion, use OpenOffice (or LibreOffice).
  • If you want the highest degree of Microsoft compatibility, use Microsoft Office.
  • If you want the highest degree of Microsoft compatibility but don't want to pay the premium price MS is asking (or can't bother to relate to their licensing terms), use WPS Office.
Either way, there are advantages and tradeoffs.
User avatar
keme
Volunteer
 
Posts: 3405
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Compatibility with Microsoft Office

Postby John_Ha » Tue Mar 16, 2021 3:19 pm

RyanWad82 wrote:So, there are no options to open text from OpenOffice in Word without breaking?

Read the tutorial you were pointed to - it answers this question.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 8376
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Previous

Return to Beginners

Who is online

Users browsing this forum: Google [Bot] and 4 guests