[Solved] Compatibility with Microsoft Office

Not sure where to post? Post here!
Wesley Pearce
Posts: 1
Joined: Sun Mar 06, 2016 5:33 am

[Solved] Compatibility with Microsoft Office

Post by Wesley Pearce »

Will Microsoft office users be able to edit OpenOffice documents ?
Last edited by Hagar Delest on Sun Feb 26, 2023 7:29 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 3.1 on Windows 10
User avatar
Zizi64
Volunteer
Posts: 11345
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Compatibility with Microsoft Office

Post by Zizi64 »

There is NOT 100% compatibility between the International Standard ODF formats and the many file format versions of the MSOffice. (Never was and never will.)

The LibreOffice (relatively to the Apache OpenOffice) has a little bit more compatibility with the foreign fileformats.


The newer versions of the MSO can open the ODF fileformats wit - some limitations. And the Libreoffice can export your Standard ODF documents to the half-standardized OOXML (xlsx, docx) formats. The AOO can not export OOXML fileformats today.
The binary fileformats of the MSO (xls, doc) never was standardized.


Use the native and standardized ODF fileformats, and please, suggest others to use them.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Compatibility with Microsoft Office

Post by Villeroy »

Wesley Pearce wrote:Will Microsoft office users be able to edit OpenOffice documents ?
The latest MS Office supports OpenOffice documents (*.odt text and *.ods spreadsheets) fairly well.
All versions of MS Office since 1997 still support *.doc and *.xls perfectly well and OpenOffice exports these formats very well (but not perfectly well).
There are other products which are able to produce slightly better MS Office documents than OpenOffice but the one and only product that is designed for these file formats is MS Office itself. There is no product to replace MS Office for editing MS Office documents.
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
Edda
Posts: 1
Joined: Sun May 22, 2016 8:56 pm

Re: Compatibility with Microsoft Office

Post by Edda »

I'm not very computer literate and I need to know if it's possible, when attaching a document to an email, to enable it to arrive so that it can be altered by the recipient, not just " read only."
OpenOffice 4.1.2 installed on Microsoft Windows 10
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Compatibility with Microsoft Office

Post by thomasjk »

Edda wrote:I'm not very computer literate and I need to know if it's possible, when attaching a document to an email, to enable it to arrive so that it can be altered by the recipient, not just " read only."
Edda, did you mean to say "so it can't be altered"? If so then you can use File-->Send-->Email as PDF. Alternatively, you can use File-->Export as PDF then attach that file to an email.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
jrkrideau
Volunteer
Posts: 3816
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Compatibility with Microsoft Office

Post by jrkrideau »

Edda wrote:I'm not very computer literate and I need to know if it's possible, when attaching a document to an email, to enable it to arrive so that it can be altered by the recipient, not just " read only."
If you mean this
so that it can be altered by the recipient
and not thomasjk''s suggestion just sent it and suggest that the recipient save the file to disk before opening it.
LibreOffice 7.3.7. 2; Ubuntu 22.04
User avatar
keme
Volunteer
Posts: 3691
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Compatibility with Microsoft Office

Post by keme »

With collaboration on files using Word and Writer, some limitations should be applied to the use of formats and layout measures:
- Avoid "outdents" (negative indent, pulling content out into margin. Also tables and frames protruding into margin areas.)
- Do not use "containers in containers" (A table inside a table cell, frame inside frame) Table inside frame seems to work, if you must...
- Do not expect perfectly identical layout in both applications.
- Use ODF, not OOXML.

In my job I have had to build a template breaking all the rules above. Trying to do that with Word (saving as either doc,docx or odt) made a mess when opening in Writer. Using Writer and saving as doc produced similar garbage when opening with Word. Surprisingly, when I tried to open my odt file (no, I do not save an ott file because my colleagues do not properly understand the concept of "template"), it gives exactly what we were after, in Writer as well as in Word (as long as the stuff worked on in Word does not go back into Writer, of course...).

So, you could argue that Word has better support for reading the storage formats in question, or that Writer creates cleaner files when saving...
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Compatibility with Microsoft Office

Post by John_Ha »

See [Tutorial] Differences between Writer and MS Word files for a discussion, and for the reasons you should always work in and save files as .odt.
Attachments
Different capabilities in Writer and its .odt files compared with MS Word and its .doc, .docx (and .rtf) files.<br />Note that MS Word, while capable of supporting some of the function stored in a .odt file chooses not to implement that function.<br />MS Word 6.0/95 files cannot store Draw objects.
Different capabilities in Writer and its .odt files compared with MS Word and its .doc, .docx (and .rtf) files.
Note that MS Word, while capable of supporting some of the function stored in a .odt file chooses not to implement that function.
MS Word 6.0/95 files cannot store Draw objects.
Last edited by John_Ha on Sun Apr 08, 2018 1:00 pm, edited 1 time in total.
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.
User avatar
Lesley_Vos
Posts: 12
Joined: Wed Oct 25, 2017 11:32 am
Location: Chicago, IL

