|
General software and network General OS-independent software and network questions, X11, MTA, routing, etc. |
|
Thread Tools | Display Modes |
|
|
|||
OpenOffice and MS Office Docs
Hello,
I know that OpenOffice and open MS Office documents (more-or-less, the formatting sometimes is off) - but, can it reliably save documents as MS Office? I know that it can, but my question is how well? Would someone know that the file (Word & Excel mainly) wasn't done in MS Office because the formatting has been all messed up?
__________________
And the WORD was made flesh, and dwelt among us. (John 1:14) |
|
|||
I don't know but, as a side note, the author of "High Performance mySQL" has written several books and says that Office is far buggier than OpenOffice and is a pain to work with for writing books. He very much prefers working with OO than Office.
|
|
|||
Hello,
Quote:
Unfortunately, I don't have MS Office on my home computer to do comparisons on. So, I can't tell myself how well the conversion is - though I do know that converting from MS format isn't always 100% effective (i.e., formatting).
__________________
And the WORD was made flesh, and dwelt among us. (John 1:14) |
|
|||
I've had mixed luck going in either direction. It depends a lot on the document complexity, as is well known. I deal mainly with NIH forms, and OO.o does OK, but not well enough.
You really just have to try it and compare. |
|
|||
Personally, the only thing I have recognized is a problem with graphics. When you embed graphics in a OO writer document, save it as DOC and afterwards open it with M$Word, those images are either not existent or they are not interpreted as objects in their own frame, so you don't have a chance of modifying any of their options (including positioning/size).
Another thing is the conversion of tables between OOimpress and M$Powerpoint - I don't remember in which direction, but if you're going to have a table of size 2x2 on one side, you'll end up with 4 text-frames on the other side Of course, not to speak about fonts and animations A few years ago the german - well, let's call it - "federation" started on migration guides. Version 2.0 is available in English and explains migration problems between M$2003 and OOo (page 273 et seqq.). This document is quite old (2005) and does not deal with all problems and migration in both directions. The new version 3.0 (dated Apr 2008) unfortunately is only available in German right now, but it is a really good comparison as far as I can see. |
|
|||
Hello,
Not all of my files are going to be .doc - many (and the most important so far) are Excel (spreadsheet) documents. And I don't have any experience with converting Excel files in OpenOffice - either in or out.
__________________
And the WORD was made flesh, and dwelt among us. (John 1:14) |
|
||||
Well, Excel, ... Gnumeric is said to be more compatible to Excel than Excel itself.
But, not all macros pass, not all graphs pass, ... I personally find Gnumeric a better spreadsheet than OOcalc. Same non-compatibility btw. There is an Open Document Architecture, the FLOSS version is comprehensive in OO, unfortunately Redmond designed an Open Document Architecture which is said better ('course you pay a license fee!) hence no full compatibility. Now, as these are compressed XML files, you can always decompress them and mull them through sed.
__________________
da more I know I know I know nuttin' |
|
|||
If you do simple text with paragraphs, some mixed fonts and little else, then OO.o is fine. It gets hairy when you have complex tables, fill-in forms, images and stuff like that. For straight text there are no problems.
For the simple spreadsheet application you describe, most anything will work. csv is a standard format, and simple tables with strings they all do. I'd personally do the Perl script in awk, but I'm old school. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem Building Openoffice-3 | Alphalutra1 | FreeBSD Ports and Packages | 1 | 1st May 2009 04:22 AM |
OpenOffice formula | c0mrade | Programming | 2 | 18th March 2009 09:09 AM |
OpenOffice on FreeBSD | corey_james | FreeBSD Ports and Packages | 24 | 13th September 2008 06:15 PM |
Proplem installing OpenOffice | qmemo | OpenBSD Packages and Ports | 4 | 23rd August 2008 12:09 PM |
OpenOffice | lumiwa | FreeBSD Ports and Packages | 2 | 20th July 2008 01:47 PM |