Openoffice.org: 7 Things You Didn’t Know You Could Do
[From PC Mag]
Even though OpenOffice.org – which is, yes, an application suite, not just a Web site – can’t do everything Office can, it can do a lot, and it has some of its own tricks that even Office can’t manage. Here are a few that may not be obvious, as well as a few ways to make OpenOffice.org less annoying out of the box.
1. Edit two or more parts of a document at the same time. Microsoft Word has a nifty split-window feature that lets you divide the current window into two panes, so you can edit page 5 of your document in the top pane and page 505 in the bottom. To switch from one pane to the other, you don’t have to waste time scrolling back and forth – you simply click in the other pane. OpenOffice.org doesn’t let you split a window into two panes, but it offers an even better feature. Click the Window menu, then New Window, to open a new window that displays the same document you’re working on. You can open as many windows as you want, each at a different place in your document; any change you make in one window immediately appears in all others. You can reduce screen clutter by turning off toolbars in one or more windows (use View | Toolbars), and you can tile or cascade the windows by right-clicking on the OpenOffice.org button on the Windows taskbar.
2. Use OpenOffice.org to open legacy documents. Years ago, older versions of Microsoft Office could open documents created by almost any of the myriad word processors and spreadsheet programs that were widely used before Microsoft monopolized the market. Recent versions of Office can’t open many of those older formats – including old Microsoft Word versions such as Word 6.0. By contrast, OpenOffice.org continues to open Word documents dating back to Version 6.0. OpenOffice.org also opens WordPerfect documents, including files created in WordPerfect for the Macintosh 3.5 Enhanced, which not even WordPerfect for Windows tries to open. By the way, there’s something confusing about OpenOffice.org’s claims. The product purports to support at least one format that never existed: the list of supported file types in its File | Open dialog includes “Microsoft WinWord 5.0”, even though there never was such a version. Word for Windows skipped from 2.0 to 6.0 in its version numbers.
3. Play a vintage Space Invaders game. Remember the days of software “Easter Eggs”? They were not-very-secret keystrokes or mouse clicks that brought up silly graphics in some programs and games in others. Even Microsoft Excel used to have a secret game built in before Redmond lost its sense of humor. OpenOffice.org’s Calc spreadsheet program still includes a 1990s-era shoot-’em-up Space Invaders game. Open the Calc app, and in any cell enter: =GAME(“StarWars”) Make sure to copy the capitalization shown here. Calc will open a StarWars game in which you shoot down a fleet of evil alien ships. The explanatory text is in German (the original version of OpenOffice.org was written in Germany), but you don’t need to know even English to play the game. Calc has a slightly Teutonic attitude toward fun-and-games, however: after you quit the game, you’ll need to shut down Calc and start it up again before you can play a second time.
4. Turn off the blinking light bulb. By default, a light-bulb icon appears in a tiny window whenever OpenOffice.org does anything that isn’t exactly what you typed – for example, when it replaces two hyphens with a dash. It doesn’t exactly blink, but after the third or fourth time it opens, you may think of it as “that blinking light bulb” (you might use a word other than “blinking”). To turn it off permanently, go to Tools | Options, and then, in the left-hand pane, expand the menu tree by clicking the plus sign next to OpenOffice.org. In the General dialog, remove the check mark next to Help Agent.
5. Save files in Office formats by default. By default OpenOffice.org saves files in its own format, which most Microsoft Office users can’t open. You can save individual files in Office format by using OpenOffice.org’s File | Save as… menu and selecting a Word format from the Save as Type dropdown. But you can tell OpenOffice to save in Office formats by default by choosing Tools | Options, then find the Load/Save category, and the General subcategory. In the Document Type dropdown, choose Text Document, and in the Always Save As dropdown, choose Microsoft Word 97/2000/XP. Then, in the Document Type dropdown, choose Spreadsheet, and in the Always Save As dropdown, choose Microsoft Excel 97/2000/XP. These choices will create files that can be read by any modern word processor or spreadsheet.
6. Automate actions easily. Many advanced Microsoft Office users take advantage of macros that run automatically when you open, print, or close a file, but Office’s interface doesn’t provide built-in clues for creating an AutoClose macro that will run whenever you close a document. OpenOffice.org goes Office one better by providing a menu-driven interface that lists all the actions that can automatically trigger macros – and these include a wider range of actions than the ones that can be automated easily in Office. For example, you can create a macro that is triggered every time the number of pages in a document increases and that inserts a header with a page number if the number goes above, say, two. Other actions that can automatically trigger macros include saving a document under a different name and running a mail merge. To use this feature, record the macros you want to use, then go to Tools | Customize | Events and assign your chosen macro to specific events.
7. Fix those single quotes. By default, OpenOffice.org Writer creates good-looking, curly “typographic” double-quotation marks as you type, but when you type a single quotation mark (or an apostrophe) it uses a vertical line, as if you were still using your grandfather’s manual typewriter. Fix this by going to Tools | AutoCorrect…, then go to the Custom Quotes tab and, under Single Quotes, add a check mark next to Replace.