Re: Compatibility with Microsoft Office

Post by Lesley_Vos »

Edda wrote:I'm not very computer literate and I need to know if it's possible, when attaching a document to an email, to enable it to arrive so that it can be altered by the recipient, not just " read only."
That's why I prefer saving my texts in .doc or .docx formats for recipients to open and edit them. (Just go to File --> Save As..., and choose a format). I am a freelance writer using OpenOffice, but I can't be sure all my clients use it, either. There were some cases when I sent .odt files and clients asked to resend once again because they couldn't open and read those files on their comps...
OpenOffice 4.1.4 on Windows 8
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Compatibility with Microsoft Office

Post by RoryOF »

.doc is a safer format from OO when one _must_ send documents to others for collaborative work; there may be problems with formatting when a document is transferred back and forth. If a document is being sent for review (not editing) PDF is best.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Compatibility with Microsoft Office

Post by John_Ha »

Lesley_Vos wrote:
Edda wrote:I am a freelance writer using OpenOffice, but I can't be sure all my clients use it, either. There were some cases when I sent .odt files and clients asked to resend once again because they couldn't open and read those files on their comps...
All versions of MS Word later than about 2007 can open .odt files.
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.
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Compatibility with Microsoft Office

Post by RoryOF »

John_Ha wrote: All versions of MS Word later than about 2007 can open .odt files.
Indeed, John, but the majority of MS Office users have a mental block and won't even attempt to load any file other than .docx.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Compatibility with Microsoft Office

Post by Villeroy »

RoryOF wrote:
John_Ha wrote: All versions of MS Word later than about 2007 can open .odt files.
Indeed, John, but the majority of MS Office users have a mental block and won't even attempt to load any file other than .docx.
The same majority works with hidden file name suffix. By the way, does anybody know which icons are displayed for ODF documents on a MS Office PC?
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
keme
Volunteer
Posts: 3691
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Compatibility with Microsoft Office

Post by keme »

Villeroy wrote:...
By the way, does anybody know which icons are displayed for ODF documents on a MS Office PC?
MS Office icons, of course.

When you reset the default application to OpenOffice (assuming both suites are installed), you get the OpenOffice icons.
MS Office updater seems to reset this every now and then, so occasionally have to redo...
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Compatibility with Microsoft Office

Post by Villeroy »

keme wrote:MS Office icons, of course.
So they can't tell MS Office documents from ODF documents.
keme wrote:When you reset the default application to OpenOffice (assuming both suites are installed), you get the OpenOffice icons.
MS Office updater seems to reset this every now and then, so occasionally have to redo...
Like the Windows 10 updater resets the start menu to commercial mode, turns on the voice assistant (although the sound chip is disabled) and resets the default picture viewer to something inadequate.
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
keme
Volunteer
Posts: 3691
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Compatibility with Microsoft Office

Post by keme »

Villeroy wrote:...
keme wrote:When you reset the default application to OpenOffice (assuming both suites are installed), you get the OpenOffice icons.
MS Office updater seems to reset this every now and then, so occasionally have to redo...
Like the Windows 10 updater resets the start menu to commercial mode, turns on the voice assistant (although the sound chip is disabled) and resets the default picture viewer to something inadequate.
... and default PDF reader to Edge (which is also seriously flawed, not only as a PDF reader...). Yes, that is exactly how it happens. As long as users accept it, companies will do it. Most users accept the request to send anonymous usage data from the builtin apps, and Edge of course sends most everything to Bing by default. The value of big data, etc...
jrkrideau
Volunteer
Posts: 3816
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Compatibility with Microsoft Office

Post by jrkrideau »

Abandon the EVIL WAYS of MS and come to Linux!
LibreOffice 7.3.7. 2; Ubuntu 22.04
User avatar
Lupp
Volunteer
Posts: 3535
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Compatibility with Microsoft Office

Post by Lupp »

keme wrote:... As long as users accept it, companies will do it. ...
Users (customers) are mislead to accept next to everything everywhere as long as it isn't a dent on the new car. In fact it is extremely time-consuming to make sure to be sufficiently informed and to judge everything on one's own. In my case, if I did, I surely had no time left to contribute here...

Roughly invisible things like "General Terms and Conditions", form contracts, behaviour of software beyond its obvious (sometimes even purposeful) functionality ... must be regulated very strictly by law in societies and economic environments as complicated as we have them now. Omitting related legislation (and control, of course) again and again is not just annoying but really evil. To tell me I have the freedom to (...fill in please...) is kind of stultification insofar. Surely it will be better after the next election.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
crusader
Volunteer
Posts: 506
Joined: Sun Jan 20, 2008 5:06 am

Re: Compatibility with Microsoft Office

Post by crusader »

Just saw this post and couldn't help but share my 2 pennies worth...
Lesley_Vos wrote:There were some cases when I sent .odt files and clients asked to resend once again because they couldn't open and read those files on their comps...

