Here are a few suggestions to help the transition. Work more efficiently and help end users help themselves with these four reference charts covering Microsoft Excel, Microsoft Outlook, Microsoft Word, and Microsoft PowerPoint. If you've decided to switch from Microsoft Office to OpenOffice, you might find yourself having to work with both Office and OpenOffice files. Fortunately, OpenOffice does a relatively good job of working with Microsoft Office documents.
Here are several document-conversion tricks you can use when working in environments in which Office and OpenOffice are both used. Let's start with the basics. If you've recently adopted OpenOffice but have a bunch of documents that are still in Microsoft Office format, you'll probably want to be able to open the documents in OpenOffice.
The good news is that OpenOffice can open Microsoft Office documents automatically. Just double-click on an Office file and OpenOffice will import it. The odds of OpenOffice doing a perfect job of importing a Microsoft Office document depend on the complexity of the document. At the very most, you might have to do some minor reformatting.
If you import a highly complex document, though, expect to have problems. OpenOffice will open any Microsoft Office document, but not all features will work as they did in Office. One good example of this is Visual Basic scripts, which OpenOffice won't run. If you open a document containing VB script, you'll be able to view and edit the script, but you won't be able to execute the script from within OpenOffice.
If you're inexperienced with more advanced types of Microsoft Office documents, you might assume that Visual Basic script would be integrated into a document. However, Visual Basic script is the code through which Microsoft Office codes macros.
In such cases, OpenOffice will work perfectly for editing the document, and users who depend on macros will still be able to use them the next time the document is opened in Microsoft Office. There are two ways OpenOffice can deal with Microsoft Office documents that contain macros.
One option is to place the macros into a comment section of the document. This allows users to view or edit the macros, but not to execute them from within OpenOffice.
The next time the document is opened in Microsoft Office, the macros will be active. The other option is to configure OpenOffice to delete macros when opening any Microsoft Office document containing them. This container offers options for loading basic code along with a Microsoft Office document, and saving the code back out to a document. The options can also be configured independently for Word, Excel, and PowerPoint documents. Other features that are not supported by OpenOffice vary among document types.
For example, a Word document may not be converted to an OpenOffice document correctly if it includes autoshapes, revision marks, OLE objects, indexes, tables, frames, multicolumn formatting, hyperlinks, bookmarks, WordArt-based graphics, animated characters, animated text, or certain other elements.
There are also some features in Excel documents that may not convert correctly, such as autoshapes, OLE objects, pivot tables, new chart types, conditional formatting, and certain functions and formulas. Restrictions also exist for PowerPoint documents, although not as many as for Word and Excel documents.
OpenOffice has trouble converting PowerPoint documents that include autoshapes; tab, line, or paragraph spacing; master background graphics; grouped objects; and certain multimedia effects. However, OpenOffice uses its own file format, which is incompatible with Microsoft Office. For example, if you create a word processing document in OpenOffice, the default file type is OpenOffice.
Fortunately, OpenOffice's Save As feature allows you to save your document in a variety of formats, including several Microsoft Office formats. RTF and text file formats are also supported, as are a variety of StarWriter formats. The simple fact that you can export OpenOffice documents in Microsoft Office format raises some interesting questions, though.
Next, I downloaded the. The output was not stellar in quality:. Looks great. Not perfect, but quite reasonable. You can always use the command-line conversion, in case you have numerous documents to work with:. This makes it useful for batch conversion and scripts.
As you can see, even in the era of OpenOffice 3. Therefore, you should strongly consider using it, in order to improve the cross-suite cooperation and save yourself the time and hassle of manual tweaks. The author also lamented on the fact he does not have a screenshot demonstrating the use of the strawberry edition, as it cannot be used directly from inside OpenOffice and requires the files to be open manually by the user, e.
So here you go:. First, we install odf-converter-integrator in Windows. Next, we download the sample file and open it with a double-click from the folder where it resides. The file will be automatically converted, with an. And you will get the same results as before.
AbiWord is a handsome, lightweight word processor and word only , which natively supports the DOCX format and will open any such file with ease. This 25MB program has many incredible features you would not expect to find in such a small application. The DOCX support is just one of them. Then, there's a staggering range of other formats, Computer Modern fonts, equation editor, plugins, portable version, and much more. You probably want to read my detailed article , introducing and praising AbiWord.
Go-oo is a set of patches for the OpenOffice suite to make it more useful. This includes reduced memory usage and faster operations, built-in OpenXML import filters, numerous extensions that are not included in OpenOffice by default, spell-checkers, WordPerfect graphics support, VBA macros, embedded Visio diagrams, and more.
Go-oo is available for all major operating systems, including software repositories in Linux. Simply think of it as OpenOffice on steroids. Best of all, Go-oo is free, even though it shares much with with OpenOffice 3.
We will have a full review quite soon. Meanwhile, as an appetizer, you may want to read the Wikipedia article. No account yet? Create an account. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy. Cookie Settings. Learn why people trust wikiHow. Download Article Explore this Article methods.
Related Articles. Method 1. Open Microsoft Excel. Click Open Other Workbooks. Click Browse. All files in the folder should now be displayed. Double-click the OpenOffice Calc file you want to convert. The contents of the spreadsheet will open in Excel. Click the File menu. Click Save As.
0コメント