I wrote this article for TechTarget about the fabulous Web Wizard and its uses for mass PDF conversion and quick web publishing of existing documents. This is a "classic" post but it's a great feature that bears re-posting about.
Cite This Blog
Train Your Organization
September 18, 2008
January 24, 2007
January 22, 2007
December 10, 2006
Getting an HTML Table Into a Spreadsheet in OpenOffice Calc
I blogged here about how to get a spreadsheet into a Writer table.
As for the opposite, getting a Writer table into a spreadsheet, you just copy and paste. Very easy.
How do you get an HTML table into a spreadsheet?
Or, frankly, how do you just suck some HTML content into a spreadsheet?
You should be able to copy and paste--when I paste a table, it comes into the spreadsheet nicely with the rows and columns retained correctly. However, I understand that doesn't work for everyone. So you can use this approach, instead.
Also, if you are so inclined, how do you get it to update regularly? Maybe you want to display stock quotes from a Web page--you can choose to put those in a spreadsheet and have them update every 30 or 300 seconds. (This feature works correctly with links to files and it really should work, in theory, to link your spreadsheet to a web page on the net but I can't get it to work with a URL, just with a file. If anyone else can, write and let me know how.)
In this case, you might always want to use this approach.
1. Go to the web page containing the table that you want to use. Save the file to your computerif it's not there already. The window and the online help indicate that you can just link to a URL starting with HTTP but I can't make it work.
Also, take a look at the tables if there are more than one. You're going to need to figure out which table you want by knowing what order the tables appear in.
2. Go to your spreadsheet. Click in the cell at the upper left range of where you want the table(s) to appear.
3. Choose Insert > Link to External Date.
4. In the window that appears, browse to the file that you saved to your computer. If you want to try making an HTTP URL work, then paste in that URL instead. The online help says to paste it in, then press Enter.
5. Select the content you want to insert. HTML_All inserts everything in the HTML page. HTML_Tables inserts all the tables. HTML_1 inserts the first table, and so on.
6. Select the Update Every option, if you want to update the content, and specify how often in seconds. This does work, but it has a drawback that we'll see later.
7. Click OK.
8. The HTML content you selected will appear.
9. To format the content to wrap within the cell, select the cells, choose Format > Cells, and in the Alignment tab select the Wrap option shown. Click OK.
10. Whenever the HTML file changes, the spreadsheet updates. However, as you will see, all your beautiful wrap formatting goes away.
If your content in the table is fairly wide, then:
- Resign yourself to it looking like this in the spreadsheet
- Widen the cells in the spreadsheet
- Don't choose to update the content
August 04, 2006
Some Pretty Slick Web Design Features: Image Map, Web Page Editing, Graphic Design, and Creating Your Own Colors (Repost)
(First posted March 2006)
I know I should probably be using Nvu or just hand coding everything in HTML or using cascading style sheets.
But for those of us who still redesign our web sites on Saturday morning while listening to Car Talk and Wait Wait, Don't Tell Me, I wanted to talk about what I did for my site at www.getopenoffice.org. Since it worked out pretty well, to my not-that-artistic mind. At least, it's vaguely pleasant and not Five Bright Colors of the Same Shade. Click to see a bigger version if you like.
I was pretty happy with what I was able to do, how I was able to design the colors, and I'm stoked with the image map. It turned out in a far more normal, controlled way than I usually experience. So for all of you out there who are a little fuzzy on web design but do it anyway, here are some features I think you can use for some pretty decent results.
I'm not here to talk about how FAAAbulous the new design is, but to focus on the steps I used in OpenOffice.org to do it. It's also by no means a lesson on web design—I'm just showing what I was able to do in a morning (OK, a long morning) in OpenOffice.org, and hoping it helps other people.
Features include:
- Creating my own colors
- Cool drawing shapes for nav bar
- Image maps
- Reasonably well-behaved HTML editing in Web documents (HTML purists, just let me go with this ;> )
By the way: I'm sooooo sorry for the bright blue design at www.getopenoffice.org for the past few months. I got the templates from a free templates site and it just didn't work.
Getting the Design
I am in no way a Graphic Designer. So I just went to my friend Kristin Nelson's web site (designed by fabulous friend Takane), www.nelsonagency.com, to get ideas. I decided there was no way I was going to learn JavaScript before I had to leave that afternoon, but I did like the colors—a deep maroon and a beige. So I stole that. ;>
Side story: Kristin started her literary agency maybe four years ago, and she lives in Denver, not New York. She's made incredible progress, including selling the film rights to many of the books. If you've got some marketable fiction and you're looking for an agent, consider her.
So, armed with the ideas “maroon!” and “taupe!” and figuring I would just use the same simple top/side navigation style, I continued to the beginnings of implementation.
Creating the Colors
One of the wonderful things about OpenOffice.org is that you can create your own colors. So I chose Tools > Options > OpenOffice.org > Colors, and created my maroon and my taupe. The far right color, and the ones on the bottom, are various colors I created for the site.
I did various shades of maroon, a lighter one for a bit of shadow and contrast, and a few different taupes for the nav area, the text in the nav area (nearly black), and other taupes for shading and for the background color of the page.
To create your own colors:
1. Choose Tools > Options > OpenOffice.org > Colors. Click on the Edit button in the colors window. Click the image to see a bigger version if you like.
2. Then mess around in those windows with the various settings til you get what you want.
3. Then click OK, click Add, and name the new color.
Creating the Nav Graphic
I went into OpenOffice.org Draw and after some fiddling with colors and fonts, came up with the navigation graphic, including all the text along the left and top. It's in two separate chunks, for the top and the left side.
I used this beveled rectangle tool to draw the navigation shape at the top, and just used a couple graphics behind each other in different colors for the other shading.
I exported each of the two graphics just by selecting the components of each, choosing File > Export, and exporting to .gif. Other options of course are JPG, PNG, etc.
Creating the Web Page Master
I created a new web page (File > New > HTML Document). I inserted an eight-inch-wide table in the center (well, kind of ;> ) of the document to control where the graphics and text go. The table was two rows and three columns, no heading, with a left column of 2 inches, a middle spacer column of 1 inch, and then the rest. Click to see a bigger image of the setup window here if you like.
Then I merged the top row of cells, where the top nav graphic is going, to end up with something like this.
And I also removed the table borders.
Adding the Graphic to a Document and Additional Formatting
I just chose Insert > From File and added the top graphic in the top merged row, and the left graphic in the left cell. I right-clicked on each graphic and set it to Original Size since there was some wackiness with automatic size reduction.
I also right-clicked on each graphic and choose Anchor > As Character to get rid of extra space below them.
Some extra white space showed at the bottom of the nav bar because of the formatting of the apparently nonchangeable Table Contents paragraph style. However, this wasn't an issue when browsing the document.
I also set the background color of the cells to match the graphic in them; the spacer and right lower cells were set to white since they'll have text and I want a white background.
I made the page background color a lighter taupe. (I chose Format > Page and clicked the Background tab.)
And I set the page size nice and big so that there would be plenty of room for the graphics. Same window, Format > Page and choose the Page tab.
Doing the Image Map: Linking Portions of Each Graphic to the Pages on My Web Site
I right-clicked on the top nav bar graphic and chose Image Map.
In the Image Map window, I used the rectangle tool to draw a box around each piece of text on the graphic that I wanted linked, and entered the URL It's a little odd—you have to draw the box around the image in the window, so it's a little small but manageable.
Then I did the same for the left nav bar.
You end up with nothing happening to the graphic itself, but a bunch of code in the document with the tag MAP1, MAP2, etc. The code gives the coordinates of the links. That means of course that you don't change anything that would shift the graphic up or down or left or right, once you get this done.
The image map would have been too small to see in this window if I had used the full length one here for the editing. I kind of cheated—I used a short version of the left nav graphic in the beginning, then created a much longer one in Draw and inserted that after the map was done. Since the only thing that changed between the short graphic and the long graphic was the bottom, where there are no links, this didn't affect the image map.
Tweaking
I had to tweak some stuff, of course, in the HTML. No biggie. My graphics seem to end up local sooner or later for no readily apparent reason. I use EvrSoft's 1stPage. I also tweaked a bit in Netscape's Composer since it seems that Web's graphics wrapping features, at least in the GUI, aren't all that great. (Of course, if I bothered to memorize a few more HTML commands, I wouldn't have needed Netscape at all.)
Pasting in the Content
Nothing shocking here. I pasted in the content from my old site, creating a new page with File > Save As.
I adjusted the right margin as I would in normal formatting. (Again, HTML purists, I know it's Wrong but it felt so right.... ;> )
Posted the pages. Did some retweaking.
That's All.
Heck, I didn't even use the Web Wizard. (File > Wizards > Web Wizard.) That tool of course is more for quick “just get it on the web” work when you have a lot of existing content to slam up on the web.
So....who should be using these tools versus Nvu, DreamWeaver, handcoding, better overall extensible design, etc.--well, I'm not debating any of those issues. Just wanted to show you what was available, and let you know you might be surprised at how much cool stuff you can do without a huge headache.
July 06, 2006
Think PDF and Links! OpenOffice.org Might Be Your One-Stop Shop for Documents You Distribute (Repost)
Note: This blog has two related posts, on PDF in general and on Impress and links. Originally posted January 2006.
I'm going to make a bold statement. If you ever put any documents on the web, you might need only one application in your life: OpenOffice.org.
I'm not talking web design—I'm just saying, if you work for the city government and need to post long pages of forms for people to download, or if you need to publish reports that people can easily find their way around in, or if you're a technical writer and create user manuals with the usual thousands of links within the document and to other documents—you might be good to go with only OpenOffice.org.
What Makes Me Think OpenOffice.org Is Such a Great Publishing Tool?
This is because of three things.
1. In OpenOffice.org, you can create links. You can just type "Click here to go to the web page," select some text, and link it to any web site you want.
You can link any text or graphic to any heading, graphic, table, etc. within your document or within another OpenOffice.org document. (You can link to another PDF document, but not to another bookmark within a PDF document.)
You can automatically generate a linked table of contents, so that anyone clicking on an item in the TOC is taken directly to that heading in the document.
You can put links in headers and footers. Have a link that says "Back to top" that appears in your footer, and you've got great navigation.
2. You can make a PDF document from your OpenOffice.org document. From a Writer text document, Calc spreadsheet, Impress presentation, or Draw drawing, with OpenOffice.org. Just choose File > Export as PDF. Or even easier, just click the PDF icon on your Standard toolbar.
3. In OpenOffice.org 2.0, the links you make in OpenOffice.org transfer over to and work in the PDF.
These are all very important and useful. Put'em together and you have huge power.
What You Need to Do in Your OpenOffice.org Document
Take a look. Here's a document I made using only OpenOffice.org, created the linked TOC automatically and the links between sections manually using only OpenOffice.org, and generated the PDF using only OpenOffice.org. Here's what I did in the document--I didn't do a huge amount of cross-references but I did do enough to demonstrate the power, I hope.
A. There's a table of contents that I generated automatically, and made hotlinked to each section, automatically. Click on a link in the TOC and it goes.
To create a hotlinked table of contents, in your Writer document choose Insert > Indexes and Tables > Indexes and Tables. To make the hotlinks, click the Entries tab of the window, click to the left of the E and click Hyperlink, and click after the E and click Hyperlink again. Click All to put hyperlinks on all levels of the TOC. Click OK.
Click this image to see a larger version.
B. At the fine, innovative suggestion of Dave Richards of the City of Largo, I put a link in the footer that says “back to top.” This text is linked to the Table of Contents heading so that clicking that link in the footer takes you to the table of contents. You could also add footers that say and link to "back to whatever you want." You could add headers and link them back to the original Head1. You could add a manual link at the end of any major or minor section to go back to the beginning of that heading.
To turn on the footer, choose Format > Page, click the Footer tab, mark the Footer checkbox, click OK. Then click in the footer text box that appears and click OK.
Click this image to see a larger image if you want.
Type the text you want in the footer text box.
How the heck do you make the link now that you're in the footer or header? That's next. To link an item in a header, footer, or anything else, see the next point.
C. I added links at the beginning, and to any interesting web sites, throughout the document, using the Hyperlink icon on the Standard toolbar. Links such as "This section covers the following topics" with a bulleted list containing three links.
Click this image to see a larger image if you want.
Here's how to create a manual link to a web site, other point in the document, etc. Select the text that you want linked. Click the Hyperlink icon on the Standard (top) toolbar.
In the window that appears, think about what kind of link you want to make. To link to a web site, just click the Internet icon on the left, and type the URL. Click Apply.
To link within the document, click the Document icon on the left side. Then click the round stopsign type icon by the Target in Document field, and you get the navigator. In the navigator window, you can link to any heading, table, object, etc. in your document, or in any other document.
Click this image to see a bigger image if you want.
Note: You'll see that Headings, the TOC, and also other objects like tables and bookmarks show up. You can link to any of them.
- Headings are anything to which you have applied Heading1 paragraph style through Heading10 paragraph style. More specifically, it's whatever is set as the headings under Tools > Outline Numbering.
- You can click anywhere and insert a bookmark by choosing Insert > Bookmark and naming it. Then all those bookmarks automatically show up in the Navigator list and you can link to them.
Select the item to link to.
Click Apply.
Click Close.
Once you're back in the Hyperlink window, click Apply again. The same text, a little technical looking, will show up in the Text field at the bottom of the page. This is the text that will appear in the document.
If you want something different to appear in your document, just retype it and click Apply
Then click Close. You'll see the text in the document, linked to the item you selected.
With those three attributes, you can make a document that's extremely useful.
Exporting to PDF
The final step, once you do all this in OpenOffice.org, is to export to PDF.
Choose File > Export to PDF. Name the file. In the PDF options window, specify a page range if you want, and make any changes to the graphics quality. (If you can, keep the JPG compression as high as possible.) Then click Export.
Here's the PDF Options window.Click it to see a larger version if you want. BE SURE TO SELECT THE "TAGGED PDF" OPTION to make the links convert to links in the PDF document.
Click Export, name the document, and you're done.
Take that PDF copy of your document and post it to your web site, email it to whoever needs it, or just do whatever needs to be done to distribute it to the folks who need it.
Think Links and Think PDF! It reduces repetitive work, gives you and your organization extra powers, and will make you look very cool when you introduce this slick, labor-saving approach to distributing documents.
June 20, 2006
Open Source Web Site Templates
Check'em out! Very pretty stuff.
"Open Source Templates was mainly created to support non-profit organizations.
If you run a non profit org, and are needing to cut down on the costs associated with website development than you have come to the right place. We offer a wide range of free for personal use or non profit use website templates that are easy to modify and add content to.
We will be offering a wide range of tutorials dedicated to helping your organization easily download and create your own great looking site in a matter of hours."
See also this web site, http://www.oswd.org/
About this site:
"To put it simply, Open Source Web Design is a collection of web designs submitted by the community that anyone can download free of charge!
The Open Source Web Design project was founded in September, 2000 by Francis J. Skettino. The goal was to provide the Open Source community with quality web designs to help get people's projects on the web in a way that is both organized and good looking. From personal blogs to content managements systems to full fledged businesses, OSWD has been providing free web designs to those who need them for years. With your help, we will continue to do this for years to come. "
March 24, 2006
March 08, 2006
Some Pretty Slick Web Design Features: Image Map, Web Page Editing, Graphic Design, and Creating Your Own Colors
I know I should probably be using Nvu or just hand coding everything in HTML or using cascading style sheets.
But for those of us who still redesign our web sites on Saturday morning while listening to Car Talk and Wait Wait, Don't Tell Me, I wanted to talk about what I did for my site at www.getopenoffice.org. Since it worked out pretty well, to my not-that-artistic mind. At least, it's vaguely pleasant and not Five Bright Colors of the Same Shade. Click to see a bigger version if you like.
I was pretty happy with what I was able to do, how I was able to design the colors, and I'm stoked with the image map. It turned out in a far more normal, controlled way than I usually experience. So for all of you out there who are a little fuzzy on web design but do it anyway, here are some features I think you can use for some pretty decent results.
I'm not here to talk about how FAAAbulous the new design is, but to focus on the steps I used in OpenOffice.org to do it. It's also by no means a lesson on web design—I'm just showing what I was able to do in a morning (OK, a long morning) in OpenOffice.org, and hoping it helps other people.
Features include:
- Creating my own colors
- Cool drawing shapes for nav bar
- Image maps
- Reasonably well-behaved HTML editing in Web documents (HTML purists, just let me go with this ;> )
By the way: I'm sooooo sorry for the bright blue design at www.getopenoffice.org for the past few months. I got the templates from a free templates site and it just didn't work.
Getting the Design
I am in no way a Graphic Designer. So I just went to my friend Kristin Nelson's web site (designed by fabulous friend Takane), www.nelsonagency.com, to get ideas. I decided there was no way I was going to learn JavaScript before I had to leave that afternoon, but I did like the colors—a deep maroon and a beige. So I stole that. ;>
Side story: Kristin started her literary agency maybe four years ago, and she lives in Denver, not New York. She's made incredible progress, including selling the film rights to many of the books. If you've got some marketable fiction and you're looking for an agent, consider her.
So, armed with the ideas “maroon!” and “taupe!” and figuring I would just use the same simple top/side navigation style, I continued to the beginnings of implementation.
Creating the Colors
One of the wonderful things about OpenOffice.org is that you can create your own colors. So I chose Tools > Options > OpenOffice.org > Colors, and created my maroon and my taupe. The far right color, and the ones on the bottom, are various colors I created for the site.
I did various shades of maroon, a lighter one for a bit of shadow and contrast, and a few different taupes for the nav area, the text in the nav area (nearly black), and other taupes for shading and for the background color of the page.
To create your own colors:
1. Choose Tools > Options > OpenOffice.org > Colors. Click on the Edit button in the colors window. Click the image to see a bigger version if you like.
2. Then mess around in those windows with the various settings til you get what you want.
3. Then click OK, click Add, and name the new color.
Creating the Nav Graphic
I went into OpenOffice.org Draw and after some fiddling with colors and fonts, came up with the navigation graphic, including all the text along the left and top. It's in two separate chunks, for the top and the left side.
I used this beveled rectangle tool to draw the navigation shape at the top, and just used a couple graphics behind each other in different colors for the other shading.
I exported each of the two graphics just by selecting the components of each, choosing File > Export, and exporting to .gif. Other options of course are JPG, PNG, etc.
Creating the Web Page Master
I created a new web page (File > New > HTML Document). I inserted an eight-inch-wide table in the center (well, kind of ;> ) of the document to control where the graphics and text go. The table was two rows and three columns, no heading, with a left column of 2 inches, a middle spacer column of 1 inch, and then the rest. Click to see a bigger image of the setup window here if you like.
Then I merged the top row of cells, where the top nav graphic is going, to end up with something like this.
And I also removed the table borders.
Adding the Graphic to a Document and Additional Formatting
I just chose Insert > From File and added the top graphic in the top merged row, and the left graphic in the left cell. I right-clicked on each graphic and set it to Original Size since there was some wackiness with automatic size reduction.
I also right-clicked on each graphic and choose Anchor > As Character to get rid of extra space below them.
Some extra white space showed at the bottom of the nav bar because of the formatting of the apparently nonchangeable Table Contents paragraph style. However, this wasn't an issue when browsing the document.
I also set the background color of the cells to match the graphic in them; the spacer and right lower cells were set to white since they'll have text and I want a white background.
I made the page background color a lighter taupe. (I chose Format > Page and clicked the Background tab.)
And I set the page size nice and big so that there would be plenty of room for the graphics. Same window, Format > Page and choose the Page tab.
Doing the Image Map: Linking Portions of Each Graphic to the Pages on My Web Site
I right-clicked on the top nav bar graphic and chose Image Map.
In the Image Map window, I used the rectangle tool to draw a box around each piece of text on the graphic that I wanted linked, and entered the URL It's a little odd—you have to draw the box around the image in the window, so it's a little small but manageable.
Then I did the same for the left nav bar.
You end up with nothing happening to the graphic itself, but a bunch of code in the document with the tag MAP1, MAP2, etc. The code gives the coordinates of the links. That means of course that you don't change anything that would shift the graphic up or down or left or right, once you get this done.
The image map would have been too small to see in this window if I had used the full length one here for the editing. I kind of cheated—I used a short version of the left nav graphic in the beginning, then created a much longer one in Draw and inserted that after the map was done. Since the only thing that changed between the short graphic and the long graphic was the bottom, where there are no links, this didn't affect the image map.
Tweaking
I had to tweak some stuff, of course, in the HTML. No biggie. My graphics seem to end up local sooner or later for no readily apparent reason. I use EvrSoft's 1stPage. I also tweaked a bit in Netscape's Composer since it seems that Web's graphics wrapping features, at least in the GUI, aren't all that great. (Of course, if I bothered to memorize a few more HTML commands, I wouldn't have needed Netscape at all.)
Pasting in the Content
Nothing shocking here. I pasted in the content from my old site, creating a new page with File > Save As.
I adjusted the right margin as I would in normal formatting. (Again, HTML purists, I know it's Wrong but it felt so right.... ;> )
Posted the pages. Did some retweaking.
That's All.
Heck, I didn't even use the Web Wizard. (File > Wizards > Web Wizard.) That tool of course is more for quick “just get it on the web” work when you have a lot of existing content to slam up on the web.
So....who should be using these tools versus Nvu, DreamWeaver, handcoding, better overall extensible design, etc.--well, I'm not debating any of those issues. Just wanted to show you what was available, and let you know you might be surprised at how much cool stuff you can do without a huge headache.
March 04, 2006
TechTarget Article: The Web Wizard
This article I wrote for TechTarget is about the fabulous Web Wizard and its uses for mass PDF conversion and quick web publishing of existing documents. And how it's just been hiding there from me for months. Cheeky wizard.
Update March 4th: The article was posted on Lifehacker.com! I'm very excited. It's been a very big week--I was Newsforged for the Office 2007 blog and Lifehackered for the web wizard article.
Tags 
OpenOffice.org pdfconverter expresspdf html to pdf open source html web publishing convert to pdf convert education Microsoft Office batch PDF printing
February 16, 2006
Get Ready to Save a Lot of Time: Using the Web Wizard as an OpenOffice/Microsoft Office PDF Batch Convert Program
Note: If you're not familiar with PDF, read this post. If you do a lot of online publishing of your PDFs, see this post to take advantage of links.
Psst! Do you like PDF?
Do you like easy, free ways to convert to PDF?
Do you have a bunch of PDF files you need to convert at once? I'm talking PDF batch convert.
Do you need to convert web pages to PDF?
And are you the type who doesn't mind just a bit of a hack to get cool results?
Then you are going to love this feature.
You might not have noticed a PDF Batch Convert feature in OpenOffice.org 2.0. That's because it's a Web page wizard, under File > Wizards > Web Page. This is OK—the Web wizard has some really cool features for web publishing but I'm all about PDF so that's what I'm concentrating on.
All right. Here we go. We're going to start the Web wizard, select the OpenOffice.org files you want to convert to PDF, specify where the output goes, ignore the extraneous HTML files in the output directory, and have ourselves a really dandy PDF batch convert process.
1. Choose File > Wizards > Web Page. You'll get this window. (Click it to see a larger image if you want.)
2. Just click Next.
3. Now you'll see the window where you put the files to convert to PDF. (Click it to see a larger image if you want.) Just click Add and find the files—Writer files, whatever you want. You can select all the files in the directory at once; just hold down Ctrl and select.
4. Now you say, convert these to PDF for me, please. For each file, select it and in the dropdown list, select the format to convert to. Select PDF for press for higher quality.
5. When you've specified PDF for each, click Next a few times to get to the last window.
6. Specify the
directory where you want the PDF files created.
7. Then just click Finish.
8. The PDFs will be created in the directory you specified—but inside a Content directory, along with an index.html file and other stuff.
9. Just open the content directory, and you'll see your PDFs.
Isn't it slick? I think it's great, and wanted to make sure you know about it since I just stumbled upon it on my own.
Now, there's a teeny issue. On my Windows desktop, but not my laptop, this doesn't work.It works the first time but not the second time. A message pops up saying the files aren't there, and to run repair. Running Repair doesn't work. The bug has been filed but not a lot of people get it. So if this doesn't work for you, just wait for the next rev, or try it on another machine.
Tags
OpenOffice.org 2 Guidebook
GetOpenOffice Consulting
Categories
- Administration and Installation (5)
- April Fool's (1)
- Calc (90)
- Calc: 2008 (36)
- Calc: 2009 (15)
- Calc: 2010 (8)
- Certification (1)
- Charts (6)
- Charts: 2008 (4)
- Clip art (16)
- Clip Art: 2009 (3)
- Compatibility and Conversion (7)
- Compatibility and Conversion: 2008 (7)
- Configuration and Setup (4)
- Configuration and Setup: 2008 (12)
- Databases (39)
- Databases: 2009 (1)
- Databases: 2010 (1)
- Diagrams (13)
- Draw (20)
- Draw 2008 (8)
- Draw: 2009 (9)
- Draw: 2010 (1)
- Education (9)
- Envelopes (7)
- Equations (math) (4)
- Extensions (10)
- Filtering/Sorting (1)
- Fonts (4)
- Forms (7)
- Free Online OpenOffice Seminars (1)
- Free software (25)
- General (28)
- GIMP (7)
- Google (5)
- Grammar (1)
- Graphics (26)
- Graphics: 2008 (5)
- Graphics: 2009 (4)
- IBM (2)
- Impress (37)
- Impress: 2008 (12)
- Impress: 2009 (2)
- Impress: 2010 (1)
- Labels (24)
- Labels: 2008 (7)
- Libraries (2)
- Linux (34)
- Linux: 2008 (2)
- Macros (3)
- Mail merge (39)
- Mail Merge: 2008 (8)
- Mail Merge: 2009 (4)
- Mail Merge:2010 (4)
- Memory (2)
- Microsoft Office (58)
- Microsoft Office users (20)
- Microsoft Office: 2008 (4)
- Numbering: Headings (1)
- Numbering: Lists (5)
- Numbering: Page (10)
- Open source (185)
- Opendocument format (65)
- OpenOffice (362)
- OpenOffice books (326)
- OpenOffice training (323)
- OpenOffice.org (346)
- OpenOffice.org 3.0 (14)
- OpenOffice.org 3.2 (4)
- OpenOffice.org: 2009 (4)
- PDF (16)
- Podcasts (4)
- PowerPoint: 2008 (3)
- Presentations: 2008 (9)
- Presentations: 2010 (1)
- Printing (18)
- Printing: 2008 (2)
- Products and Services (1)
- Reader input (9)
- Regular Expressions: 2010 (1)
- Reports (2)
- Reviews (48)
- Spreadsheets (79)
- StarOffice (212)
- Styles (40)
- Sun (7)
- Switching to OpenOffice (88)
- Tables (18)
- TechTarget articles (34)
- Templates (28)
- Templates: 2008 (4)
- Thunderbird and Firefox (4)
- Tips (20)
- Training:free seminars and online training (1)
- Ubuntu (9)
- Web (11)
- Web software (6)
- Windows (2)
- Writer (117)
- Writer: 2005 (2)
- Writer: 2006 (2)
- Writer: 2008 (46)
- Writer: 2009 (9)
- Writer: 2010 (2)
- Writing (3)