Using Microsoft Office and OpenOffice.org
OpenOffice.org can open and save documents in the Microsoft Office file formats.
Opening a Microsoft Office File
-
Choose File - Open. Select a Microsoft Office file in the OpenOffice.org file open dialog.
|
MS Office file... |
...will open in OpenOffice.org module |
|
MS Word, *.doc |
OpenOffice.org Writer |
|
MS Excel, *.xls |
OpenOffice.org Calc |
|
MS PowerPoint, *.ppt, *.pps |
OpenOffice.org Impress |
Saving as a Microsoft Office File
-
Choose File - Save As.
-
In the File type box, select a Microsoft Office file format.
Saving Documents by Default in Microsoft Office Formats
-
In the Standard file format area, first select a document type, then select the file type for saving.
From now on, if you save a document, the File type will be set according to your choice. Of course, you still can select another file type in the file save dialog.
Opening Microsoft Office Files by Default
-
Exit OpenOffice.org and the OpenOffice.org Quickstarter.
-
Run the OpenOffice.org Setup program:
Click the Windows Start button, choose Control Panel, click Add or Remove Programs, select the OpenOffice.org r2.1 entry, click Change.
-
In the OpenOffice.org Setup, check the Modify option and click Next until you see the file types page.
-
Select or deselect the file types. Click OK and complete the OpenOffice.org Setup program.
Converting Many Microsoft Office Files into OpenDocument Format
The Document Converter Wizard will copy and convert all Microsoft Office files in a folder into OpenOffice.org documents in the OpenDocument file format. You can specify the folder to be read, and the folder where the converted files are to be saved.
-
Choose File - Wizards - Document Converter to start the wizard.
Macros in Microsoft Office and OpenOffice.org
Microsoft Office and OpenOffice.org cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and OpenOffice.org uses Basic code based on the OpenOffice.org API (Application Program Interface) environment. Although the programming language is the same, the objects and methods are different.
If you use macros in one of the applications and want to use the same functionality in the other application, you must edit the macros. OpenOffice.org can load the macros that are contained within Microsoft Office files and you can then view and edit the macro code in the OpenOffice.org Basic IDE editor.
You can choose to preserve or delete VBA macros
Open a Microsoft Office document that contains VBA macro code. Change only the normal contents (text, cells, graphics), and do not edit the macros. Save the document as a Microsoft Office file type. Open the file in Microsoft Office, and the VBA macros will run as before.
You may delete the VBA macros from the Microsoft Office file on loading or on saving.
-
Choose Tools - Options - Load/Save - VBA Properties to set the VBA macro handling of OpenOffice.org.
Index
Office,Microsoft Office and $[officename]
Microsoft Office,new users information
opening,Microsoft Office files
saving,in Microsoft Office file format
macros, in MS Office documents
This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.
