Most office suites probably don’t include options to create barcodes with. OpenOffice doesn’t have any built-in barcode options, but you can add the Barcode plug-in to it. Then you can quickly set up a barcode with the...
It might be handy to have a calculator at hand when setting up documents with OpenOffice applications that aren’t spreadsheets. Sure, you can always open Calculator in Windows, but that doesn’t include a matrix operato...
Bookmarks are something you can add to OpenOffice documents. You can add bookmarks as a shortcut that when selected jump to a specific point in the document. In addition, you can also add visible bookmark points to documents with ...
Sudoku is a game in which you fill out a grid so that the rows, columns and sub grids include all the digits from one – nine. Now you can add this game to OpenOffice Calc spreadsheets. The Sudoku OpenOffice plug-in adds formatted ...
Draw is one of the OpenOffice applications that you can add plug-ins to. The Diagram extension is a good addition to Draw. With that you can quickly set up organization diagrams. This is the Diagram page on the OpenOffice website....
Another post covered OpenOffice’s VLOOKUP function to look up data with. Calc also has a HLOOKUP function that is similar. However, with HLOOKUP you can look up data in tables that have horizontal layouts. For example, set u...
This post covered how to add more templates to OpenOffice. In addition, you can also set up custom templates with your own layout and design. Custom templates will include headers, footers and placeholders that you can add to docu...
Templates give you a great shortcut for setting up documents such as letters. OpenOffice includes a variety of templates for spreadsheets, presentations and text documents; but it opens a default blank template when you press the ...
If you have a OpenOffice Calc spreadsheet with lots of blank cells in columns, there are a few ways to remove them. You could select the cell’s rows, right-click and then click Delete Rows. However, this is a better way to d...
OpenOffice Calc is an application that includes a variety of spreadsheet functions. VLOOKUP is one of its functions you can add to spreadsheets. With that you can look up data from within a table. Let’s suppose you have a s...
Sometimes Calc users might need to split data in one column into another. As such, Calc has a Text to Columns option for splitting columns. With that you can cut your spreadsheet columns down to size. Open a spreadsheet and then ...
Impress is the presentation application included with the OpenOffice suite. With it you can set up presentations, as covered here, and photography slideshows. You can set up a photo album slideshow more quickly by adding the Photo...
Do you need to convert lots of numbers in a spreadsheet to text? If so, you can do exactly that with OpenOffice’s Numbertext plug-in. That’s a plug-in which adds a new NUMBERTEXT function to Calc spreadsheets. Open thi...
Calc is OpenOffice’s spreadsheet application with which you can set up tables that include fields and records. So you can set up flat-file (single table) databases with the package. However, the software doesn’t includ...
OpenOffice applications have a variety of options. Its Drawing toolbar includes options that you can add shapes to documents with. In addition, you can also add 3D effects to those shapes. Open a OpenOffice application such as Wri...