A perfect opportunity to educate them about LibreOffice/OpenOffice!
jrkrideau wrote:Abandon the EVIL WAYS of MS and come to Linux!
And live happily ever after...

My signature speaks for itself.
LO 7.x on Linux Mint
In a world without walls, who needs Window$.
A candle loses nothing by lighting another candle.
User avatar
keme
Volunteer
Posts: 3691
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Compatibility with Microsoft Office

Post by keme »

Lupp wrote:[...]
it is extremely time-consuming to make sure to be sufficiently informed and to judge everything on one's own. In my case, if I did, I surely had no time left to contribute here...
[...]
... not just annoying but really evil. To tell me I have the freedom to (...fill in please...) is kind of stultification insofar. Surely it will be better after the next election.
Exactly.

For the former we have "terms of service? didn't read." (TOSDR)

For the latter, the only solution is to force all our politicians to read some litterature, so they be educated about the tactics of the "powers that be":

First a couple of "Trilogies"
  • Foundation (Asimov)
    Hitchhiker's guide to the galaxy (Adams)
Then the "counterpart" to 1984
  • Brave New World (Huxley)
This is also usefult reading for all us voters. It amounts to at most 7000 pages (depending on which edition you choose), which is around the size of the ooxml strict definition from Microsoft ECMA (which may be given as an alternate work for mandatory reading. I know which alternative I would choose...).
User avatar
keme
Volunteer
Posts: 3691
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Compatibility with Microsoft Office

Post by keme »

adamk127 wrote:import ms office for openoffice it is problematic. It worked poorly
Then you should try LibreOffice first. That is the office suite which would have come came preinstalled with your operating system when using the default setup.
For single instances you could also be helped with online file conversion tools. Zamzar is one often mentioned.
If you really need to optimize your system for Microsoft Office file compatibility while using Linux, there are two options:
  • Subscribe to Office 365 and use the online apps. (I have used them with success from Firefox and Chrome browsers on Linux AntiX. Should be at least as good on Ubuntu.)
  • Install WPS Office (aka Kingsoft Office).
With both of those options, you lose a bit in the way of ODF support. However, you can have multiple suites installed in parallel and still use online apps, so with a bit of fiddling you can get "everything".
ankit3302
Posts: 5
Joined: Fri Jun 01, 2018 8:34 am

Re: Compatibility with Microsoft Office

Post by ankit3302 »

Well, there is not 100% compatibility between MS Office and Open office. But you can edit some of the file formats of Open office to MS office. .doc and .docx are the most widely used file formats which you can edit using MS Office.
OpenOffice 3.1 on Windows 10
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Compatibility with Microsoft Office

Post by John_Ha »

See [Tutorial] Differences between Writer and MS Word files for more information, and for why you should always work in and save files as .odt.
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.
Anne Gray
Posts: 1
Joined: Sun Jan 05, 2020 4:58 pm

Re: Compatibility with Microsoft Office

Post by Anne Gray »

I have old files done in Microsoft EXCEL (I think a 2010 version). Their file ending is .xlsx. How do I open them in Open Office ? BTW I am using Windows 8.1 on one machine and Windows 7 on another. I have read the forum posts and various guides but can't get anywhere - Open Office gives me a list of formats to choose from when it asks 'what program do you want to open this with?' but none of the obvious answers seem to work. Thanks
Open Office 3.1 on windows 8.1
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Compatibility with Microsoft Office

Post by RusselB »

@Anne Gray: Welcome to the Forums.
OpenOffice will open the .xlsx files, but does not have the ability to save in that format.
The message 'what program do you want to open this with?" is not coming from OpenOffice, but from your Windows installation.
If you start Calc, then go to File -> Open, you can navigate to where your .xlsx files are located, and open them.
If you want Calc to open the .xlsx files automatically, see [Tutorial]Setting the default program for MS formats
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Compatibility with Microsoft Office

Post by RoryOF »

You should be able to start OO from the Program button, then use /File /Open to select an .xlsx file and open it. If it prompts for choice of an ASCII character set, then the file has been stored as delimited text. If the files are of importance, I strongly suggest you remain with Excel. You could try LibreOffice, but until your files open and calculate correctly, _DO NOT_ save over them - use different names, no matter which program you decide to try.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
nathandev
Posts: 8
Joined: Mon Dec 30, 2019 8:41 pm

Re: Compatibility with Microsoft Office

Post by nathandev »

There are numerous answers and a state of ambiguity as what to do or what not to do?
Can anyone please summarize the whole thing for me?
Thanks in Advance.
NeoOffice 2.2.3 MacOS 10.15
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Compatibility with Microsoft Office

Post by RusselB »

To summarize: OpenOffice is not 100% compatible with Microsoft Office.
The exact level of compatibility varies upon the type and complexity of the task.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Compatibility with Microsoft Office

Post by RoryOF »

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.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
nathandev
Posts: 8
Joined: Mon Dec 30, 2019 8:41 pm

Re: Compatibility with Microsoft Office

Post by nathandev »

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
Locked