LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 12-25-2008, 08:18 AM   #1
Dnyanraj
LQ Newbie
 
Registered: Jul 2007
Posts: 16

Rep: Reputation: 0
MS Office compatibility with Open Office


I tried to print some .doc files from Open Office 2.3

But margins(& alignment) get disturbed, even i tried to set margins in same size as they are set in windows. But same problem is there.

this makes compulsory to use MS Office for these files. If i convert these files to .odt again alignment problem is there.

Can someone help me in this?
Some people told me that this issue is solved in Star Office, so I am trying to download Star Office & kOffice
 
Old 12-25-2008, 08:40 AM   #2
stress_junkie
Senior Member
 
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873

Rep: Reputation: 331Reputation: 331Reputation: 331Reputation: 331
KOffice probably won't help you. I tried it for a few months and hated it, even when using its native file format.

A lot of problems related to compatibility between Open Office dot Org and Microsoft Office are related to font selection. When you create a document using either application try to use fonts that are common to both environments.

It might also help if you set your Open Office dot Org to use Microsoft Office file formats as the default file format to create and save files. This is what I always do when I install Open Office dot Org v2.4.

FYI it is my understanding that Open Office dot Org v3.x will not save files in Microsoft Office formats but that the latest Star Office will do that. It might be worth trying Star Office (US $35 for the downloaded copy). I haven't tested Star Office's compatibility with Microsoft Office yet because I do not use any advanced features of these products. Rather I try to talk my clients into trying these things before they purchase yet another Microsoft Office license. I am currently trying to talk someone into purchasing Star Office to use in his business. His business uses a lot of Microsoft Office features in their documents. Naturally I've already set him up with automatic backups so that if Star Office caused problems he could restore his documents from an earlier date.
 
Old 12-25-2008, 08:46 AM   #3
tredegar
LQ 5k Club
 
Registered: May 2003
Location: London, UK
Distribution: Debian "Jessie"
Posts: 6,034

Rep: Reputation: 371Reputation: 371Reputation: 371Reputation: 371
You should install msttcorefonts using your package manager.
 
Old 12-25-2008, 09:23 AM   #4
pixellany
LQ Veteran
 
Registered: Nov 2005
Location: Annapolis, MD
Distribution: Arch/XFCE
Posts: 17,802

Rep: Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728
Quote:
FYI it is my understanding that Open Office dot Org v3.x will not save files in Microsoft Office formats
Just checked on my system. It will save in the older MS formats, but not Office 2007 (eg docx)

I don't recall if this is planned.

The world community tried to get MS to use ODF, but they managed to get their own "open" format registered (OpenXML, or something like that)
 
Old 12-25-2008, 09:55 AM   #5
stress_junkie
Senior Member
 
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873

Rep: Reputation: 331Reputation: 331Reputation: 331Reputation: 331
Lightbulb

Quote:
Originally Posted by tredegar View Post
You should install msttcorefonts using your package manager.
...and...
I believe that after you have installed the Microsoft Core Fonts package on your system you then have to manually add it to Open Office dot Org.

Last edited by stress_junkie; 12-25-2008 at 09:56 AM.
 
Old 12-25-2008, 05:17 PM   #6
tredegar
LQ 5k Club
 
Registered: May 2003
Location: London, UK
Distribution: Debian "Jessie"
Posts: 6,034

Rep: Reputation: 371Reputation: 371Reputation: 371Reputation: 371
Quote:
I believe that after you have installed the Microsoft Core Fonts package on your system you then have to manually add it to Open Office dot Org.
stress_junkie, you are quite right, I just checked.... From OO "Help":

To integrate additional fonts in the OpenOffice.org software, proceed as follows:

1.Go to the {install_path}/program directory.


I thought "where is that?". So, in a terminal:

Code:
tred@vaio:~$ locate spadmin
/usr/lib/openoffice/program/spadmin
/usr/lib/openoffice/program/spadmin.bin
tred@vaio:~$ /usr/lib/openoffice/program/spadmin
The window opens.

Then go to step 3

3.Click Fonts.
4.The dialogue lists all fonts added for the OpenOffice.org software. You can select and remove fonts using the Remove button or add new fonts with the Add button.
5.Click Add. The Add Fonts dialogue appears.
6.Enter the directory from which you want to add the fonts. Press the ... button and select the directory from the path selection dialogue or enter the directory directly.


I thought "where is that directory?". So, in a terminal:

Code:
tred@vaio:~$ locate Arial.ttf
/home/tred/LinuxStuff/Fonts/msttcorefonts/Arial.ttf
/usr/local/share/fonts/Arial.ttf
tred@vaio:~$
So I entered /usr/local/share/fonts/ in the dialog box

7.A list of the fonts from this directory appears, after the obligatory short OO pause.

Select the fonts you want to add. To add all the fonts, click Select All.


I selected All

8.With the Create soft links only tick box you can determine whether the fonts are to be copied into the OpenOffice.org directory or only symbolic links are to be created there. If the fonts to be added are on a data medium that is not always available (such as a CD-ROM), you must copy the fonts.

I selected "soft links" as they are on my HDD.

9.Click OK. The fonts will now be added.

They were.

In the case of a server installation, the fonts are installed in that installation if possible. If the user has no write access rights, the fonts will be installed in the corresponding user installation so that only the user who installed them can access them.

Restart OpenOffice, then the MSTT fonts are usable, and formatting across platforms is likely to be more consistent (so long as you are using the msttcorefonts in your publications).
 
Old 12-25-2008, 08:20 PM   #7
stress_junkie
Senior Member
 
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873

Rep: Reputation: 331Reputation: 331Reputation: 331Reputation: 331
tredegar your post on how to install fonts into OOo is very helpful. I just clicked on the "Thank you" icon in that post. I had done that several years ago but not recently.
 
Old 12-25-2008, 10:51 PM   #8
Dnyanraj
LQ Newbie
 
Registered: Jul 2007
Posts: 16

Original Poster
Rep: Reputation: 0
Hi Stress_junkie & Tredegar,
thanks for your help, that was useful.

But this did not solve whole problem, i had msttcorefonts already installed in my system, but it was not added in the Open Office. i did it, but still alignment(margin) of the document is still a issue. Did anyone of you worked on this?

P.S. i clicked thanks for both of you..
 
Old 12-26-2008, 12:06 AM   #9
John VV
Guru
 
Registered: Aug 2005
Posts: 13,283

Rep: Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775Reputation: 1775
Quote:
It will save in the older MS formats, but not Office 2007 (eg docx)
i do believe that OO 3 dose save to MS office 2007 format and the MS office 2008 also
 
Old 12-26-2008, 08:00 AM   #10
stress_junkie
Senior Member
 
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873

Rep: Reputation: 331Reputation: 331Reputation: 331Reputation: 331
Dnyanraj, if I were trying to do what you are doing then the next step that I would take would be to install OOo on a Windows machine and try to solve compatibility issues there. You might then be able to port your solution to your Linux machine.

I would research this right now but I am swamped with clients having all kinds of problems with their Windows machines and them trying to close their books. I worked all day Christmas getting rid of a Windows virus for my biggest client. He can close his books after he re-enters four days of financial posting. Today I've got two other clients looking for help. I almost wish that I had the time to research this now. Notice that I say almost because I'm self employed and my clients' Windows problems equate to money in my pocket.

If this isn't resolved in a few days and if I have some time I'll try to research it. This information could be useful to my clients so I want to know the answer if there is one.

Last edited by stress_junkie; 12-26-2008 at 08:07 AM.
 
  


Reply

Tags
compatibility, koffice, openoffice.org


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: SoftMaker Office 2008 focuses on compatibility with Microsoft Office LXer Syndicated Linux News 0 11-21-2008 05:30 AM
LXer: MS Office 2007 versus Open Office 2.2 shootout LXer Syndicated Linux News 0 05-01-2007 12:16 AM
LXer: SoftMaker Office 2006 boasts high MS Office compatibility LXer Syndicated Linux News 0 12-31-2006 07:54 AM
How to Get Open Office 2.0beta to Mimic MS Office 2003 Look? mac57 Linux - Software 2 03-08-2005 08:02 AM
Star office / Open Office on Sony Picturebook kkempter Linux - Laptop and Netbook 4 12-11-2003 02:34 PM


All times are GMT -5. The time now is 10:18 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration