OpenOffice.org Guidebook Resources

OpenOffice.org 3 Guidebook Supplementary Files

Here's a post for files I mention in the OpenOffice.org 3 Guidebook.

Calendar created using a spreadsheet. I've included a 2011 calendar, a very simple one created in Calc. There's one with the formulas in it, and one with just the numbers.

• Download calendar_2011_noformulas.ods (12.0K)
• Download calendar_2011_formulas.ods (12.0K)

test

Ordering the OpenOffice.org 2 Guidebook

US Sales Only: Order Directly From Me Through PayPal
The book when you order from me is $30 plus $4 media mail shipping.

US Sales Only: Order "Used" From Me Through Amazon.com for $36
Click here to order from Amazon.com.   Ordering it "Used" lets you order directly from me; the copy you receive will be new and straight from the printer. Amazon takes a far smaller chunk for "used" copies so I can sell it for much less than the full price on Amazon.

US, Canada, and International: Order From Cafepress.com
Click here to order from Cafepress.com. Especially if you'd like shipping to locations outside the US. They are able to provide cheaper international shipping.
 

Bulk Discounts
Email me directly through [email protected].

---

Additional Content

This post is the central location for additional content I want to refer book readers to. Please feel free to post comments with links to additional book-like tutorial content.

The data pilot spreadsheet

Page 235 refers to the data pilot spreadsheet.

Mail Merges and Databases, Labels, Envelopes

• Creating two or more pages of labels
• The advanced Mail Merge wizard that allows you to skip empty lines in addresses.
• Creating reports using Base.
• Creating forms using Base, from scratch and with the wizard.
• Creating views in Base
• Using functions such as MAX in the views and queries in Base
• Exporting data from a Base database 

PDF and Web Publishing

• Converting files to PDF or to HTML
• Using Image Maps and the HTML features   
• PDF and links

Graphics

• Using the Gallery 
• Creating your own arrows and other line ends

Equations (Math Editor)

• The Comprehensive Calc workbook includes this
• You can also download this file; the equation contents from the Calc workbook (they're called formulas in the OOo interface)

Writer and Large Documents

• Using the Navigator to go to specific places in your document
• Creating rock-solid reliable numbering that restarts when it should, using fields
• Using master documents, with Writer documents and with other types such as spreadsheets   

Calc

• Using the data pilot (similar to pivot tables)
• Controlling what people can enter in spreadsheets: adding help, error messages, dropdown lists, etc.
• Using Scenarios

OpenOffice.org 1 Resource Kit
Many of the advanced features such as master documents  haven't changed since 1.1. If you'd like a guide to advanced features, consider purchasing that book.

Training Materials
I have covered many topics, including advanced topics such as master documents and pivot tables, in my training materials.

---

Free OpenOffice.org 2 Guidebook Chapters

I'm delighted to announce that my OpenOffice.org 2 Guidebook has just been published!

To celebrate the publication (self-publication), I'd like to share some of the contents. The following links are to three of the chapters. 

• Creating and Formatting Tables covers the basics as well as advanced topics like complex border formatting, autowidth, Autoformats (a great timesaver), converting between tables and other formats, doing calculations in tables, sorting, automatic numeric formatting, and more.
• Sorting and Filtering Spreadsheets covers standard sorting, sorting by multiple criteria and left to right, as well as a valuable tool for data entry or sorting, custom sort lists. Filtering, using the autofilter or the more powerful standard filter, is also included.
• Creating Impress Master Pages (Backgrounds) covers the benefits of formatting presentations with master pages, as well as how to modify them, create them, and essential tips for preserving the newly created master pages. You’ll also read about how to apply header and footer information to different views in a presentation, and create templates from your master pages.

For more information, click here to see the table of contents, or click here to learn more about the book.

---

• [+] Digg: Feature this article
• [+] Del.icio.us: Bookmark this article

---

Templates and Files

Here are all the files you can use with the OpenOffice.org 2 Guidebook. Right-click on each link and choose to save the link target to your computer.

If you have a template you'd like to share, please email me, or post a comment with a link to your templates.

The data pilot spreadsheet

Page 235 refers to the data pilot spreadsheet.

For adding lines to Impress handouts
The lines.jpg graphic to import
The handout_lines.odp presentation: view the handouts view and just copy the lines into your handout

Writer files
A document set up with connecting frames to make a trifold brochure 

---

Errata Blog

Any published document has its fair share of errors. If you find an error in the book, please post a comment here. I can't make any guarantees about when the corrections will be made, but I will do my best.

If you have a suggestion for a feature to be added, especially to an advanced book, please click here.

---

Suggestions Blog

If you have a suggestion for an advanced book or another type of book, please post a comment here. I'm not positive that there is a market for the book; you can see more content here with my training materials.

If you find an error in the book, please post a comment here. I can't make any guarantees about when the corrections will be made, but I will do my best.

---