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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
|
12-25-2008, 07:18 AM
|
#1
|
LQ Newbie
Registered: Jul 2007
Posts: 16
Rep:
|
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
|
|
|
12-25-2008, 07:40 AM
|
#2
|
Senior Member
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873
|
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.
|
|
|
12-25-2008, 07:46 AM
|
#3
|
LQ 5k Club
Registered: May 2003
Location: London, UK
Distribution: Fedora40
Posts: 6,154
|
You should install msttcorefonts using your package manager.
|
|
|
12-25-2008, 08:23 AM
|
#4
|
LQ Veteran
Registered: Nov 2005
Location: Annapolis, MD
Distribution: Mint
Posts: 17,809
|
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)
|
|
|
12-25-2008, 08:55 AM
|
#5
|
Senior Member
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873
|
Quote:
Originally Posted by tredegar
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 08:56 AM.
|
|
|
12-25-2008, 04:17 PM
|
#6
|
LQ 5k Club
Registered: May 2003
Location: London, UK
Distribution: Fedora40
Posts: 6,154
|
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).
|
|
|
12-25-2008, 07:20 PM
|
#7
|
Senior Member
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873
|
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.
|
|
|
12-25-2008, 09:51 PM
|
#8
|
LQ Newbie
Registered: Jul 2007
Posts: 16
Original Poster
Rep:
|
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..
|
|
|
12-25-2008, 11:06 PM
|
#9
|
LQ Muse
Registered: Aug 2005
Location: A2 area Mi.
Posts: 17,639
|
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
|
|
|
12-26-2008, 07:00 AM
|
#10
|
Senior Member
Registered: Dec 2005
Location: Massachusetts, USA
Distribution: Ubuntu 10.04 and CentOS 5.5
Posts: 3,873
|
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 07:07 AM.
|
|
|
All times are GMT -5. The time now is 11:25 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|