DaemonForums  

Go Back   DaemonForums > Miscellaneous > General software and network

General software and network General OS-independent software and network questions, X11, MTA, routing, etc.

Reply
 
Thread Tools Display Modes
  #1   (View Single Post)  
Old 4th August 2008
JMJ_coder JMJ_coder is offline
VPN Cryptographer
 
Join Date: May 2008
Posts: 464
Thanked 8 Times in 8 Posts
Default 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)
Reply With Quote
  #2   (View Single Post)  
Old 5th August 2008
drhowarddrfine drhowarddrfine is offline
VPN Cryptographer
 
Join Date: May 2008
Posts: 358
Thanked 9 Times in 8 Posts
Default

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.
Reply With Quote
  #3   (View Single Post)  
Old 5th August 2008
JMJ_coder JMJ_coder is offline
VPN Cryptographer
 
Join Date: May 2008
Posts: 464
Thanked 8 Times in 8 Posts
Default

Hello,

Quote:
Originally Posted by drhowarddrfine View Post
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.
I don't disagree (though, I doubt I'd write a book in OpenOffice - more like vim with tex ). But, it's not a question of performance or stability, it's a question of compatibility. If my boss says give me this in an MS format, I have one of two choices - use Office or use OpenOffice and export to Office format. If the OpenOffice conversion is suboptimal, I'm then left with only one choice.

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)
Reply With Quote
  #4   (View Single Post)  
Old 5th August 2008
DrJ DrJ is offline
ISO Quartermaster
 
Join Date: Apr 2008
Location: Gold Country, CA
Posts: 506
Thanked 39 Times in 39 Posts
Default

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.
Reply With Quote
  #5   (View Single Post)  
Old 5th August 2008
scottro's Avatar
scottro scottro is offline
Real Name: Scott Robbins
Spam Deminer
 
Join Date: Apr 2008
Location: NYC
Posts: 307
Thanked 31 Times in 25 Posts
Default

Piers Anthony, the well known science fiction and fantasy author, uses OO and sends his novels in with their format, I believe. Of course, the fact that his books are always best sellers is going to help keep the publisher from sending it back and saying, Manuscripts must be in .doc format.

His books over the years had several "Afterwards" where he spoke about his trials and tribulations getting Linux to be usable for him. (This goes back many years, when it was harder to use than it is these days.) He had decided that he really didn't like MS, and was looking for alternatives.

Of course, if some unknown author sent in a manuscript in OO format, it would probably be rejected.
Reply With Quote
  #6   (View Single Post)  
Old 5th August 2008
kazcor kazcor is offline
Real Name: Registreed Usre
Port Guard
 
Join Date: May 2008
Location: bliner, erg
Posts: 20
Thanked 1 Time in 1 Post
Default

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.
Reply With Quote
  #7   (View Single Post)  
Old 5th August 2008
lvlamb's Avatar
lvlamb lvlamb is offline
Real Name: Louis V. Lambrecht
Spam Deminer
 
Join Date: May 2008
Location: .be
Posts: 221
Thanked 25 Times in 24 Posts
Default

Save the doc as *.rtf (which is the default in Wordpad by the way).
Won't save every *.doc feature, but what it'll save is portable.
__________________
da more I know I know I know nuttin'
Reply With Quote
  #8   (View Single Post)  
Old 5th August 2008
JMJ_coder JMJ_coder is offline
VPN Cryptographer
 
Join Date: May 2008
Posts: 464
Thanked 8 Times in 8 Posts
Default

Hello,

Quote:
Originally Posted by lvlamb View Post
Save the doc as *.rtf (which is the default in Wordpad by the way).
Won't save every *.doc feature, but what it'll save is portable.
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)
Reply With Quote
  #9   (View Single Post)  
Old 5th August 2008
lvlamb's Avatar
lvlamb lvlamb is offline
Real Name: Louis V. Lambrecht
Spam Deminer
 
Join Date: May 2008
Location: .be
Posts: 221
Thanked 25 Times in 24 Posts
Default

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'
Reply With Quote
Old 6th August 2008
DrJ DrJ is offline
ISO Quartermaster
 
Join Date: Apr 2008
Location: Gold Country, CA
Posts: 506
Thanked 39 Times in 39 Posts
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT. The time now is 08:08 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick